Cyber Monday 2023! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: CM25OFF
Welcome to Pass4Success

- Free Preparation Discussions

Cloudera CCA175 Exam

Certification Provider: Cloudera
Exam Name: CCA Spark and Hadoop Developer
Number of questions in our database: 96
Exam Version: Nov. 23, 2023
CCA175 Exam Official Topics:
  • Topic 1: Understand the fundamentals of querying datasets in Spark/ Write the results back into HDFS using Spark
  • Topic 2: Write queries that calculate aggregate statistics/ Load data from HDFS for use in Spark applications
  • Topic 3: Use meta store tables as an input source or an output sink for Spark applications/ Filter data using Spark
  • Topic 4: Generate reports by using queries against loaded data/ Produce ranked or sorted data
  • Topic 5: Perform standard extract, transform, load (ETL) processes on data using the Spark API/ Join disparate datasets using Spark
  • Topic 6: Use Spark SQL to interact with the meta store programmatically in your applications/ Read and write files in a variety of file formats

Free Cloudera CCA175 Exam Actual Questions

The questions for CCA175 were last updated On Nov. 23, 2023

Question #1

Problem Scenario 92 : You have been given a spark scala application, which is bundled in jar named hadoopexam.jar.

Your application class name is com.hadoopexam.MyTask

You want that while submitting your application should launch a driver on one of the cluster node.

Please complete the following command to submit the application.

spark-submit XXX -master yarn \

YYY SSPARK HOME/lib/hadoopexam.jar 10

Reveal Solution Hide Solution
Correct Answer: B

Question #2

Problem Scenario 95 : You have to run your Spark application on yarn with each executor Maximum heap size to be 512MB and Number of processorcores to allocate on each executor will be 1 and Your main application required three values as input arguments V1 V2 V3.

Please replace XXX, YYY, ZZZ

./bin/spark-submit -class com.hadoopexam.MyTask --master yarn-cluster--num-executors 3 --driver-memory 512m XXX YYY lib/hadoopexam.jarZZZ

Reveal Solution Hide Solution
Correct Answer: A

Question #3

Problem Scenario 96 : Your spark application required extra Java options as below. -XX:+PrintGCDetails-XX:+PrintGCTimeStamps

Please replace the XXX values correctly

./bin/spark-submit --name "My app" --master local[4] --conf spark.eventLog.enabled=talse --conf XXX hadoopexam.jar

Reveal Solution Hide Solution
Correct Answer: A

Question #4

Problem Scenario 76 : You have been given MySQL DB with following details.

user=retail_dba

password=cloudera

database=retail_db

table=retail_db.orders

table=retail_db.order_items

jdbc URL = jdbc:mysql://quickstart:3306/retail_db

Columns of order table : (orderid , order_date , ordercustomerid, order_status}

.....

Please accomplish following activities.

1. Copy "retail_db.orders" table to hdfs in a directory p91_orders.

2. Once data is copied to hdfs, using pyspark calculate the number of order for each status.

3. Use all the following methods to calculate the number of order for each status. (You need to know all these functions and its behavior for real exam)

- countByKey()

-groupByKey()

- reduceByKey()

-aggregateByKey()

- combineByKey()

Reveal Solution Hide Solution
Correct Answer: B

Question #5

Problem Scenario 94 : You have to run your Spark application on yarn with each executor 20GB and number of executors should be 50.Please replace XXX, YYY, ZZZ

export HADOOP_CONF_DIR=XXX

./bin/spark-submit \

-class com.hadoopexam.MyTask \

xxx\

-deploy-mode cluster \ # can be client for client mode

YYY\

222 \

/path/to/hadoopexam.jar \

1000

Reveal Solution Hide Solution
Correct Answer: A


Unlock all CCA175 Exam Questions with Advanced Practice Test Features:
  • Select Question Types you want
  • Set your Desired Pass Percentage
  • Allocate Time (Hours : Minutes)
  • Create Multiple Practice tests with Limited Questions
  • Customer Support
Get Full Access Now
Disscuss Cloudera CCA175 Topics, Questions or Ask Anything Related

Save Cancel