Databricks Databricks Certified Data Engineer Associate Practice Exams
Last updated on Oct 22,2026- Exam Code: Databricks Certified Data Engineer Associate
- Exam Name: Databricks Certified Data Engineer Associate Exam
- Certification Provider: Databricks
- Latest update: Oct 22,2026
Which file format is used for storing Delta Lake Table?
- A . Parquet
- B . Delta
- C . SV
- D . JSON
A data engineer has left the organization. The data team needs to transfer ownership of the data engineer’s Delta tables to a new data engineer. The new data engineer is the lead engineer on the data team.
Assuming the original data engineer no longer has access, which of the following individuals must be the one to transfer ownership of the Delta tables in Data Explorer?
- A . Databricks account representative
- B . This transfer is not possible
- C . Workspace administrator
- D . New lead data engineer
- E . Original data engineer
A data engineer has configured a Structured Streaming job to read from a table, manipulate the data, and then perform a streaming write into a new table.
The cade block used by the data engineer is below:
If the data engineer only wants the query to execute a micro-batch to process data every 5 seconds, which of the following lines of code should the data engineer use to fill in the blank?
- A . trigger("5 seconds")
- B . trigger()
- C . trigger(once="5 seconds")
- D . trigger(processingTime="5 seconds")
- E . trigger(continuous="5 seconds")
Which of the following functions are NOT supported by Databricks Repos?
- A . Commit
- B . Pull
- C . Merge
- D . Clone
- E . Push
Which of the following Git operations must be performed outside of Databricks Repos?
- A . Commit
- B . Pull
- C . Push
- D . Clone
- E . Merge
A dataset has been defined using Delta Live Tables and includes an expectations clause:
CONSTRAINT valid_timestamp EXPECT (timestamp > ‘2020-01-01’) ON VIOLATION DROP ROW
What is the expected behavior when a batch of data containing data that violates these constraints is
processed?
- A . Records that violate the expectation are dropped from the target dataset and loaded into a quarantine table.
- B . Records that violate the expectation are added to the target dataset and flagged as invalid in a field added to the target dataset.
- C . Records that violate the expectation are dropped from the target dataset and recorded as invalid in the event log.
- D . Records that violate the expectation are added to the target dataset and recorded as invalid in the event log.
- E . Records that violate the expectation cause the job to fail.
A new data engineering team team has been assigned to an ELT project. The new data engineering team will need full privileges on the table sales to fully manage the project.
Which of the following commands can be used to grant full permissions on the database to the new data engineering team?
- A . GRANT ALL PRIVILEGES ON TABLE sales TO team;
- B . GRANT SELECT CREATE MODIFY ON TABLE sales TO team;
- C . GRANT SELECT ON TABLE sales TO team;
- D . GRANT USAGE ON TABLE sales TO team;
- E . GRANT ALL PRIVILEGES ON TABLE team TO sales;
A data engineer wants to schedule their Databricks SQL dashboard to refresh every hour, but they only want the associated SQL endpoint to be running when it is necessary. The dashboard has multiple queries on multiple datasets associated with it. The data that feeds the dashboard is automatically processed using a Databricks Job.
Which of the following approaches can the data engineer use to minimize the total running time of the SQL endpoint used in the refresh schedule of their dashboard?
- A . They can turn on the Auto Stop feature for the SQL endpoint.
- B . They can ensure the dashboard’s SQL endpoint is not one of the included query’s SQL endpoint.
- C . They can reduce the cluster size of the SQL endpoint.
- D . They can ensure the dashboard’s SQL endpoint matches each of the queries’ SQL endpoints.
- E . They can set up the dashboard’s SQL endpoint to be serverless.
Which of the following benefits is provided by the array functions from Spark SQL?
- A . An ability to work with data in a variety of types at once
- B . An ability to work with data within certain partitions and windows
- C . An ability to work with time-related data in specified intervals
- D . An ability to work with complex, nested data ingested from JSON files
- E . An ability to work with an array of tables for procedural automation
A data organization leader is upset about the data analysis team’s reports being different from the data engineering team’s reports. The leader believes the siloed nature of their organization’s data engineering and data analysis architectures is to blame.
Which of the following describes how a data lakehouse could alleviate this issue?
- A . Both teams would autoscale their work as data size evolves
- B . Both teams would use the same source of truth for their work
- C . Both teams would reorganize to report to the same department
- D . Both teams would be able to collaborate on projects in real-time
- E . Both teams would respond more quickly to ad-hoc requests