cert-bank

Exams

DBX-ASD Databricks Associate Developer for Apache Spark

Vendor
Databricks
Level
Associate
Questions
45
Time
90 min
Domains
7
In the bank
285

Practice 285 questionsTake a timed mock examDay-by-day study plan

Guides for this exam

The exam at a glance

LevelAssociate
Questions45
Time90 minutes (about 2 minutes per question)
Passing markNot published by the vendor

Domains and weights

DomainWeightPractice questions here
D1 · Apache Spark Architecture and Components20%57
D2 · Using Spark SQL20%57
D3 · Developing Apache Spark DataFrame/DataSet API Applications30%86
D4 · Troubleshooting and Tuning Apache Spark DataFrame API Applications10%29
D5 · Structured Streaming10%28
D6 · Using Spark Connect to Deploy Applications5%14
D7 · Using Pandas API on Spark5%14

D1 · Apache Spark Architecture and Components 20%

Architecture questions ask what Spark does when code runs: which jobs, stages and tasks appear, where memory goes, and what a session shares. Read the code for actions, shuffles and caching. Strong options follow Spark's execution model step by step; weaker ones assume work is reused or shared when it is not.

What to watch for

Tasks in the official exam guide (7)
  • 1.1 Identify the advantages and challenges of implementing Spark
  • 1.2 Identify the roles of core Spark components: cluster, driver, workers/executors, cores and memory
  • 1.3 Describe Spark architecture: DataFrame and Dataset, SparkSession lifecycle, caching, storage levels, garbage collection
  • 1.4 Explain the Spark execution hierarchy
  • 1.5 Configure Spark partitioning, including shuffles and partitions
  • 1.6 Describe execution patterns: actions, transformations and lazy evaluation
  • 1.7 Identify features of Spark modules: Core, Spark SQL, DataFrames, pandas API on Spark, Structured Streaming, MLlib

D2 · Using Spark SQL 20%

Spark SQL questions give a query or a read/write call and ask what it returns or why it fails. Check the save mode, the data source options and how the schema is inferred. Strong options name the exact option or clause that produces the result; weaker ones rely on defaults that behave differently.

What to watch for

Tasks in the official exam guide (4)
  • 2.1 Read and write DataFrames from data sources such as JDBC and files, including overwrite and partitioning by column
  • 2.2 Run SQL directly on files (ORC, JSON, CSV, text, Delta) and understand save modes
  • 2.3 Save data to persistent tables with sorting and partitioning for retrieval
  • 2.4 Register DataFrames as temporary views and query them with SQL

D3 · Developing Apache Spark DataFrame/DataSet API Applications 30%

DataFrame API questions show a few lines of PySpark and ask for the result or the right method. Trace the rows through joins, groupings and nulls by hand. Strong options get the row count and join semantics exactly right; weaker ones treat NULL keys as equal or forget that a grouped count is a DataFrame.

What to watch for

Tasks in the official exam guide (10)
  • 3.1 Manipulate columns, rows and table structures: add, drop, split, rename, filter, explode arrays
  • 3.2 Perform data deduplication and validation on DataFrames
  • 3.3 Perform aggregations: count, approximate count distinct, mean, summary
  • 3.4 Work with dates: Unix epoch to date string, extract date components
  • 3.5 Combine DataFrames: inner, left, broadcast, multi-key and cross joins, union and union all
  • 3.6 Manage input and output: write, overwrite and read DataFrames with schemas
  • 3.7 Sort, iterate, print schema and convert between DataFrames and lists/sequences
  • 3.8 Create and invoke user-defined functions with or without stateful operators, including StateStores
  • 3.9 Describe variable types in Spark: broadcast variables and accumulators
  • 3.10 Describe the purpose and implementation of broadcast joins

D4 · Troubleshooting and Tuning Apache Spark DataFrame API Applications 10%

Tuning questions describe a slow or failing stage and ask for the fix. Read the Spark UI clues: number of tasks, partition sizes, join strategy and where the error happens. Strong options change the one setting or step that matches the symptom; weaker ones add memory or partitions without addressing the cause.

What to watch for

Tasks in the official exam guide (3)
  • 4.1 Tune performance and cluster use: partitioning, repartition, coalesce, data skew and reducing shuffles
  • 4.2 Describe Adaptive Query Execution (AQE) and its benefits
  • 4.3 Use driver and executor logs and monitoring to diagnose out-of-memory errors and underutilization

D5 · Structured Streaming 10%

Structured Streaming questions ask what a query does over time and after failures. The checkpoint, the watermark and the output mode decide most answers. Strong options keep state bounded and recovery exact; weaker ones use batch-only operations or unbounded state.

What to watch for

Tasks in the official exam guide (4)
  • 5.1 Explain the Structured Streaming engine: programming model, micro-batches, exactly-once semantics, fault tolerance
  • 5.2 Create and write streaming DataFrames and Datasets, with basic output modes and sinks
  • 5.3 Perform basic operations on streams: selection, projection, window and aggregation
  • 5.4 Perform streaming deduplication with and without a watermark

D6 · Using Spark Connect to Deploy Applications 5%

Deployment questions ask how a Spark application reaches a cluster: cluster managers, deploy modes and Spark Connect. The deciding detail is where the driver runs and what the client holds. Strong options separate the thin client from the server; weaker ones expect JVM or SparkContext access through Spark Connect.

What to watch for

Tasks in the official exam guide (2)
  • 6.1 Describe the features of Spark Connect
  • 6.2 Describe the deployment modes (Client, Cluster, Local) in Apache Spark

D7 · Using Pandas API on Spark 5%

Pandas API on Spark questions ask when pandas-style code scales and how pandas UDFs work. Check how data is split between workers and what each function receives. Strong options respect the size and shape rules of each API; weaker ones assume one group or one batch can be any size.

What to watch for

Tasks in the official exam guide (2)
  • 7.1 Explain the advantages of the pandas API on Spark
  • 7.2 Create and invoke a pandas UDF

A study order that works

The 17-day study plan for DBX-ASD takes the domains in this order. Each day has a short reading, key terms and a quiz from the bank.

  1. Days 1–3: D1 · Apache Spark Architecture and Components
  2. Days 4–5: D2 · Using Spark SQL
  3. Days 6–10: D3 · Developing Apache Spark DataFrame/DataSet API Applications
  4. Days 11–12: D4 · Troubleshooting and Tuning Apache Spark DataFrame API Applications
  5. Days 13–14: D5 · Structured Streaming
  6. Day 15: D6 · Using Spark Connect to Deploy Applications
  7. Day 16: D7 · Using Pandas API on Spark
  8. Day 17: Final Review: Decision Cheat-Sheet Across the Seven Domains

Recent changes to these questions

About these questions

Every question is original, written from the public exam guide and checked against the vendor's own documentation. None comes from a real exam. Each one has an explanation of why the answer is right and why the other options are wrong. How the questions are written.