5-Part Webinar Series   A Visionary Future with Enterprise GenAI | Nov 20

 Register now
    • Cloudera Cloudera
    • X
    Call us at(888) 789-1488
    International:+1 (650) 362-0488
    Email Sales
    Support Portal

    CDP Data Analyst Exam Guide CDP-4001

    Audience

    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
    		 10%

    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
    		 20%

    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
    		 10%

    Use Apache Hive and Impala SQL

    • Create new tables or views
    		 8%

    Calculator aggregate statistics

    • Work with aggregate functions
    		 20%

    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
    		 12%

    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
    		 10%

    Cloudera Data Warehouse

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

    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.