Support Questions

Find answers, ask questions, and share your expertise
Celebrating as our community reaches 100,000 members! Thank you!

CCA 175 Certification - Study Material

New Contributor



I want to take up new CCA175 certification sometime in January. Can someone provide details on Study materials i can refer to prepare for this exam. Since this certification is pretty new, I don't see much references on google.


Master Collaborator
Our Cloudera Developer Training for Spark and Hadoop  teaches you everything you need to know for the exam and gives you days worth of hands-on practice. We both train and test the same objectives (although we train on more of course) If you do not wish to take our training or cannot afford it, there are hundreds of free resources on the internet.

For example, if I point my browser to the List of objectives from our website. I then copy the first objective and search on it, I get dozens of free docs and training on the skill.

• Import data from a MySQL database into HDFS using Sqoop
• s qoop.apache.orgdocs on importing data using Sqoop • Importing Data into HDFS using Sqoop
• Video demonstration of user importing data from MySQL to HDFS using Sqoop

And there are dozens more. As the exam page also tells you that you have access to some of these during the exam, I suggest becoming intimate with the those.

If you take some time to search each objective and learn the skill, the exam will be easy. If you don’t want to take the time to learn on your own, and you’re not learning on your job, then training is your answer. This is always true, of all technical skills, not just this one exam. And part of the learning is figuring out which free resources are the best if that’s the route you choose to go, or which paid ones are.

As for the style of question, it’s quite straightforward: for the above objective, you’ll be given the location of a MySQL database on one of the nodes and you’ll be required to use Sqoop to import a portion or all of that data from the MySQL instance we give to the instance of HDFS we give you. It's really that straightforward if you take the time to learn the skills.

View solution in original post

Super Collaborator

The CCA-175 exam is a hands-on, scenario-driven test.  You will be asked to solve problems.  The grading will be based on the solutions that you provide.  We do not evaluate the tools or the code that you used to solve the problems.


Can you use Pig?  Absolutely.  It may be possible to solve every one of the problems on the exam using just Pig if you are an expert.  It may not be practical, however.  There may be better tools for interacting with the Hive metastore to do DDL, such as Impala, Hive, HUE, HCatalog, etc. Similarly, the coding questions will give you Spark templates to add code to.  You may not have enough time in the exam to code everything from scratch in Pig.  Pig is not listed in the Required Skills, because there will not be a specific question where you are required to use Pig on the exam.


The Required Skills section contains this line:

  • Use Data Definition Language (DDL) to create tables in the Hive metastore for use by Hive and Impala.


There is no contradiction.  This is a "problem solving exam" as opposed to a "tools exam".  You will need to be able to use Hadoop tools to generate solutions, but the tool that you use is up to you.

View solution in original post



You mark this as solved ... But, that is not correct. It is not solved...


We understand Cloudera Training provides all the necessary information for this exam... 


Any certification should provide study materials...


Especially when the training is not mandatory and also for those who don't want to take an expensive training (not all will be able to take it) and may want to use a study material and do the hands-on on their own to get this certification...


It will be great If Cloudera could provide a study material (paid one) for this course (I am not talking about a free study material)... 



Community Manager

Hi @RamkSrid,


The original poster of the thread felt their question was resolved and marked it as such. Can you further explain what you feel should be included in a low cost study material for the exam?

Cy Jervis, Manager, Community Program
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

New Contributor

uma, did u get reply.

help me aswel for CDH certification planning to give in dec


New Contributor
Darn, scala and python. I was thinking I could just breeze through with Python

New Contributor


The below youtube playlist will be enough for the certificate. I am using it and all my other friends who already passed the exam liked it and said that it is enough to clear the CCA175..

New Contributor

At a good price, there is a course at Udemy cca175 from ITversity. They also have labs.