Cloudera makes bold bet on strategic acquisition of Verta’s Operational AI Platform Read the blog

CDP Data Analyst Exam Guide CDP-4001


This CDP Data Analyst exam tests the required Cloudera skills and knowledge required for data analysts to be successful in their role. The exam tests the use of Cloudera products such as Cloudera Data Visualization and Cloudera Data Warehouse. The exam also covers Apache Hive, Impala, Ranger and Atlas.

Exam Details

  • Exam Number: CDP-4001
  • Number of questions: 50
  • Duration: 120 minutes
  • Pass Score: 60%
  • Delivery: Online, proctored
    • Please review the system requirements to enable online, proctored testing through QuestionMark
  • Allowed resources: None. You may not use reference materials, white papers, user guides or any other resources during your exam
  • Support: If you need help, please email us.

Cloudera Skills & Knowledge Measured

This exam measures the skills and knowledge topics listed in Table 1. below. The weighting of each topic is also listed.

Topic WEIGHT (% of exam)

Use Cloudera Data Visualizations

  • Understand Data Visualizations
  • Build a Dashboard

Use Apache Hive and Impala

  • Identify databases/tables within Impala that you need to pull data from
  • Format and convert data types
  • Join tables
  • Work with primary and foreign keys

Use Apache Ranger and Atlas

  • Inspect lineage in Apache Atlas
  • Understand that Access Policies in Apache Ranger
  • Understand that the role of a Data Steward

Use Apache Hive and Impala SQL

  • Create new tables or views

Calculator aggregate statistics

  • Work with aggregate functions

Hive and Impala Optimization

  • Understand the use of Pushing the filter condition
  • Understand the use of Bucketing
  • Understand how File format Optimization
  • Work with Compute Stats

Data Management and Storage

  • Understand where/how the data is stored/accessed in HDFS
  • Understand the ways to store query results into a table or directory
  • Different between External and Managed tables
  • Use partitioning

Cloudera Data Warehouse

  • Understand how to manage virtual warehouse
  • Understand the Use of Data Catalog Service

Table 1: Exam topics and weighting

Suggested Training

Although optional, the Cloudera Educational Services courses listed below cover some of the same topics as listed in the table above. Real world, hands-on experience is highly recommended whether you participate in training or not.

Your form submission has failed.

This may have been caused by one of the following:

  • Your request timed out
  • A plugin/browser extension blocked the submission. If you have an ad blocking plugin please disable it and close this message to reload the page.