Courseiva
← Back to Databricks Certified Data Engineer Associate questions

Scenario-based practice

Refer to the Exhibit Practice Questions

Practise Databricks Certified Data Engineer 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-DE-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-DE-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 1mediummultiple choice
Full question →

Refer to the exhibit. An organization needs to ensure that members of the 'analyst_group' can only view data where the region column equals 'US'. Based on the provided configuration, what is the best approach to implement this in Unity Catalog?

Exhibit

{
  "type": "access_control_policy",
  "principal": "analyst_group",
  "action": "SELECT",
  "condition": "WHERE region = 'US'"
}
Question 2mediummultiple choice
Full question →

Refer to the exhibit. A data engineer is attempting to ingest JSON data into a Delta table. Based on the error log, what is the most appropriate transformation step to implement before loading this data into the production table?

Exhibit

{
  "operation": "INSERT",
  "source_format": "JSON",
  "target_table": "raw_data",
  "constraint": "NOT NULL",
  "status": "FAILED",
  "error": "java.lang.NullPointerException: Value at column 'user_id' is null"
}
Question 3mediummultiple choice
Full question →

Refer to the exhibit. A data engineer is deploying an automated job. Based on the provided configuration, what is the primary benefit of using the 'autoscale' attribute in this cluster definition?

Exhibit

{
  "cluster_name": "analytics-cluster",
  "spark_version": "14.3.x-scala2.12",
  "node_type_id": "i3.xlarge",
  "autoscale": {
    "min_workers": 2,
    "max_workers": 8
  },
  "policy_id": "policy-12345"
}
Question 4hardmultiple choice
Full question →

Refer to the exhibit. A data engineer receives this error when collecting data from a large transformation back to the driver node. Which approach should be used to fix this issue?

Exhibit

Error: org.apache.spark.SparkException: Job aborted due to stage failure: Total size of serialized results of 1000 tasks (2048 MB) is bigger than spark.driver.maxResultSize (1024 MB)
Question 5hardmultiple choice
Full question →

Refer to the exhibit. An engineer applies these configurations to a cluster. What is the primary benefit of enabling the Databricks IO Cache for a workload that involves repeatedly reading the same Delta tables?

Exhibit

spark.conf.set("spark.databricks.io.cache.enabled", "true")
spark.conf.set("spark.databricks.io.cache.maxDiskUsage", "50g")
Question 6hardmultiple choice
Full question →

Refer to the exhibit. A data engineer is configuring an IAM policy for a Databricks storage credential. Which of the following is the most significant security risk in this configuration?

Exhibit

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

Refer to the exhibit. A data engineer encounters this error while trying to list tables in a schema. Based on the error, what must the engineer do to resolve it?

Exhibit

Error: [UNAUTHORIZED_ACCESS] User does not have sufficient privileges to perform this operation. Required privilege: 'USE CATALOG' on catalog 'main'.
Question 8hardmultiple choice
Full question →

Refer to the exhibit. A data engineer is attempting to run a VACUUM command on a table, but the command fails with an error indicating that the retention period is too short. Given the configuration, what is the most appropriate action the engineer should take to safely remove files older than 7 days?

Exhibit

--- Config Snippet ---
spark.databricks.delta.retentionDurationCheck.enabled = true
spark.databricks.delta.logRetentionDuration = interval 30 days
Question 9hardmultiple choice
Full question →

Refer to the exhibit. The streaming pipeline is experiencing memory issues because the state store size increases continuously. What is the most effective way to address this while maintaining aggregation accuracy?

Exhibit

{
  "source": "Kafka",
  "processing": "Structured Streaming",
  "issue": "State store is growing indefinitely.",
  "current_code": "df.groupBy('user_id').count().writeStream..."
}
Question 10mediummultiple choice
Full question →

Refer to the exhibit. A CI/CD pipeline running a Databricks CLI command fails with the error shown. What is the most likely cause?

Exhibit

Error: { "error_code": "INVALID_PARAMETER_VALUE", "message": "The workspace path /Users/dev/notebooks does not exist." }
Question 11hardmultiple choice
Full question →

Refer to the exhibit. A CI/CD pipeline fails with the provided error. What is the most likely cause?

Network Topology
Command: databricks repos updatepath /Repos/user@domain.com/my-repobranch mainError: 403 Forbidden
Question 12hardmultiple choice
Full question →

Refer to the exhibit. When is this job scheduled to run?

Exhibit

{
  "job_id": 123,
  "settings": {
    "name": "Daily_Ingestion",
    "tasks": [{
      "task_key": "ingest",
      "spark_jar_task": { "main_class_name": "com.example.Ingest" }
    }],
    "schedule": { "quartz_cron_expression": "0 0 12 * * ?" }
  }
}
Question 13mediummultiple choice
Full question →

Refer to the exhibit. A data engineer is configuring an Auto Loader stream with the provided options. What will happen if a new JSON file arrives containing a field that is not currently in the target table schema?

Exhibit

{
  "cloudFiles.format": "json",
  "cloudFiles.schemaLocation": "/mnt/bronze/schemas/orders",
  "cloudFiles.inferColumnTypes": "true",
  "cloudFiles.schemaEvolutionMode": "addNewColumns"
}
Question 14hardmultiple choice
Full question →

Refer to the exhibit. A Databricks administrator is using the Unity Catalog JSON policy to manage access. If the 'data_scientist_1' user attempts to execute an 'UPDATE' command on the 'orders' table, what will be the result?

Exhibit

{
  "catalog": "main",
  "schema": "dev_analytics",
  "table": "orders",
  "permissions": {
    "user": "data_scientist_1",
    "privileges": ["SELECT", "DESCRIBE"]
  }
}
Question 15hardmultiple choice
Full question →

Refer to the exhibit. The merge operation is failing in your pipeline. What is the root cause of this error, and how should it be resolved?

Exhibit

{
  "operation": "MERGE INTO target USING source ON target.id = source.id",
  "when_matched": "UPDATE SET target.val = source.val",
  "when_not_matched": "INSERT *",
  "error": "java.lang.IllegalArgumentException: Multiple source rows matched one target row"
}

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