How does sorting data within partitions affect query performance?

It has no effect on query performance.

It only affects the write performance, not the read performance.

It can improve performance by enabling efficient data skipping and reducing shuffle in some operations.

It always slows down queries because sorting adds overhead.

What is the purpose of bucketing a table in Spark SQL?

To organize data into a fixed number of files based on a hash of the bucketing column.

To partition the table by the bucketing column.

To sort the data globally by the bucketing column.

To compress the data to save storage space.

A data engineering team wants to create a table that is managed by Spark and automatically dropped when the table is dropped. They also need the table to be partitioned by `year` for efficient retrieval. Which code snippet should they use?

df.write.partitionBy("year").saveAsTable("sales_by_year")

df.write.option("path", "/mnt/sales").partitionBy("year").saveAsTable("sales_by_year")

df.createOrReplaceTempView("sales_by_year")

df.write.bucketBy(8, "year").saveAsTable("sales_by_year")

A company has an existing external table that references data in a cloud storage bucket. They want to convert it to a managed table without copying the data. Which approach should they take?

Create a new managed table by reading the external table and using `saveAsTable` without a path

It is not possible to convert an external table to a managed table without moving data

Use `ALTER TABLE ... SET LOCATION` to change the table type

Drop the external table and recreate it as a managed table with the same location

DatabricksCertified Associate Developer for Apache Spark

Domain 2Objective 3

Save Data to Persistent Tables While Applying Sorting and Partitioning to Optimize Data Retrieval. ASSOCIATE-DEVELOPER-APACHE-SPARK Practice Questions (Page 4)

Part of the Using Spark SQL domain, which accounts for 20% of the ASSOCIATE-DEVELOPER-APACHE-SPARK exam. Databricks does not publish an official question count, but from its 90-minute exam (~35–60 total, ~7–12 in this domain), expect 2–3 from this objective — we provide 22 practice questions to prepare you well beyond it. (estimate)

22questions here

5free pages

7concepts

20%of the exam

Questions 16–20

16foundation · easy
Which clause is used to partition a table by one or more columns when saving a DataFrame?
Select an answer first
17foundation · easy
How does sorting data within partitions affect query performance?
Select an answer first
18foundation · easy
What is the purpose of bucketing a table in Spark SQL?
Select an answer first
19application · medium
A data engineering team wants to create a table that is managed by Spark and automatically dropped when the table is dropped. They also need the table to be partitioned by `year` for efficient retrieval. Which code snippet should they use?
Select an answer first
20expert · hard
A company has an existing external table that references data in a cloud storage bucket. They want to convert it to a managed table without copying the data. Which approach should they take?
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.