Logo ExamsQA
Exit
Official Bank 0/109

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

Last updated on June 20, 2026

97% Exam Compliance
109 Total Questions
1
Question
Which of the following SQL keywords can be used to convert a table from a long format to a wide format?
Options
A TRANSFORM
B SUM
C WHERE
D CONVERT
E PIVOT
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
A data engineer has configured a Structured Streaming job to read from a table, manipulate the data, and then perform a streaming write into a new table.

Exhibit

The code block used by the data engineer is below: Which line of code should the data engineer use to fill in the blank if the data engineer only wants the query to execute a micro-batch to process data every 5 seconds?
Options
A trigger(processingTime="5 seconds")
B trigger(once="5 seconds")
C trigger(continuous="5 seconds")
D trigger("5 seconds")
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
A data engineer has a Job that has a complex run schedule, and they want to transfer that schedule to other Jobs. Rather than manually selecting each value in the scheduling form in Databricks, which of the following tools can the data engineer use to represent and submit the schedule programmatically?
Options
A Cron syntax
B pyspark.sql.types.DateType
C There is no way to represent and submit this information programmatically
D datetime
E pyspark.sql.types.TimestampType
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
In order for Structured Streaming to reliably track the exact progress of the processing so that it can handle any kind of failure by restarting and/or reprocessing, which of the following two approaches is used by Spark to record the offset range of the data being processed in each trigger?
Options
A Write-ahead Logs and Idempotent Sinks
B Checkpointing and Idempotent Sinks
C Structured Streaming cannot record the offset range of the data being processed in each trigger.
D Replayable Sources and Idempotent Sinks
E Checkpointing and Write-ahead Logs
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
A data engineer needs to determine whether to use the built-in Databricks Notebooks versioning or version their project using Databricks Repos.

Which of the following is an advantage of using Databricks Repos over the Databricks Notebooks versioning?
Options
A Databricks Repos provides the ability to comment on specific changes
B Databricks Repos is wholly housed within the Databricks Lakehouse Platform
C Databricks Repos automatically saves development progress
D Databricks Repos supports the use of multiple branches
E Databricks Repos allows users to revert to previous versions of a notebook
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.