Databricks-Certified-Data-Engineer-Associate Exam Practice Test Instant Access

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?

ACREATE STREAMING LIVE TABLE should be used when the subsequent step in the DLT pipeline is static.

BCREATE STREAMING LIVE TABLE should be used when data needs to be processed incrementally.

CCREATE STREAMING LIVE TABLE is redundant for DLT and it does not need to be used.

DCREATE STREAMING LIVE TABLE should be used when data needs to be processed through complicated aggregations.

ECREATE STREAMING LIVE TABLE should be used when the previous step in the DLT pipeline is static.

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?

ARecords that violate the expectation are dropped from the target dataset and loaded into a quarantine table.

BRecords that violate the expectation are added to the target dataset and flagged as invalid in a field added to the target dataset.

CRecords that violate the expectation are dropped from the target dataset and recorded as invalid in the event log.

DRecords that violate the expectation are added to the target dataset and recorded as invalid in the event log.

ERecords that violate the expectation cause the job to fail.

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?

Atrigger('5 seconds')

Btrigger()

Ctrigger(once='5 seconds')

Dtrigger(processingTime='5 seconds')

Etrigger(continuous='5 seconds')

Answer : D

Question 4

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

ACheckpointing

BSpark Structured Streaming

CData Explorer

DUnity Catalog

EDatabricks SQL

Answer : B

Question 5

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

ABronze tables contain less data than raw data files.

BBronze tables contain more truthful data than raw data.

CBronze tables contain aggregates while raw data is unaggregated.

DBronze tables contain a less refined view of data than raw data.

EBronze tables contain raw data with a schema applied.

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?