
Prepare for the Cloudera CCRA 175 exam with a hands-on Spark and Hadoop practice series, featuring 30 problems, a pre-configured virtual machine, and ready-to-use datasets and notebooks.
Install Oracle Virtual Box to run the Verulam Blue VM, which ships a Spark Hadoop cluster with Hive and Zeppelin for hands-on big data exploration.
Boot the Virgin Blue VM by clicking the Oracle VM shortcut, select the Farallon Blue cca175 environment, press start, then resize desktop and use Spock, Hive, and the Zeppelin notebook.
Spin up a Hadoop cluster with Hive metastore by clicking the spin up icon, and verify seven processes are running. Shut down cluster services with the deprecated stop command.
Launch cluster, open the problems icon to access a terminal for the spark shell and a file with all problems, and practice answering data analysis questions by querying the database.
Launch the Apache Zeppelin notebook by clicking its icon, write and run your solutions in the browser, and explore the included solutions and Zeppelin tutorial.
Join customers and orders to count each customer's orders, returning first name, last name, and the number of orders, then save as a compressed parquet table in School DBI.
Identify customers without orders by joining customers and orders tables, preview the data, and craft a spark query to save results as a table in the School DBE.
Read HDFC credit cards data into a dataframe, create a temp view, and run sql queries to identify individuals with more than five cards; save results as tab-delimited GCIB file.
Read sales records into a data frame, create a temp view, and run SQL queries to calculate total profits by item type for Asia and Europe, then verify saved results.
Perform an inner join of the address and gps tables on practice code to calculate spends for gp practices, aggregating cost into columns: practice code, surgery name, and practice spent.
*Important Notice*
This course has been retired and is no longer receiving support. Originally designed to help students pass the now-retired Cloudera Certification exams, the material remains useful for those wanting to practice their skills on Spark and Hadoop clusters. However, its primary focus was certification preparation, which many students successfully completed.
Prepare for the data analysis section of the CCA Spark & Hadoop Developer certification and help pass the CCA175 exam.
Students enrolling on this course can be 100% confident that after working on the problems contained here they will be in a great position to pass the data analysis section of the CCA175 exam.
As the number of vacancies for big data, machine learning & data science roles continue to grow, so too will the demand for qualified individuals to fill those roles.
It’s often the case the case that to stand out from the crowd, it’s necessary to get certified.
This exam preparation series has been designed to help YOU pass the Cloudera certification CCA175, this is a hands-on, practical exam where the primary focus is on using Apache Spark to solve Big Data problems.
On solving the problems contained here you’ll have all the necessary skills & the confidence to handle any data analysis related questions that come your way in the exam.
(a) There are 30 problems in this part of the exam preparation series. All of which are directly related to the data analysis component of the CCA175 exam syllabus.
(b) Fully worked out solutions to all the problems.
(c) Also included is the Verulam Blue virtual machine which is an environment that has a spark Hadoop cluster already installed so that you can practice working on the problems.
• The VM contains a Spark stack which allows you to read and write data to & from the Hadoop file system as well as to store metastore tables on the Hive metastore.
• All the datasets you need for the problems are already loaded onto HDFS, so you don’t have to do any extra work.
• The VM also has Apache Zeppelin installed with fully executed Zeppelin notebooks that contain solutions to the problems.