CCA Data Analyst (CCA159) Certification
CCA Data Analyst (CCA159) Exam enables the successful candidates to be able to perform core competencies required to pull and generate reports in Cloudera’s CDH environment using Impala and Hive. This certification can prove to be an asset to your resume and help you explore better career options. Cloud computing has been ruling the IT sector over the past decade. Emergence of cloud concepts have led many businesses and other organizations to rely upon cloud computing for their day to day activities. Watching the increasing need for understanding the cloud concepts, the need for professionals into this field has also gone so far. This has led to establishment of huge demand for data analysts who can analyze the data stored over the clouds. Let us get into details of the exam and learn about some learning resources.
What is CCA Data Analyst (CCA159) Exam?
A SQL developer who earns the Cloudera Certified Data Analyst credential is able to perform core competencies required to pull and generate reports in Cloudera’s CDH environment using Impala and Hive. The credential is earned after successfully passing the CCA Data Analyst Exam (CCA159).
Exam overview
CCA Data Analyst Exam consists of 8–12 performance-based (hands-on) tasks on a Cloudera Enterprise cluster. Time allowed for the exam is 120 minutes. cost of taking the exam is $295 and you have to obtain at least 70% marks in order to clear the exam. the exam is only available in English language.
A score report will be emailed to you within 3 business days of your scheduled exam. If you have passed the exam, you will receive your digital certificate and license number within 5 business days of taking the exam.
| Name of the exam | CCA Data Analyst Exam |
| Exam code | CCA159 |
| No. of questions asked | 8–12 performance-based (hands-on) tasks on a Cloudera Enterprise cluster |
| Passing score | 70% |
| Duration of the exam | 120 minutes |
| Language available | English |
| Cost of taking the exam | $295 |
| Registration platforms | Examslocal |
Exam question format
You are given 8-12 customer problems with a unique large data set, a CDH cluster, and 120 minutes. For each problem, you must implement a technical solution with a high degree of precision that meets all the requirements. You must possess enough knowledge to analyze the problem and arrive at an optimal approach given the time allowed. You need to know what you should do and then do it on a live cluster, including a time limit and while being watched by a proctor.
Audience and prerequisites
Candidates for CCA Data Analyst can be SQL developers, data analysts, business intelligence specialists, developers, system architects, and database administrators. There are no prerequisites for the exam.
Registration policy
Follow the following steps to register for your CCA Data Analyst Exam:
- Create an account at www.examslocal.com. You MUST use the exact same email you used to register on university.cloudera.com.
- Select the exam you purchased from the drop-down list (type Cloudera to find our exams).
- Choose a date and time you would like to take your exam. You must schedule a minimum of 24 hours in advance.
- Select an available time slot for your exam. Time slots are first come, first serve.
- Pass the compatibility tool and install the screen sharing Chrome Extension.
Rescheduling policy
If you want to reschedule the exam then you must inform ‘Innovative Exams’ at least 24 hours prior to your scheduled date. If you inform within 24 hours then it will lead to forfeiture of your exam fees. All exams are non-refundable and non-transferable. All exam purchases are valid for one year from date of purchase.
Other exam policies
In order to know about all the exam policies and other important terms & conditions of the exam, you must pay a visit to the official site. Make sure to gather all the details about the exam in order to not to miss out on anything important.
To know more about the exam, you can also visit: CCA159 certification FAQs
Required Skills (syllabus for CCA159)
Provide Structure to the Data
- Use Data Definition Language (DDL) statements to create or alter structures in the metastore for use by Hive and Impala.
- Create tables using a variety of data types, delimiters, and file formats
- Create new tables using existing tables to define the schema
- Improve query performance by creating partitioned tables in the metastore
- Alter tables to modify existing schema
- Create views in order to simplify queries
Data Analysis
- Use Query Language (QL) statements in Hive and Impala to analyze data on the cluster.
- Prepare reports using SELECT commands including unions and subqueries
- Calculate aggregate statistics, such as sums and averages, during a query
- Create queries against multiple data sources by using join commands
- Transform the output format of queries by using built-in functions
- Perform queries across a group of rows using windowing functions
Preparatory resources
There are many resources which can be used for preparation. Only the right set of resources can help you to pass the exam. so, you should be very careful while choosing the resources as the will determine your performance. Let us have a look at handful of resources.
Documentations
The official documentations by the vendor are the most authentic and reliable resource for the preparation. You can get detailed information about the evaluation topics of the exam easily. You can find the documentations on the official site through the links given below:
Online community
Online community consists of people with similar interest. So, don’t hesitate to ask your doubts over the community as there is a no better guide than an experienced person. You can also know about others experiences and their strategy. You can also learn about new resources and can even pool resources as per your convenience. Join the community now!
Books
Books are the one of the best resources to prepare for an exam. you can refer to any book as per your convenience and level of understanding. You can find many books online or can refer to book stores or the libraries. One of the book that can be referred to is:
CCA159: Hadoop Data Analyst Exam Hands-on Practice Book and Preparation
Online classes and instructor led training
The online classes and training are built by experts who have complete knowledge about the subject. They help in clearing the concepts and provide with so much insightful information. There are many reliable educational sites that provide you with the quality content.
Practice papers and test series
Practice papers and test series can prove to be so much beneficial for your preparation. They help you in identification of your weak portions and help you improve to greater extend. You can identify your loophole and then avoid them in exams. You can try a free practice test now! There are many reliable sites that provide you with quality content and reliable material.
Validate your skills and enhance your resume by taking the CCA Data Analyst Exam. Start preparing for the CCA Data Analyst Exam now!