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.
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?
Question 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?
Question 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?
Question 4
Calling `df.cache()` on a DataFrame in Spark 3.5 selects which storage level as the default?
Question 5
Only one output mode requires the streaming query to contain an aggregation. Which mode is that?
Ready for the full Databricks - Associate Developer for Apache Spark exam simulator?
Unlock the complete question bank, weighted mock exams, saved-question flashcards, and the Shark AI tutor - all inside your MyCertStack account.
