Hortonworks HADOOP-PR000007 Exam Overview:
| Certification Vendor: | Hortonworks (acquired by Cloudera) |
|---|---|
| Exam Name: | Hortonworks-Certified-Apache-Hadoop-2.0-Developer (Pig and Hive Developer) |
| Exam Number: | HADOOP-PR000007 |
| Passing Score: | 70% |
| Exam Price: | $150 USD |
| Certificate Validity Period: | 2 years |
| Available Languages: | English |
| Exam Format: | Scenario-based questions, Hands-on performance-based tasks |
| Exam Duration: | 120 minutes |
| Related Certifications: | HDP Certified Administrator (HDPCA) |
| Real Exam Qty: | 110 |
| Recommended Training: | Apache Pig & Hive Official Documentation HDP Developer Training |
| Exam Registration: | Cloudera Certification Portal |
| Sample Questions: | Hortonworks HADOOP-PR000007 Sample Questions |
| Exam Way: | Online proctored or authorized test center; retired since 2020 |
| Pre Condition: | No formal prerequisites; hands-on experience with HDP 2.x, Pig, and Hive strongly recommended |
| Official Syllabus URL: | https://www.cloudera.com/services-and-support/training/certification/hdp-cert-exam-faq.html |
Hortonworks HADOOP-PR000007 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Apache Hive Development | 35% | - Hive architecture, metastore, and table management - HiveQL queries, joins, aggregations, and partitioning - Performance tuning and indexing - Data types, serialization, and file formats |
| Data Ingestion & Ecosystem Integration | 5% | - Workflow orchestration with Oozie - Sqoop and Flume usage basics |
| Apache Pig Development | 40% | - Integration with HCatalog and Hive - User-defined functions (UDFs) and optimization - Data transformation, filtering, grouping, and joining - Pig Latin syntax, data loading, and storage |
| Hadoop Fundamentals & HDFS | 20% | - Hadoop 2.0 architecture & YARN - HDFS file operations, permissions, and data management |
Hortonworks-Certified-Apache-Hadoop-2.0-Developer(Pig and Hive Developer) Sample Questions:
Examine the following Hive statements:
Assuming the statements above execute successfully, which one of the following statements is true?
- A. The contents of File1 are parsed as comma-delimited rows and stored in a database
- B. The file named File1 is moved to to/user/joe/x/
- C. Hive reformats File1 into a structure that Hive can access and moves into to/user/joe/x/
- D. The contents of File1 are parsed as comma-delimited rows and loaded into /user/joe/x/
Correct Answer: B 🗳️
Consider the following two relations, A and B.
What is the output of the following Pig commands?
X = GROUP A BY S1; DUMP X;
- A. Option D
- B. Option B
- C. Option C
- D. Option A
Correct Answer: A 🗳️
You use the hadoop fs -put command to write a 300 MB file using and HDFS block size of 64 MB. Just
after this command has finished writing 200 MB of this file, what would another user see when trying to
access this life?
- A. They would see Hadoop throw an ConcurrentFileAccessException when they try to access this file.
- B. They would see no content until the whole file written and closed.
- C. They would see the current of the file through the last completed block.
- D. They would see the current state of the file, up to the last bit written by the command.
Correct Answer: C 🗳️
Which best describes how TextInputFormat processes input files and line breaks?
- A. Input file splits may cross line breaks. A line that crosses file splits is read by the RecordReader of the
split that contains the end of the broken line. - B. Input file splits may cross line breaks. A line that crosses file splits is ignored.
- C. Input file splits may cross line breaks. A line that crosses file splits is read by the RecordReader of the
split that contains the beginning of the broken line. - D. The input file is split exactly at the line breaks, so each RecordReader will read a series of complete
lines. - E. Input file splits may cross line breaks. A line that crosses file splits is read by the RecordReaders of
both splits containing the broken line.
Correct Answer: C 🗳️
What does the following WebHDFS command do?
Curl -1 -L "http://host:port/webhdfs/v1/foo/bar?op=OPEN"
- A. List a directory /foo
- B. Read a file /foo/bar
- C. Make a directory /foo/bar
- D. Delete a directory /foo/bar
Correct Answer: B 🗳️

We're so confident of our products that we provide no hassle product exchange.


By Harriet


