Free Access GAQM.Databricks-Certified-Data-Engineer-Associate.v2025-10-18.q113 Practice Test (Page 5)

Question 16

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 cause the job to fail.

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

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 flagged as invalid in a field added to the target dataset.

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

Question 17

A data engineer is running code in a Databricks Repo that is cloned from a central Git repository. A colleague of the data engineer informs them that changes have been made and synced to the central Git repository. The data engineer now needs to sync their Databricks Repo to get the changes from the central Git repository.
Which of the following Git operations does the data engineer need to run to accomplish this task?

A.Merge

B.Push

C.Pull

D.Commit

E.Clone

Question 18

Which of the following data workloads will utilize a Gold table as its source?

A.A job that aggregates uncleaned data to create standard summary statistics

B.A job that enriches data by parsing its timestamps into a human-readable format

C.A job that ingests raw data from a streaming source into the Lakehouse

D.A job that cleans data by removing malformatted records

E.A job that queries aggregated data designed to feed into a dashboard

Question 19

A data engineer has joined an existing project and they see the following query in the project repository:
CREATE STREAMING LIVE TABLE loyal_customers AS
SELECT customer_id -
FROM STREAM(LIVE.customers)
WHERE loyalty_level = 'high';
Which of the following describes why the STREAM function is included in the query?

A.The STREAM function is not needed and will cause an error.

B.The table being created is a live table.

C.The customers table is a streaming live table.

D.The customers table is a reference to a Structured Streaming query on a PySpark DataFrame.

E.The data in the customers table has been updated since its last run.