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
What is the primary purpose of using the OPTIMIZE command in Delta Lake?
- A . To delete unused files
- B . To merge small files into larger ones for more efficient processing
- C . To create partitioned data
- D . To compress data files
A data analyst has developed a query that runs against Delta table. They want help from the data engineering team to implement a series of tests to ensure the data returned by the query is clean. However, the data engineering team uses Python for its tests rather than SQL.
Which of the following operations could the data engineering team use to run the query and operate with the results in PySpark?
- A . SELECT * FROM sales
- B . spark.delta.table
- C . spark.sql
- D . There is no way to share data between PySpark and SQL.
- E . spark.table
A data engineer needs to create a table in Databricks using data from their organization’s existing
SQLite database.
They run the following command:
CREATE TABLE jdbc_customer360
USING
OPTIONS (
url "jdbc:sqlite:/customers.db", dbtable "customer360"
)
Which line of code fills in the above blank to successfully complete the task?
- A . autoloader
- B . org.apache.spark.sql.jdbc
- C . sqlite
- D . org.apache.spark.sql.sqlite
A data engineer has joined an existing project and they see the following query in the project repository:
CREATE STREAMING LIVE TABLE loyal_customers AS
SELECT customer_id –
FROM STREAM(LIVE.customers)
WHERE loyalty_level = ‘high’;
Which of the following describes why the STREAM function is included in the query?
- A . The STREAM function is not needed and will cause an error.
- B . The table being created is a live table.
- C . The customers table is a streaming live table.
- D . The customers table is a reference to a Structured Streaming query on a PySpark DataFrame.
- E . The data in the customers table has been updated since its last run.
Which of the following must be specified when creating a new Delta Live Tables pipeline?
- A . A key-value pair configuration
- B . The preferred DBU/hour cost
- C . A path to cloud storage location for the written data
- D . A location of a target database for the written data
- E . At least one notebook library to be executed
A data engineer has created a new database using the following command:
CREATE DATABASE IF NOT EXISTS customer360;
In which of the following locations will the customer360 database be located?
- A . dbfs:/user/hive/database/customer360
- B . dbfs:/user/hive/warehouse
- C . dbfs:/user/hive/customer360
- D . More information is needed to determine the correct response
A data engineer has been given a new record of data:
id STRING = ‘a1’
rank INTEGER = 6
rating FLOAT = 9.4
Which of the following SQL commands can be used to append the new record to an existing Delta table my_table?
- A . INSERT INTO my_table VALUES (‘a1’, 6, 9.4)
- B . my_table UNION VALUES (‘a1’, 6, 9.4)
- C . INSERT VALUES ( ‘a1’ , 6, 9.4) INTO my_table
- D . UPDATE my_table VALUES (‘a1’, 6, 9.4)
- E . UPDATE VALUES (‘a1’, 6, 9.4) my_table
A data engineer needs to use a Delta table as part of a data pipeline, but they do not know if they have the appropriate permissions.
In which of the following locations can the data engineer review their permissions on the table?
- A . Databricks Filesystem
- B . Jobs
- C . Dashboards
- D . Repos
- E . Data Explorer
A data engineer wants to create a data entity from a couple of tables. The data entity must be used by other data engineers in other sessions. It also must be saved to a physical location.
Which of the following data entities should the data engineer create?
- A . Database
- B . Function
- C . View
- D . Temporary view
- E . 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 table sales to fully manage the project.
Which command 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 ON TABLE sales TO team;
- C . GRANT SELECT CREATE MODIFY ON TABLE sales TO team;
- D . GRANT ALL PRIVILEGES ON TABLE team TO sales;