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
A data architect has determined that a table of the following format is necessary:
Which of the following code blocks uses SQL DDL commands to create an empty Delta table in the above format regardless of whether a table already exists with this name?
- A . Option A
- B . Option B
- C . Option C
- D . Option D
- E . Option E
Which of the following SQL keywords can be used to convert a table from a long format to a wide format?
- A . PIVOT
- B . CONVERT
- C . WHERE
- D . TRANSFORM
- E . SUM
A Delta Live Table pipeline includes two datasets defined using streaming live table. Three datasets are defined against Delta Lake table sources using live table.
The table is configured to run in Production mode using the Continuous Pipeline Mode.
What is the expected outcome after clicking Start to update the pipeline assuming previously unprocessed data exists and all definitions are valid?
- A . All datasets will be updated once and the pipeline will shut down. The compute resources will be terminated.
- B . All datasets will be updated at set intervals until the pipeline is shut down. The compute resources
will persist to allow for additional testing. - C . All datasets will be updated once and the pipeline will shut down. The compute resources will persist to allow for additional testing.
- D . All datasets will be updated at set intervals until the pipeline is shut down. The compute resources will be deployed for the update and terminated when the pipeline is stopped.
A data engineer and data analyst are working together on a data pipeline. The data engineer is working on the raw, bronze, and silver layers of the pipeline using Python, and the data analyst is working on the gold layer of the pipeline using SQL. The raw source of the pipeline is a streaming input. They now want to migrate their pipeline to use Delta Live Tables.
Which of the following changes will need to be made to the pipeline when migrating to Delta Live Tables?
- A . None of these changes will need to be made
- B . The pipeline will need to stop using the medallion-based multi-hop architecture
- C . The pipeline will need to be written entirely in SQL
- D . The pipeline will need to use a batch source in place of a streaming source
- E . The pipeline will need to be written entirely in Python
Which of the following commands will return the number of null values in the member_id column?
- A . SELECT count(member_id) FROM my_table;
- B . SELECT count(member_id) – count_null(member_id) FROM my_table;
- C . SELECT count_if(member_id IS NULL) FROM my_table;
- D . SELECT null(member_id) FROM my_table;
- E . SELECT count_null(member_id) FROM my_table;
A new data engineering team team. has been assigned to an ELT project. The new data engineering team will need full privileges on the database customers 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 USAGE ON DATABASE customers TO team;
- B . GRANT ALL PRIVILEGES ON DATABASE team TO customers;
- C . GRANT SELECT PRIVILEGES ON DATABASE customers TO teams;
- D . GRANT SELECT CREATE MODIFY USAGE PRIVILEGES ON DATABASE customers TO team;
- E . GRANT ALL PRIVILEGES ON DATABASE customers TO team;
A data engineer has a Job that has a complex run schedule, and they want to transfer that schedule to other Jobs.
Rather than manually selecting each value in the scheduling form in Databricks, which of the following tools can the data engineer use to represent and submit the schedule programmatically?
- A . pyspark.sql.types.DateType
- B . datetime
- C . pyspark.sql.types.TimestampType
- D . Cron syntax
- E . There is no way to represent and submit this information programmatically
A data engineer has realized that they made a mistake when making a daily update to a table. They need to use Delta time travel to restore the table to a version that is 3 days old. However, when the data engineer attempts to time travel to the older version, they are unable to restore the data because the data files have been deleted.
Which of the following explains why the data files are no longer present?
- A . The VACUUM command was run on the table
- B . The TIME TRAVEL command was run on the table
- C . The DELETE HISTORY command was run on the table
- D . The OPTIMIZE command was nun on the table
- E . The HISTORY command was run on the table
A new data engineering team has been assigned to work on a project. The team will need access to database customers in order to see what tables already exist. The team has its own group team.
Which of the following commands can be used to grant the necessary permission on the entire database to the new team?
- A . GRANT VIEW ON CATALOG customers TO team;
- B . GRANT CREATE ON DATABASE customers TO team;
- C . GRANT USAGE ON CATALOG team TO customers;
- D . GRANT CREATE ON DATABASE team TO customers;
- E . GRANT USAGE ON DATABASE customers TO team;
A data engineer only wants to execute the final block of a Python program if the Python variable day_of_week is equal to 1 and the Python variable review_period is True.
Which of the following control flow statements should the data engineer use to begin this conditionally executed code block?
- A . if day_of_week = 1 and review_period:
- B . if day_of_week = 1 and review_period = "True":
- C . if day_of_week == 1 and review_period == "True":
- D . if day_of_week == 1 and review_period:
- E . if day_of_week = 1 & review_period: = "True":