Databricks-Certified-Data-Engineer-Associate Free Practice Test

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 code block used by the data engineer is below:

If the data engineer only wants the query to process all of the available data in as many batches as required, which of the following lines of code should the data engineer use to fill in the blank?

1. A. processingTime(1)
2. B. trigger(availableNow=True)
3. C. trigger(parallelBatch=True)
4. D. trigger(processingTime="once")
5. E. trigger(continuous="once")

Correct Answer: B
https://stackoverflow.com/questions/71061809/trigger-availablenow-for-delta- source-streaming-queries-in-pyspark-databricks

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?

1. A. Option A
2. B. Option B
3. C. Option C
4. D. Option D
5. E. Option E

Correct Answer: C

A data engineer has a single-task Job that runs each morning before they begin working. After identifying an upstream data issue, they need to set up another task to run a new notebook prior to the original task.
Which of the following approaches can the data engineer use to set up the new task?

1. A. They can clone the existing task in the existing Job and update it to run the new notebook.
2. B. They can create a new task in the existing Job and then add it as a dependency of the original task.
3. C. They can create a new task in the existing Job and then add the original task as a dependency of the new task.
4. D. They can create a new job from scratch and add both tasks to run concurrently.
5. E. They can clone the existing task to a new Job and then edit it to run the new notebook.

Correct Answer: B
To set up the new task to run a new notebook prior to the original task in a single-task Job, the data engineer can use the following approach: In the existing Job, create a new task that corresponds to the new notebook that needs to be run. Set up the new task with the appropriate configuration, specifying the notebook to be executed and any necessary parameters or dependencies. Once the new task is created, designate it as a dependency of the original task in the Job configuration. This ensures that the new task is executed before the original task.

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?

1. A. CREATE STREAMING LIVE TABLE should be used when the subsequent step in the DLT pipeline is static.
2. B. CREATE STREAMING LIVE TABLE should be used when data needs to be processed incrementally.
3. C. CREATE STREAMING LIVE TABLE is redundant for DLT and it does not need to be used.
4. D. CREATE STREAMING LIVE TABLE should be used when data needs to be processed through complicated aggregations.
5. E. CREATE STREAMING LIVE TABLE should be used when the previous step in the DLT pipeline is static.

Correct Answer: B
The CREATE STREAMING LIVE TABLE syntax is used when you want to create Delta Live Tables (DLT) tables that are designed for processing data incrementally. This is typically used when your data pipeline involves streaming or incremental data updates, and you want the table to stay up to date as new data arrives. It allows you to define tables that can handle data changes incrementally without the need for full table refreshes.

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

1. A. A job that enriches data by parsing its timestamps into a human-readable format
2. B. A job that aggregates uncleaned data to create standard summary statistics
3. C. A job that cleans data by removing malformatted records
4. D. A job that queries aggregated data designed to feed into a dashboard
5. E. A job that ingests raw data from a streaming source into the Lakehouse

Correct Answer: D