CCA159 CCA Data Analyst Exam Preparation Notes
and Practice
CCA159 CCA Data Analyst Exam – 200+ Practice Questions (2026 Edition)
Below is a comprehensive 200+ question test bank for the CCA Data Analyst
Exam (CCA159). All questions are based on the official exam objectives and
verified by industry sources. Note: This exam is RETIRED as of March 2025, but
the content remains valuable for learning Hive and Impala skills .
PART 1: EXAM OVERVIEW
CCA159 Exam Details
| Feature | Detail |
|:|:|
| Exam Code | CCA159 |
| Number of Questions | 8–12 performance-based (hands-on) tasks |
| Time Limit | 120 minutes |
| Passing Score | 70% |
| Format | Hands-on, practical exam on a Cloudera Enterprise cluster |
| Language | English |
| Status | RETIRED as of March 2025 |
1
,Important Note: The CCA Data Analyst (CCA159) exam is marked as RETIRED
as of March 2025. Check the Cloudera website for current exam offerings. The
content below remains valuable for learning Hive and Impala skills .
Exam Format
The CCA159 exam is performance-based, meaning you are given a live cluster and
a set of customer problems to solve :
- You receive 8–12 customer problems with unique datasets
- You must implement a technical solution that meets all requirements with high
precision
- You have 120 minutes to complete all tasks
- You work on a live CDH cluster while being watched by a proctor
- The exam is graded immediately; score reports are emailed within three days
Documentation Available During Exam
Only specific documentation, links, and resources listed by Cloudera are accessible
during the exam. All other websites, including Google and search functionality, are
disabled .
2
,PART 2: REQUIRED SKILLS
The exam covers three main competency areas :
1. Prepare the Data
| Skill | Description |
|:|:|
| Sqoop Import | Import data from a MySQL database into HDFS using Sqoop |
| Sqoop Export | Export data to a MySQL database from HDFS using Sqoop |
| Data Transformation | Move data between tables in the metastore; transform
values, columns, or file formats |
2. Provide Structure to the Data
| Skill | Description |
|:|:|
| DDL Statements | Create or alter structures in the metastore for Hive and Impala |
| Create Tables | Use a variety of data types, delimiters, and file formats |
| Partitioned Tables | Improve query performance by creating partitioned tables |
| Alter Tables | Modify existing schema |
3
, | Views | Create views to simplify queries |
3. Data Analysis
| Skill | Description |
|:|:|
| SELECT Commands | Including unions and subqueries |
| Aggregate Statistics | Calculate sums, averages, and other statistics |
| Joins | Create queries against multiple data sources |
| Built-in Functions | Transform the output format of queries |
| Window Functions | Perform queries across a group of rows |
PART 3: PRACTICE QUESTIONS (1-50)
Section A: Data Preparation & Sqoop (Questions 1-15)
Q1. A data analyst needs to import a table from a MySQL database into HDFS for
analysis. Which Sqoop command is correct?
4
and Practice
CCA159 CCA Data Analyst Exam – 200+ Practice Questions (2026 Edition)
Below is a comprehensive 200+ question test bank for the CCA Data Analyst
Exam (CCA159). All questions are based on the official exam objectives and
verified by industry sources. Note: This exam is RETIRED as of March 2025, but
the content remains valuable for learning Hive and Impala skills .
PART 1: EXAM OVERVIEW
CCA159 Exam Details
| Feature | Detail |
|:|:|
| Exam Code | CCA159 |
| Number of Questions | 8–12 performance-based (hands-on) tasks |
| Time Limit | 120 minutes |
| Passing Score | 70% |
| Format | Hands-on, practical exam on a Cloudera Enterprise cluster |
| Language | English |
| Status | RETIRED as of March 2025 |
1
,Important Note: The CCA Data Analyst (CCA159) exam is marked as RETIRED
as of March 2025. Check the Cloudera website for current exam offerings. The
content below remains valuable for learning Hive and Impala skills .
Exam Format
The CCA159 exam is performance-based, meaning you are given a live cluster and
a set of customer problems to solve :
- You receive 8–12 customer problems with unique datasets
- You must implement a technical solution that meets all requirements with high
precision
- You have 120 minutes to complete all tasks
- You work on a live CDH cluster while being watched by a proctor
- The exam is graded immediately; score reports are emailed within three days
Documentation Available During Exam
Only specific documentation, links, and resources listed by Cloudera are accessible
during the exam. All other websites, including Google and search functionality, are
disabled .
2
,PART 2: REQUIRED SKILLS
The exam covers three main competency areas :
1. Prepare the Data
| Skill | Description |
|:|:|
| Sqoop Import | Import data from a MySQL database into HDFS using Sqoop |
| Sqoop Export | Export data to a MySQL database from HDFS using Sqoop |
| Data Transformation | Move data between tables in the metastore; transform
values, columns, or file formats |
2. Provide Structure to the Data
| Skill | Description |
|:|:|
| DDL Statements | Create or alter structures in the metastore for Hive and Impala |
| Create Tables | Use a variety of data types, delimiters, and file formats |
| Partitioned Tables | Improve query performance by creating partitioned tables |
| Alter Tables | Modify existing schema |
3
, | Views | Create views to simplify queries |
3. Data Analysis
| Skill | Description |
|:|:|
| SELECT Commands | Including unions and subqueries |
| Aggregate Statistics | Calculate sums, averages, and other statistics |
| Joins | Create queries against multiple data sources |
| Built-in Functions | Transform the output format of queries |
| Window Functions | Perform queries across a group of rows |
PART 3: PRACTICE QUESTIONS (1-50)
Section A: Data Preparation & Sqoop (Questions 1-15)
Q1. A data analyst needs to import a table from a MySQL database into HDFS for
analysis. Which Sqoop command is correct?
4
