Free sample, no account needed

Databricks - Associate Developer for Apache Spark Practice Questions & Free Practice Exam

5 free Databricks - Associate Developer for Apache Spark practice questions below, with instant explanations. The full simulator contains hundreds of exam-style questions across every topic.

Create a free account I already have an account

1Question 1You are here

Joining a 500 MB reference table against a 4 TB transactions table under the default spark.sql.autoBroadcastJoinThreshold of 10 MB produces a sort-merge join in the plan. AQE runs with defaults. Which rewrite can AQE apply at runtime?

2Question 2

During nightly runs, a pipeline computes COUNT(DISTINCT customer_id) over a 3 TB events table and finishes in 12 minutes with heavy shuffle. Analysts accept a relative error near 2 percent for the daily dashboard, and the runtime must drop below 90 seconds. Which SQL rewrite meets both constraints?

3Question 3

Following an experiment run, a research team must load simulation output stored as Parquet files under a directory on shared storage. Which reader chain loads the data using the format shortcut method as shown in the chapter?

4Question 4

Calling `df.cache()` on a DataFrame in Spark 3.5 selects which storage level as the default?

5Question 5

Only one output mode requires the streaming query to contain an aggregation. Which mode is that?

Create a free account and keep going

Free members study the full Databricks - Associate Developer for Apache Spark theory course and get a much larger slice of the question bank, with progress tracking that remembers exactly where they stopped.

Full theory course

Every chapter, free