Databricks Certified Data Engineer Associate Exam Practice Test

Page: 1 / 14
Total 45 questions

Question 1

Which of the following describes when to use the CREATE STREAMING LIVE TABLE (formerly CREATE INCREMENTAL LIVE TABLE) syntax over the CREATE LIVE TABLE syntax when creating Delta Live Tables (DLT) tables using SQL?

Answer : B

Question 2

A dataset has been defined using Delta Live Tables and includes an expectations clause:

CONSTRAINT valid_timestamp EXPECT (timestamp > '2020-01-01') ON VIOLATION DROP ROW

What is the expected behavior when a batch of data containing data that violates these constraints is processed?

Answer : D

Question 3

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.

The cade block used by the data engineer is below:

If the data engineer only wants the query to execute a micro-batch to process data every 5 seconds, which of the following lines of code should the data engineer use to fill in the blank?

Answer : D

Question 4

Which of the following tools is used by Auto Loader process data incrementally?

Answer : B

Question 5

Which of the following describes the relationship between Bronze tables and raw data?

Answer : C

Question 6

A data engineer needs to apply custom logic to string column city in table stores for a specific use case. In order to apply this custom logic at scale, the data engineer wants to create a SQL user-defined function (UDF).

Which of the following code blocks creates this SQL UDF?






Answer : E

Question 7

Which of the following commands can be used to write data into a Delta table while avoiding the writing of duplicate records?

Answer : C

Page:    1 / 14   
Total 45 questions