Free Certified Data Engineer Associate Exam Questions and Answers

Last updated: September 12, 2026

Provider

Databricks

Questions in our bank

1000+

Free to read

First 10, with answers

Official page

Official Exam website

Our test mode duration & pass mark

130 mins · 70%

Verified answers

Reviewed weekly

Recommended: Switch to Test Mode to start a practice test that simulates the real exam experience.

1. Question #1

   Which of the following commands will return the location of database customer360?

   • A. DESCRIBE LOCATION customer360;
   • B. DROP DATABASE customer360;
   • C. DESCRIBE DATABASE customer360;
   • D. ALTER DATABASE customer360 SET DBPROPERTIES ('location' = '/user'};
   Reveal Answer

2. Question #2

   Which of the following describes the storage organization of a Delta table?

   • A. Delta tables are stored in a single file that contains data, history, metadata, and other attributes.
   • B. Delta tables store their data in a single file and all metadata in a collection of files in a separate location.
   • C. Delta tables are stored in a collection of files that contain data, history, metadata, and other attributes.
   • D. Delta tables are stored in a collection of files that contain only the data stored within the table.
   Reveal Answer

3. Question #3

   A data engineer has three tables in a Delta Live Tables (DLT) pipeline. They have configured the pipeline to drop invalid records at each table. They notice that some data is being dropped due to quality concerns at some point in the DLT pipeline. They would like to determine at which table in their pipeline the data is being dropped. Which of the following approaches can the data engineer take to identify the table that is dropping the records?

   • A. They can set up separate expectations for each table when developing their DLT pipeline.
   • B. They cannot determine which table is dropping the records.
   • C. They can set up DLT to notify them via email when records are dropped.
   • D. They can navigate to the DLT pipeline page, click on each table, and view the data quality statistics.
   Reveal Answer

4. Question #4

   Which of the following describes a scenario in which a data team will want to utilize cluster pools?

   • A. An automated report needs to be refreshed as quickly as possible.
   • B. An automated report needs to be made reproducible.
   • C. An automated report needs to be tested to identify errors.
   • D. An automated report needs to be version-controlled across multiple collaborators.
   Reveal Answer

5. Question #5

   In which of the following scenarios should a data engineer use the MERGE INTO command instead of the INSERT INTO command?

   • A. When the location of the data needs to be changed
   • B. When the target table is an external table
   • C. When the source table can be deleted
   • D. When the target table cannot contain duplicate records
   Reveal Answer

6. Question #6

   Which of the following is stored in the Databricks customer's cloud account?

   • A. Databricks web application
   • B. Cluster management metadata
   • C. Repos
   • D. Data
   Reveal Answer

7. Question #7

   A data engineer has realized that the data files associated with a Delta table are incredibly small. They want to compact the small files to form larger files to improve performance. Which of the following keywords can be used to compact the small files?

   • A. REDUCE
   • B. OPTIMIZE
   • C. COMPACTION
   • D. REPARTITION
   Reveal Answer

8. Question #8

   A data engineering team has two tables. The first table march_transactions is a collection of all retail transactions in the month of March. The second table april_transactions is a collection of all retail transactions in the month of April. There are no duplicate records between the tables. Which of the following commands should be run to create a new table all_transactions that contains all records from march_transactions and april_transactions without duplicate records?

   • A. CREATE TABLE all_transactions AS SELECT * FROM march_transactionsINNER JOIN SELECT * FROM april_transactions;
   • B. CREATE TABLE all_transactions AS SELECT * FROM march_transactions UNION SELECT * FROM april_transactions;
   • C. CREATE TABLE all_transactions AS SELECT * FROM march_transactionsOUTER JOIN SELECT * FROM april_transactions;
   • D. CREATE TABLE all_transactions AS SELECT * FROM march_transactionsINTERSECT SELECT * from april_transactions;
   Reveal Answer

9. Question #9

   Which of the following data lakehouse features results in improved data quality over a traditional data lake?

   • A. A data lakehouse provides storage solutions for structured and unstructured data.
   • B. A data lakehouse supports ACID-compliant transactions.
   • C. A data lakehouse allows the use of SQL queries to examine data.
   • D. A data lakehouse stores data in open formats.
   Reveal Answer

10. Question #10

    A data engineer needs to create a table in Databricks using data from a CSV file at location /path/to/csv. They run the following command: Which of the following lines of code fills in the above blank to successfully complete the task?

    • A. None of these lines of code are needed to successfully complete the task
    • B. USING CSV
    • C. FROM CSV
    • D. USING DELTA
    Reveal Answer