Courseiva
← Back to Databricks Certified Data Analyst Associate questions

Scenario-based practice

Refer to the Exhibit Practice Questions

Practise Databricks Certified Data Analyst Associate practice questions — original exam-style scenarios covering every exam domain, with detailed explanations, wrong-answer analysis, and common exam traps.

15
scenario questions
Databricks-DA-Assoc
exam code
Databricks
vendor

Scenario guide

How to approach refer to the exhibit practice questions

Practise exhibit-style questions that ask you to read a topology, table, command output or diagram before choosing the best answer.

Quick answer

Exhibit-style questions test whether you can read a topology, command output, diagram or table before choosing the best answer.

How to extract the relevant detail from an exhibit.

How topology, command output or routing information affects the answer.

How to avoid answering from memory before reading the evidence.

How to map the exhibit back to the exam objective.

Related practice questions

Related Databricks-DA-Assoc topic practice pages

Scenario questions usually connect to one or more exam topics. Use these links to review the underlying concepts behind the scenario.

Practice set

Practice scenarios

Question 1hardmultiple choice
Full question →

Refer to the exhibit. You are attempting to enable Change Data Feed (CDF) on an existing Delta table but receive this error. Why is this error occurring?

Exhibit

Error: [DELTA_COLUMN_MAPPING_UNSUPPORTED] Column mapping is required to enable change data feed on this table. Please set 'delta.columnMapping.mode' to 'name'.
Question 2hardmultiple choice
Full question →

Refer to the exhibit. An analyst is reviewing a cluster configuration JSON. If the cluster is currently idle, what happens after 40 minutes of inactivity?

Exhibit

{
  "cluster_config": {
    "cluster_name": "prod_cluster",
    "autoscale": {
      "min_workers": 2,
      "max_workers": 8
    },
    "autotermination_minutes": 30,
    "runtime_version": "11.3.x-scala2.12",
    "node_type_id": "i3.xlarge"
  }
}
Question 3mediummultiple choice
Full question →

Refer to the exhibit. The table 'sales' is partitioned by 'region' and 'order_date'. How does the Databricks SQL engine process this query to ensure optimal performance?

Exhibit

SELECT * FROM sales WHERE order_date >= '2023-01-01' AND region = 'North';
Question 4mediummultiple choice
Full question →

Refer to the exhibit. The execution plan shows a SortMergeJoin with two Exchange nodes. What is the primary cause of the performance impact here?

Exhibit

{
  "query_plan": {
    "node": "SortMergeJoin",
    "children": [
      {"node": "Exchange", "partitioning": "hash(user_id)"},
      {"node": "Exchange", "partitioning": "hash(user_id)"}
    ]
  }
}
Question 5hardmultiple choice
Full question →

Refer to the exhibit. A developer is configuring a Genie Space. The model is still including discounts in its revenue calculations despite the instruction. What is the most likely cause?

Exhibit

{"instructions": "Use the sales_data table for all revenue queries. Ignore discounts.", "data_sources": ["main.sales.sales_data"], "model_parameters": {"temperature": 0.1}}
Question 6hardmultiple choice
Full question →

Refer to the exhibit. A data analyst reviews a physical execution plan where a table is scanned and shuffled multiple times in succession during a self-join operation. What underlying anti-pattern in the query construction likely caused this redundant exchange?

Exhibit

== Physical Plan ==
AdaptiveSparkPlan (isFinalPlan=true)
+- SortMergeJoin [id#8], [id#22], Inner
   +- Sort [id#8 ASC NULLS FIRST], false, 0
      +- Exchange hashpartitioning(id#8, 200), [id#8]
         +- Scan parquet default.table_a
   +- Sort [id#22 ASC NULLS FIRST], false, 0
      +- Exchange hashpartitioning(id#22, 200), [id#22]
         +- Exchange hashpartitioning(id#22, 200), [id#22]
            +- Scan parquet default.table_a
Question 7hardmultiple choice
Full question →

Refer to the exhibit. This IAM policy is attached to a Storage Credential. A user tries to run 'DROP TABLE' on a table stored in this bucket and fails. Why?

Exhibit

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Effect": "Allow",
      "Action": [
        "s3:GetObject",
        "s3:ListBucket"
      ],
      "Resource": "arn:aws:s3:::my-secure-bucket/*"
    }
  ]
}
Question 8hardmultiple choice
Full question →

Refer to the exhibit. A data analyst attempts to run a query in the SQL editor but receives the error displayed. Which action should the administrator take to resolve this?

Exhibit

{
  "status": "403 Forbidden",
  "message": "User does not have CAN_USE permission on SQL Warehouse",
  "error_code": "PERMISSION_DENIED"
}
Question 9mediummultiple choice
Full question →

Refer to the exhibit. Why might the analyst choose to create a new table with 'AS SELECT *' instead of just running OPTIMIZE on the original table?

Exhibit

CREATE TABLE sales_optimized AS SELECT * FROM sales; OPTIMIZE sales_optimized ZORDER BY (customer_id);
Question 10hardmultiple choice
Full question →

Refer to the exhibit. The 'sales_data' table is growing rapidly. You notice queries filtering by 'event_date' are fast, but queries filtering by 'id' are slow. What is the most effective data modeling change to optimize for 'id' lookups?

Exhibit

CREATE TABLE sales_data (id INT, amount DOUBLE, event_date DATE) USING DELTA PARTITIONED BY (event_date);
Question 11hardmultiple choice
Full question →

Refer to the exhibit. Given the provided JSON configuration for a Databricks cluster, what is the primary use case for this resource?

Exhibit

{
  "cluster_type": "all-purpose",
  "runtime": "13.3.x-scala2.12",
  "autoscale": {
    "min": 2,
    "max": 8
  },
  "idle_termination_minutes": 20
}
Question 12hardmultiple choice
Full question →

Refer to the exhibit. An analyst notices that widget 2 is displaying incorrect trends. Based on the configuration provided, what is the most likely cause?

Exhibit

Refer to the exhibit.

[ { "id": 1, "type": "bar", "y_axis": "sales", "x_axis": "date" }, { "id": 2, "type": "line", "y_axis": "revenue", "x_axis": "date" } ]
Question 13hardmultiple choice
Full question →

Refer to the exhibit. An analyst receives this error when attempting to query a table. Which step should they take to fix this?

Exhibit

{
  "query_id": "q-12345",
  "status": "FAILED",
  "error": "Table 'sales_data' not found in catalog 'main' schema 'default'"
}
Question 14hardmultiple choice
Full question →

Refer to the exhibit. An analyst is troubleshooting a performance issue where frequent small inserts into a Delta table result in degraded query performance over time. The exhibit shows the configuration applied. What is the expected behavior of these properties?

Exhibit

ALTER TABLE sales_data SET TBLPROPERTIES ('delta.autoOptimize.optimizeWrite' = 'true', 'delta.autoOptimize.autoCompact' = 'true');
Question 15easymultiple choice
Full question →

Refer to the exhibit. An analyst receives this error when attempting to select from a table in Databricks SQL. What is the most likely cause?

Exhibit

Error: [TABLE_OR_VIEW_NOT_FOUND] The table or view 'sales_data' cannot be found. Verify the schema name and catalog.

These Databricks-DA-Assoc practice questions are part of Courseiva's free Databricks certification practice question bank. Courseiva provides original exam-style Databricks-DA-Assoc questions with detailed explanations, topic-based practice, mock exams, readiness tracking, and study analytics.