I successfully cleared CCA 175 on 10/13, thanks to Durga sir’s lectures and labs, also thanks to Arun’s blog which helped me a lot during the exam. I got 2 questions from sqoop and 7 questions from spark.
Here are few pointers for everyone who are appearing for the certification.
Before exam day, please watch cloudera’s sample question video, you will understand how to adjust the screen size and how to copy paste using keyboard shortcuts which will help you immensely during exam. The video is at the bottom of the page.
Do not worry about the processing time of the code, as the virtual machine runs on a cluster, the processing will be fast and maximum processing time will be around 2 or 3 mins, during which you can think about the next question.
sqoop export is as important as sqoop import, please try to remember all options for both import and export commands
Stick to writing the queries based on a single api, either dataframes or sqlContext or RDDS, if you are strong sql skills I would recommend using sqlContext for each spark question
The virtual machine will be slow(depends on your internet connection), so I would advice use copy and paste as much as possible and type the rest. The entire examination duration will depend on how fast you write the queries.
6)Keep atleast 15 - 20 mins for verifying the output, it will give you a second chance, if you miss anything.
7)Once you finish Durga sir’s lectures practice questions from Aruns blog. He has covered all the topics, FILE CONVERSIONS and COMPRESSIONS techinques are extremely important.
spark questions are relative easy if you practice Durga sir’s questions and Arun’s blog. But writing the code would take time and your performance mostly depends on how fast you write and execute your queries.
Finally, open separate tabs for hdfs commands, spark shell, hive shell, mysql databases, which will help to navigate easily and verify your outputs.
Please let me know if you need any help or any questions regarding the examination.
A big thanks to Durga sir again and good luck for everyone who are appearing for the exam, you will definitely crack it.