A data analyst has a `sales` DataFrame with a `transaction_id` column. They need to determine the total number of sales transactions recorded. Which method should they use?

Use `summary` on the `transaction_id` column

Use `approx_count_distinct` on the `transaction_id` column

Use `count` on the `transaction_id` column

Use `mean` on the `transaction_id` column

What Spark configuration must be enabled to perform a cross join without an explicit cross join hint?

spark.sql.join.preferSortMergeJoin

spark.sql.autoBroadcastJoinThreshold

What does the count() action return when called on a DataFrame?

A DataFrame with a single row containing the count

A String representation of the count

A Long representing the number of rows

An Int representing the number of rows

DatabricksCertified Associate Developer for Apache Spark

Domain 3Objective 2

Data Aggregation and Joins ASSOCIATE-DEVELOPER-APACHE-SPARK Practice Questions (Page 4)

Part of the Developing Apache Spark™ DataFrame/DataSet API Applications domain, which accounts for 30% of the ASSOCIATE-DEVELOPER-APACHE-SPARK exam. Databricks does not publish an official question count, but from its 90-minute exam (~35–60 total, ~11–18 in this domain), expect 2–4 from this objective — we provide 26 practice questions to prepare you well beyond it. (estimate)

26questions here

6free pages

11concepts

30%of the exam

Questions 16–20

16foundation · easy
Which join hint is used to optimize a join when one DataFrame is small enough to be sent to all executors?
Select an answer first
17application · easy
A data analyst has a `sales` DataFrame with a `transaction_id` column. They need to determine the total number of sales transactions recorded. Which method should they use?
Select an answer first
18foundation · easy
Which aggregation function calculates the average value of a numeric column in a DataFrame?
Select an answer first
19foundation · easy
What Spark configuration must be enabled to perform a cross join without an explicit cross join hint?
Select an answer first
20foundation · easy
What does the count() action return when called on a DataFrame?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to ASSOCIATE-DEVELOPER-APACHE-SPARK

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Databricks. “ASSOCIATE-DEVELOPER-APACHE-SPARK” is a trademark of its owner, used for identification only.

Data Aggregation and Joins ASSOCIATE-DEVELOPER-APACHE-SPARK Practice Questions (Page 4)

Questions 16–20

Which join hint is used to optimize a join when one DataFrame is small enough to be sent to all executors?

A data analyst has a `sales` DataFrame with a `transaction_id` column. They need to determine the total number of sales transactions recorded. Which method should they use?

Which aggregation function calculates the average value of a numeric column in a DataFrame?

What Spark configuration must be enabled to perform a cross join without an explicit cross join hint?

What does the count() action return when called on a DataFrame?

Keep studying — Developing Apache Spark™ DataFrame/DataSet API Applications