Cloudera Hadoop Developer Certification Questions and Answer (Dumps and Practice Questions)

Question : Which project provides prgramatic access like JDBC or ODBC of the data stored in HDFS

1. Hive
2. Pig
3. OOzie
4. Flume

Correct Answer : 1

Apache Hive :

You can use Hive, to fetch the already stored data in HDFS, with the HiveServer class. Which provides JDBC like interface.

Hive is an abstraction on top of MapReduce
Allows users to query data in the Hadoop cluster without knowing Java or MapReduce
- Uses the HiveQL language
- Very similar to SQL
- The Hive Interpreter runs on a client machine
- Turns HiveQL queries into MapReduce jobs
- Hive Submits jobs to the cluster
Note: this does not turn the cluster into a relational database server!
It is still simply running MapReduce jobs
Those jobs are created by the Hive Interpreter

Refer HadoopExam.com Recorded Training Module : 12 and 13





Question : Hive stores in table format like RDBMS

1. True
2. False


Correct Answer : 2

Hive is an abstraction on top of MapReduce
Allows users to query data in the Hadoop cluster without knowing Java or MapReduce
- Uses the HiveQL language
- Very similar to SQL
- The Hive Interpreter runs on a client machine
- Turns HiveQL queries into MapReduce jobs
- Hive Submits jobs to the cluster
Note: this does not turn the cluster into a relational database server!
It is still simply running MapReduce jobs
Those jobs are created by the Hive Interpreter

Refer HadoopExam.com Recorded Training Module : 12 and 13





Question : In case of hive, table definition is stored in a metastore

1. true
2. false



Correct Answer : 1

Hives Metastore

- is a database containing table definitions and other metadata
- By default, stored locally on the client machine in a Derby database
- If mulAple people will be using Hive, the system administrator should create a shared Metastore
- Usually in MySQL or some other relaAonal database server

Refer HadoopExam.com Recorded Training Module : 12 and 13

Related Questions

---

Question :

Workflows expressed in Oozie can contain:



1. Iterative repetition of MapReduce jobs until a desired answer or state is reached.
2. Sequences of MapReduce and Pig jobs. These are limited to linear sequences of actions with exception handlers but no forks.
3. Sequences of MapReduce jobs only; no Pig or Hive tasks or jobs. These MapReduce sequences can be combined with forks and path joins.
4. Sequences of MapReduce and Pig. These sequences can be combined with other actions including forks, decision points, and path joins.



Question :

You have an employee who is a Date Analyst and is very comfortable with SQL.
He would like to run ad-hoc analysis on data in your HDFS duster.
Which of the following is a data warehousing software built on top of
Apache Hadoop that defines a simple SQL-like query language well-suited for this kind of user?
A. Pig B. Hue C. Hive D. Sqoop E. Oozie


1. A
2. B
3. C
4. D
5. E



Question :

You need to import a portion of a relational database every day as files to HDFS,
and generate Java classes to Interact with your imported data. Which of the following tools should you use to accomplish this?
A. Pig B. Hue C. Hive D. Flume E. Sqoop F. Oozie G. fuse-dfs


1. A,B
2. B,C
3. C,E
4. F,G



Question :

The size of block in HDFS is

1. 512 Bytes
2. 64 MB
3. 1024 KB
4. None of the above




Question :

To Create Sequence of Multiple MapReduce job (Chaining) same JobConf object is used

1. True
2. False


Question :

Which class/object represent a MapReduce job

1. Job
2. JobControl
3. Access Mostly Uused Products by 50000+ Subscribers