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
What is stored in a Databricks customer's cloud account?
Options
A Data
B Databricks web application
C Notebooks
D Cluster management metadata
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
Identify how the count_if function and the count where x is null can be used Consider a table random_values with below data.

What would be the output of below query?
select count_if(col > 1) as count_
Options
A 3 6 5
B 3 6 6
C 4 6 6
D 4 6 5
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
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!

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
Which of the following SQL keywords can be used to convert a table from a long format to a wide format?
Options
A PIVOT
B TRANSFORM
C WHERE
D CONVERT
E SUM
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.