Logo ExamsQA
Exit
Official Bank 0/109

Databricks Certified Data Engineer Associate (Databricks-Certified-Data-Engineer-Associate) - Databricks Exam Questions

Last updated on June 20, 2026

97% Exam Compliance
109 Total Questions
1
Question
A data architect has determined that a table of the following format is necessary:

Exhibit

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?

Exhibit
Options
A Option A
B Option C
C Option D
D Option B
E Option E
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
Which of the following commands can be used to write data into a Delta table while avoiding the writing of duplicate records?
Options
A DROP
B APPEND
C MERGE
D IGNORE
E INSERT
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
A data engineer is working with two tables. Each of these tables is displayed below in its entirety.

Exhibit

The data engineer runs the following query to join these tables together:

Exhibit

Which of the following will be returned by the above query?

Exhibit
Options
A Option A
B Option D
C Option C
D Option B
E Option E
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
The Delta transaction log for the ‘students’ tables is shown using the ‘DESCRIBE HISTORY students’ command. A Data Engineer needs to query the table as it existed before the UPDATE operation listed

Exhibit

in the log. Which command should the Data Engineer use to achieve this? (Choose two.)
Select 2
Options
A SELECT * FROM students@v4
B SELECT * FROM students VERSION AS OF 5
C SELECT * FROM students FROM HISTORY VERSION AS OF 3
D SELECT * FROM students TIMESTAMP AS OF ‘2024-04-22T 14:32:47.000+00:00’
E SELECT * FROM students TIMESTAMP AS OF ‘2024-04-22T 14:32:58.000+00:00’
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
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 approach can the data engineer use to minimize the total running time of the SQL endpoint used in the refresh schedule of their dashboard?
Options
A O They can reduce the cluster size of the SQL endpoint.
B O They can set up the dashboard's SQL endpoint to be serverless.
C 0 They can ensure the dashboard's SQL endpoint matches each of the queries' SQL endpoints.
D Q They can turn on the Auto Stop feature for the SQL endpoint.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.