Free Access to GAQM.Databricks-Certified-Data-Engineer-Associate.v2026-07-23.q248 with Valid Practice Test (Page 29)

Question 136

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.

Question 137

A data engineer is working with two tables. Each of these tables is displayed below in its entirety.

The data engineer runs the following query to join these tables together:

Which of the following will be returned by the above query?

A.Option B
B.Option C
C.Option E
D.Option D
E.Option A

Question 138

A notebook task named check_volume calculates a daily data volume and writes it to a Lakeflow Jobs task value named record_count. If the count is greater than 1 million, the job should run high_volume_pipeline; otherwise, it should run normal_pipeline.
Which control-flow feature should be used?

A.Use a For each task over record_count and stop when the value is below the threshold.
B.Add an If/else condition task that reads the record_count task value and routes execution to different downstream tasks.
C.Configure Run if conditions based purely on task status.
D.Configure additional retries for check_volume until the count exceeds the threshold.

Question 139

A data engineer is preparing a Declarative Automation Bundle, formerly known as a Databricks Asset Bundle, to deploy a Lakeflow pipeline.
To ensure that the pipeline is deployed to the correct environment, where should workspace-specific configurations, such as the workspace host URL and root storage path, be defined within the bundle project?

A.Inside the README.md file in the bundle's root directory
B.Within the Python source code of the Lakeflow pipeline
C.In the targets section of the databricks.yml file
D.In a global environment variable on the local development machine

Question 140