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

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

In which of the following file formats is data from Delta Lake tables primarily stored?

1. A. Delta
2. B. CSV
3. C. Parquet
4. D. JSON
5. E. A proprietary, optimized format specific to Databricks

Correct Answer: C
https://docs.delta.io/latest/delta-faq.html

A data engineer needs to create a table in Databricks using data from their organization’s existing SQLite database.
They run the following command:

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

1. A. org.apache.spark.sql.jdbc
2. B. autoloader
3. C. DELTA
4. D. sqlite
5. E. org.apache.spark.sql.sqlite

Correct Answer: A
CREATE TABLE new_employees_table USING JDBC
OPTIONS (
url "",
dbtable "

', password ''
) AS
SELECT * FROM employees_table_vw https://docs.databricks.com/external-data/jdbc.html#language-sql

• 1
• 2
• 3
• 4

Want to Unlock All Questions for this Exam?
98.4% Pass Rate

Full Exam Access

Practice Test

Use this for 1year and renew if you’re satisfied.

$19.95

Practice, PDF

Go to Shop