Hortonworks-Certified-Apache-Hadoop-2.0-Developer (HDPCD) Exam Code PR000007 Exam

The HDP Certified Developer (HDPCD) exam is the first of HortonWorks new hands-on, performance-based exams exclusively architected for Hadoop developers who work with frameworks like Pig, Hive, Sqoop and Flume. This HDPCD exam is the initial and manual task-based examination working on Hive, Pig, Flume and Sqoop. This exam enables students to develop Hadoop applications for storing, processing, and analyzing data stored in Hadoop using the open-source tools of the Hortonworks Data Platform (HDP) and including Pig, Hive, Sqoop and Flume.

The exam is based on the Hortonworks Data Platform 2.2 installed and managed with Ambari 1.7.0, which includes Pig 0.14.0, Hive 0.14.0, Sqoop 1.4.5, and Flume 1.5.0. Each candidate has to access to an HDP 2.2 clusters along with a list of tasks to be performed.

Candidates writing HDPCD exam ought to perform the given tasks on Data Ingestion; Data Transformation; and Data Analysis.

The tasks in Data Ingestion are as follows:

  • Input a local file into HDFS using the Hadoop file system shell
  • Make a new directory in HDFS using the Hadoop file system shell
  • Import data from a table in a relational database into HDFS
  • Import the results of a query from a relational database into HDFS
  • Import a table from a relational database into a new or existing Hive table
  • Insert or update data from HDFS into a table in a relational database
  • Given a Flume configuration file, start a Flume agent
  • Given a configured sink and source
  • Configure a Flume memory channel with a specified capacity

Data Transformation Tasks

  • Write and execute a Pig script
  • Load data into a Pig relation without a schema
  • Load data into a Pig relation with a schema
  • Load data from a Hive table into a Pig relation
  • Use Pig to transform data into a specified format
  • Transform data to match a given Hive schema
  • Group the data of one or more Pig relations
  • Use Pig to remove records with null values from a relation
  • Store the data from a Pig relation into a folder in HDFS
  • Store the data from a Pig relation into a Hive table
  • Sort the output of a Pig relation
  • Remove the duplicate tuples of a Pig relation
  • Specify the number of reduce tasks for a Pig MapReduce job
  • Join two datasets using Pig
  • Perform a replicated join using Pig
  • Run a Pig job using Tez
  • Within a Pig script, define an alias for a User Defined Function
  • Within a Pig script, invoke a User Defined Function

Data Analysis Tasks

  • Write and execute a Hive query
  • Define a Hive-managed table
  • Define a Hive external table
  • Define a partitioned Hive table
  • Define a bucketed Hive table
  • Define a Hive table from a select query
  • Define a Hive table that uses the ORCFile format
  • Create a new ORCFile table in an existing non-ORCFile Hive table
  • Specify the storage format of a Hive table
  • Specify the delimiter of a Hive table
  • Load data into a Hive table from a local directory
  • Load data into a Hive table from an HDFS directory
  • Load data into a Hive table as the result of a query
  • Load a compressed data file into a Hive table
  • Update a row in a Hive table
  • Delete a row from a Hive table
  • Insert a new row into a Hive table
  • Join two Hive tables
  • Run a Hive query using Tez
  • Run a Hive query using vectorization
  • Output the execution plan for a Hive query
  • Use a subquery within a Hive query
  • Output data from a Hive query that is totally ordered across multiple reducers
  • Set a Hadoop or Hive configuration property from within a Hive query

Training for Hortonworks-Certified-Apache-Hadoop-2.0-Developer (HDPCD)

We train students appearing for HDPCD certification exam. We have all the necessary infrastructure and trained professional instructors to teach you all about HDPCD exam and how to pass this exam successfully with ease and comfort. Our offline and online classroom training with our professional instructors will help you a great deal. Our study guide materials, HDPCD exam dumps, case studies, solved scenarios, mock tests in an actual exam environment, additional reading materials all contribute to your pass success with guarantee in this Hortonworks-Certified-Apache-Hadoop-2.0-Developer (HDPCD) Exam Code PR000007 Exam.

Copy rights @ 2016 Hortonworks Certification All Reserved