Courseiva
← Back to Databricks Certified Data Engineer Associate questions

Scenario-based practice

Hard Difficulty 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.

20
scenario questions
Databricks-DE-Assoc
exam code
Databricks
vendor

Scenario guide

How to approach hard difficulty questions

These are the questions most candidates get wrong. They require connecting multiple concepts, reading tricky output, or knowing edge-case behaviour that isn't on most study cards. Practising them trains you to operate under uncertainty — a necessary skill on the real exam.

Quick answer

Hard Difficulty Questions questions test whether you can apply the concept in context, not just recognise a definition.

How the topic appears in realistic exam-style scenarios.

Which detail in the question changes the correct answer.

How to eliminate plausible but wrong options.

How to connect the question back to the wider 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 1hardmultiple choice
Full question →

A data engineer is using Auto Loader to ingest data from a directory that receives thousands of files every hour. They are considering switching from the default directory listing mode to file notification mode. What is the primary reason for making this change?

Question 2hardmulti select
Full question →

A data engineer is designing a secure architecture using the Databricks Intelligence Platform. Which TWO of the following statements accurately describe the role and capabilities of Unity Catalog within this platform? (Choose TWO)

A data engineer is designing a Delta Lake Bronze-to-Silver pipeline using Delta Live Tables (DLT) in Python. The engineer wants to ensure that incoming records are validated for data quality, dropping records that fail null checks on critical ID fields while failing the pipeline for invalid business logic. Which TWO DLT expectation decorators should be used to accomplish this?

Question 4hardmultiple choice
Full question →

A team is using Databricks Asset Bundles (DABs) to deploy a job to multiple environments (dev, staging, prod). They need to ensure that the job uses different cluster sizes and schedules per environment. Which DABs feature should they use?

Question 5hardmultiple choice
Full question →

A data engineer is designing a workflow that requires running a series of tasks with dependencies. The workflow must be able to retry failed tasks automatically and send notifications on failure. The engineer also needs to ensure that the workflow can be triggered on a schedule and via an API. Which Databricks feature should the engineer use?

Question 6hardmulti select
Full question →

A data engineer is configuring Unity Catalog row-level security on a table `prod.finance.transactions`. They want to ensure that users in the `us_team` group can only see rows where `region = 'US'`, while users in the `eu_team` group can only see rows where `region = 'EU'`. They create a row filter function `prod.security.region_filter`. Which TWO statements accurately describe how to implement and manage this row-level security? (Choose two.)

Question 7hardmultiple choice
Full question →

Which of the following best describes the purpose of 'Credential Passthrough' in Databricks?

Question 8hardmulti select
Full question →

A team is transitioning to the Databricks Intelligence Platform. Which TWO actions are required to successfully register a table in Unity Catalog using the three-level namespace?

Question 9hardmultiple choice
Full question →

A data engineer maintains a Delta table where each row represents a customer record, and updates arrive continuously as change data capture events. The engineer needs to apply inserts, updates, and deletes from a staging table into the target table in a single atomic operation, matching records on customer_id. Which Delta Lake operation should be used?

Question 10hardmulti select
Full question →

A data engineering team must implement dynamic row-level filtering on a customer analytics table in Unity Catalog so that regional analysts only view records corresponding to their assigned territory. Which TWO steps are required to achieve this using Unity Catalog features? (Choose 2)

Question 11hardmultiple 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 12hardmultiple choice
Full question →

Refer to the exhibit. An engineer needs to ensure that the cluster can handle sudden increases in data volume while minimizing costs during idle periods. Given the JSON configuration shown, what will happen when the workload demand spikes?

Exhibit

{
  "cluster_id": "0912-123456-abcde78",
  "spark_version": "13.3.x-scala2.12",
  "node_type_id": "i3.xlarge",
  "autoscale": {
    "min_workers": 2,
    "max_workers": 8
  },
  "driver_node_type_id": "i3.xlarge",
  "enable_elastic_disk": true
}
Question 13hardmulti select
Full question →

You are auditing a Databricks environment and notice that the Silver tables contain massive amounts of historical data that is no longer needed. Which TWO operations should be used to safely remove this data while keeping the Delta Lake ACID consistency?

Question 14hardmultiple choice
Full question →

Which DLT feature should a data engineer use to ensure that the Silver layer remains highly available and that data lineage is automatically tracked?

Question 15hardmulti select
Full question →

Which THREE of the following are valid ways to define schemas in a Databricks data engineering pipeline?

Question 16hardmultiple 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 17hardmultiple choice
Full question →

If an organization wants to ensure that no data can be accessed unless it is explicitly granted, which Unity Catalog setting should be enforced?

Question 18hardmulti select
Full question →

A streaming job using Structured Streaming is lagging significantly behind the 'current time'. Which THREE of the following could be the root cause of this processing latency?

Question 19hardmultiple choice
Full question →

Which of the following describes the correct order of operations to configure a new external location in Unity Catalog?

Question 20hardmulti select
Full question →

Which TWO of the following are true regarding the use of Personal Access Tokens (PATs) versus Service Principals for automated jobs in Unity Catalog?

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.