Loading demo links...
What to study for each CDP-4001 domain
Use Cloudera Data Visualizations
Covers understanding Cloudera Data Visualizations and building dashboards from datasets based on Hive and Impala connections. Analysts create visuals by placing dimensions and measures on shelves, apply dashboard filters, and share finished dashboards with appropriate view or edit access.
Key skills
Builds dashboards and visuals from datasets, configures filters, and shares dashboards with users and groups.
Use Apache Hive and Impala
Covers identifying the databases and tables in Impala needed for a task and inspecting them with SHOW and DESCRIBE. It includes formatting and converting data types with CAST and string and date functions, joining tables, and working with primary and foreign keys to find correct join paths.
Key skills
Discovers databases and tables, converts and formats data types, joins tables, and uses primary and foreign keys in queries.
Use Apache Ranger and Atlas
Covers inspecting data lineage in Apache Atlas to understand sources, processes, and downstream impact. It also covers how access policies in Apache Ranger control and mask data access, and the role of the data steward in curating metadata, classifications, and governed access.
Key skills
Inspects Atlas lineage, interprets Ranger access and masking policies, and applies data steward governance practices.
Use Apache Hive and Impala SQL
Covers creating new tables and views with Hive and Impala SQL, including CREATE TABLE AS SELECT and CREATE TABLE LIKE. Views are treated as stored query definitions that reflect current base-table data and can be joined and filtered like tables.
Key skills
Creates tables and views, materializes query results with CTAS, and copies table schemas with CREATE TABLE LIKE.
Calculate Aggregate Statistics
Covers working with aggregate functions such as COUNT, SUM, AVG, MIN, MAX, and STDDEV to summarize data. It includes grouping with GROUP BY, filtering groups with HAVING, counting distinct values, handling NULLs in aggregates, and producing subtotals with rollup-style grouping.
Key skills
Computes counts, sums, averages, and dispersion with aggregate functions grouped and filtered to answer business questions.
Hive and Impala Optimization
Covers pushing filter conditions down to the storage layer, using bucketing to co-locate join keys, and optimizing file formats with columnar storage such as Parquet and ORC. It also covers working with COMPUTE STATS so the Impala planner has current table and column statistics.
Key skills
Applies predicate pushdown, bucketing, columnar file formats, partition pruning, and COMPUTE STATS to speed up queries.
Data Management and Storage
Covers understanding where and how data is stored and accessed in HDFS under database and table directories. It includes the different lifecycles of external and managed tables, using partitioning to organize data, and the ways to store query results into a table or an HDFS directory.
Key skills
Explains HDFS storage layout, distinguishes managed from external tables, uses partitioning, and stores query results correctly.
Cloudera Data Warehouse
Covers understanding how to manage virtual warehouses, including sizing, scaling, and auto-suspend for isolated workloads over shared data. It also covers the use of the Data Catalog service to discover assets and view schemas, profiling statistics, and lineage.
Key skills
Manages virtual warehouses for isolated, right-sized compute and uses the Data Catalog service for discovery and governance.