Databricks Certified Data Engineer
Associate UPDATED ACTUAL Questions
and CORRECT Answers
Which of the following describes a benefit of a data lakehouse that is unavailable in a
traditional data warehouse?
A. A data lakehouse provides a relational system of data management.
B. A data lakehouse captures snapshots of data for version control purposes.
C. A data lakehouse couples storage and compute for complete control.
D. A data lakehouse utilizes proprietary storage formats for data.
E. A data lakehouse enables both batch and streaming analytics - CORRECT ANSWER-
✔✔E. A data lakehouse enables both batch and streaming analytics
Which of the following locations hosts the driver and worker nodes of a Databricks-managed
cluster?
A. Data plane
B. Control plane
C. Databricks Filesystem
D. JDBC data source
E. Databricks web application - CORRECT ANSWER- ✔✔A. Data plane
A data architect is designing a data model that works for both video-based machine learning
workloads and highly audited batch ETL/ELT workloads. Which of the following describes
how using a data lakehouse can help the data architect meet the needs of both workloads?
A. A data lakehouse requires very little data modeling.
B. A data lakehouse combines compute and storage for simple governance.
C. A data lakehouse provides autoscaling for compute clusters.
D. A data lakehouse stores unstructured data and is ACID-compliant.
E. A data lakehouse fully exists in the cloud. - CORRECT ANSWER- ✔✔D. A data
lakehouse stores unstructured data and is ACID-compliant.
,Which of the following describes a scenario in which a data engineer will want to use a Job
cluster instead of an all-purpose cluster?
A. An ad-hoc analytics report needs to be developed while minimizing compute costs.
B. A data team needs to collaborate on the development of a machine learning model.
C. An automated workflow needs to be run every 30 minutes.
D. A Databricks SQL query needs to be scheduled for upward reporting.
E. A data engineer needs to manually investigate a production error. - CORRECT ANSWER-
✔✔C. An automated workflow needs to be run every 30 minutes.
A data engineer has created a Delta table as part of a data pipeline. Downstream data analysts
now need SELECT permission on the Delta table. Assuming the data engineer is the Delta
table owner, which part of the Databricks Lakehouse Platform can the data engineer use to
grant the data analysts the appropriate access?
A. Repos
B. Jobs
C. Data Explorer
D. Databricks Filesystem
E. Dashboards - CORRECT ANSWER- ✔✔C. Data Explorer
Two junior data engineers are authoring separate parts of a single data pipeline notebook.
They are working on separate Git branches so they can pair program on the same notebook
simultaneously. A senior data engineer experienced in Databricks suggests there is a better
alternative for this type of collaboration. Which of the following supports the senior data
engineer's claim?
A. Databricks Notebooks support automatic change-tracking and versioning
B. Databricks Notebooks support real-time coauthoring on a single notebook
C. Databricks Notebooks support commenting and notification comments
D. Databricks Notebooks support the use of multiple languages in the same notebook
E. Databricks Notebooks support the creation of interactive data visualizations - CORRECT
ANSWER- ✔✔B. Databricks Notebooks support real-time coauthoring on a single notebook
Which of the following describes how Databricks Repos can help facilitate CI/CD workflows
on the Databricks Lakehouse Platform?
, A. Databricks Repos can facilitate the pull request, review, and approval process before
merging branches
B. Databricks Repos can merge changes from a secondary Git branch into a main Git branch
C. Databricks Repos can be used to design, develop, and trigger Git automation pipelines
D. Databricks Repos can store the single-source-of-truth Git repository
E. Databricks Repos can commit or push code changes to trigger a CI/CD process -
CORRECT ANSWER- ✔✔E. Databricks Repos can commit or push code changes to trigger
a CI/CD process
Which of the following statements describes Delta Lake?
A. Delta Lake is an open source analytics engine used for big data workloads.
B. Delta Lake is an open format storage layer that delivers reliability, security, and
performance.
C. Delta Lake is an open source platform to help manage the complete machine learning
lifecycle.
D. Delta Lake is an open source data storage format for distributed data.
E. Delta Lake is an open format storage layer that processes data. - CORRECT ANSWER-
✔✔B. Delta Lake is an open format storage layer that delivers reliability, security, and
performance.
A data architect has determined that a table of the following format is necessary:
------------------------------------
| id | birthDate | avgRating |
------------------------------------
| a1 | 1990-01-06 | 5.5 |
------------------------------------
| a2 | 1974-11-21 | 7.1 |
------------------------------------
| .. | .. | .. |
------------------------------------
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. CREATE OR REPLACE TABLE table_name AS
Associate UPDATED ACTUAL Questions
and CORRECT Answers
Which of the following describes a benefit of a data lakehouse that is unavailable in a
traditional data warehouse?
A. A data lakehouse provides a relational system of data management.
B. A data lakehouse captures snapshots of data for version control purposes.
C. A data lakehouse couples storage and compute for complete control.
D. A data lakehouse utilizes proprietary storage formats for data.
E. A data lakehouse enables both batch and streaming analytics - CORRECT ANSWER-
✔✔E. A data lakehouse enables both batch and streaming analytics
Which of the following locations hosts the driver and worker nodes of a Databricks-managed
cluster?
A. Data plane
B. Control plane
C. Databricks Filesystem
D. JDBC data source
E. Databricks web application - CORRECT ANSWER- ✔✔A. Data plane
A data architect is designing a data model that works for both video-based machine learning
workloads and highly audited batch ETL/ELT workloads. Which of the following describes
how using a data lakehouse can help the data architect meet the needs of both workloads?
A. A data lakehouse requires very little data modeling.
B. A data lakehouse combines compute and storage for simple governance.
C. A data lakehouse provides autoscaling for compute clusters.
D. A data lakehouse stores unstructured data and is ACID-compliant.
E. A data lakehouse fully exists in the cloud. - CORRECT ANSWER- ✔✔D. A data
lakehouse stores unstructured data and is ACID-compliant.
,Which of the following describes a scenario in which a data engineer will want to use a Job
cluster instead of an all-purpose cluster?
A. An ad-hoc analytics report needs to be developed while minimizing compute costs.
B. A data team needs to collaborate on the development of a machine learning model.
C. An automated workflow needs to be run every 30 minutes.
D. A Databricks SQL query needs to be scheduled for upward reporting.
E. A data engineer needs to manually investigate a production error. - CORRECT ANSWER-
✔✔C. An automated workflow needs to be run every 30 minutes.
A data engineer has created a Delta table as part of a data pipeline. Downstream data analysts
now need SELECT permission on the Delta table. Assuming the data engineer is the Delta
table owner, which part of the Databricks Lakehouse Platform can the data engineer use to
grant the data analysts the appropriate access?
A. Repos
B. Jobs
C. Data Explorer
D. Databricks Filesystem
E. Dashboards - CORRECT ANSWER- ✔✔C. Data Explorer
Two junior data engineers are authoring separate parts of a single data pipeline notebook.
They are working on separate Git branches so they can pair program on the same notebook
simultaneously. A senior data engineer experienced in Databricks suggests there is a better
alternative for this type of collaboration. Which of the following supports the senior data
engineer's claim?
A. Databricks Notebooks support automatic change-tracking and versioning
B. Databricks Notebooks support real-time coauthoring on a single notebook
C. Databricks Notebooks support commenting and notification comments
D. Databricks Notebooks support the use of multiple languages in the same notebook
E. Databricks Notebooks support the creation of interactive data visualizations - CORRECT
ANSWER- ✔✔B. Databricks Notebooks support real-time coauthoring on a single notebook
Which of the following describes how Databricks Repos can help facilitate CI/CD workflows
on the Databricks Lakehouse Platform?
, A. Databricks Repos can facilitate the pull request, review, and approval process before
merging branches
B. Databricks Repos can merge changes from a secondary Git branch into a main Git branch
C. Databricks Repos can be used to design, develop, and trigger Git automation pipelines
D. Databricks Repos can store the single-source-of-truth Git repository
E. Databricks Repos can commit or push code changes to trigger a CI/CD process -
CORRECT ANSWER- ✔✔E. Databricks Repos can commit or push code changes to trigger
a CI/CD process
Which of the following statements describes Delta Lake?
A. Delta Lake is an open source analytics engine used for big data workloads.
B. Delta Lake is an open format storage layer that delivers reliability, security, and
performance.
C. Delta Lake is an open source platform to help manage the complete machine learning
lifecycle.
D. Delta Lake is an open source data storage format for distributed data.
E. Delta Lake is an open format storage layer that processes data. - CORRECT ANSWER-
✔✔B. Delta Lake is an open format storage layer that delivers reliability, security, and
performance.
A data architect has determined that a table of the following format is necessary:
------------------------------------
| id | birthDate | avgRating |
------------------------------------
| a1 | 1990-01-06 | 5.5 |
------------------------------------
| a2 | 1974-11-21 | 7.1 |
------------------------------------
| .. | .. | .. |
------------------------------------
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. CREATE OR REPLACE TABLE table_name AS
