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?

• A.Records that violate the expectation are dropped from the target dataset and loaded into a quarantine table.
• B.Records that violate the expectation are added to the target dataset and flagged as invalid in a field added to the target dataset.
• C.Records that violate the expectation are dropped from the target dataset and recorded as invalid in the event log.
• D.Records that violate the expectation are added to the target dataset and recorded as invalid in the event log.
• E.Records that violate the expectation cause the job to fail.

Comment: *

Name: *

Email: *

Verification: *

A data engineer has realized that the data files associated with a Delta table are incredibly small. They want to compact the small files to form larger files to improve performance.
Which of the following keywords can be used to compact the small files?

• A.REDUCE
• B.OPTIMIZE
• C.COMPACTION
• D.REPARTITION
• E.VACUUM

Comment: *

Name: *

Email: *

Verification: *

Which of the following is hosted completely in the control plane of the classic Databricks architecture?

• A.Worker node
• B.JDBC data source
• C.Databricks web application
• D.Databricks Filesystem
• E.Driver node

Comment: *

Name: *

Email: *

Verification: *

A data engineer needs to create a table in Databricks using data from a CSV file at location /path/to/csv.
They run the following command:

Which of the following lines of code fills in the above blank to successfully complete the task?

• A.None of these lines of code are needed to successfully complete the task
• B.USING CSV
• C.FROM CSV
• D.USING DELTA
• E.FROM "path/to/csv"

Comment: *

Name: *

Email: *

Verification: *

A data engineer has left the organization. The data team needs to transfer ownership of the data engineer's Delta tables to a new data engineer. The new data engineer is the lead engineer on the data team.
Assuming the original data engineer no longer has access, which of the following individuals must be the one to transfer ownership of the Delta tables in Data Explorer?

• A.Databricks account representative
• B.This transfer is not possible
• C.Workspace administrator
• D.New lead data engineer
• E.Original data engineer

Comment: *

Name: *

Email: *

Verification: *