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

In which of the following scenarios should a data engineer select a Task in the Depends On field of a new Databricks Job Task?

1. A. When another task needs to be replaced by the new task
2. B. When another task needs to fail before the new task begins
3. C. When another task has the same dependency libraries as the new task
4. D. When another task needs to use as little compute resources as possible
5. E. When another task needs to successfully complete before the new task begins

Correct Answer: E

A data engineer wants to create a relational object by pulling data from two tables. The relational object does not need to be used by other data engineers in other sessions. In order to save on storage costs, the data engineer wants to avoid copying and storing physical data.
Which of the following relational objects should the data engineer create?

1. A. Spark SQL Table
2. B. View
3. C. Database
4. D. Temporary view
5. E. Delta Table

Correct Answer: D
Temp view : session based Create temp view view_name as query All these are termed as session ended: Opening a new notebook Detaching and reattaching a cluster Installing a python package Restarting a cluster

A data engineer is maintaining a data pipeline. Upon data ingestion, the data engineer notices that the source data is starting to have a lower level of quality. The data engineer would like to automate the process of monitoring the quality level.
Which of the following tools can the data engineer use to solve this problem?

1. A. Unity Catalog
2. B. Data Explorer
3. C. Delta Lake
4. D. Delta Live Tables
5. E. Auto Loader

Correct Answer: D
https://docs.databricks.com/delta-live-tables/expectations.html
Delta Live Tables is a tool provided by Databricks that can help data engineers automate the monitoring of data quality. It is designed for managing data pipelines, monitoring data quality, and automating workflows. With Delta Live Tables, you can set up data quality checks and alerts to detect issues and anomalies in your data as it is ingested and processed in real-time. It provides a way to ensure that the data quality meets your desired standards and can trigger actions or notifications when issues are detected. While the other tools mentioned may have their own purposes in a data engineeringenvironment, Delta Live Tables is specifically designed for data quality monitoring and automation within the Databricks ecosystem.

A data architect has determined that a table of the following format is necessary:

Which of the following code blocks uses SQL DDL commands to create an empty Delta table in the above format regardless of whether a table already exists with this name?

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

Correct Answer: E

Which of the following commands will return the location of database customer360?

1. A. DESCRIBE LOCATION customer360;
2. B. DROP DATABASE customer360;
3. C. DESCRIBE DATABASE customer360;
4. D. ALTER DATABASE customer360 SET DBPROPERTIES ('location' = '/user'};
5. E. USE DATABASE customer360;

Correct Answer: C
To retrieve the location of a database named "customer360" in a database management system like Hive or Databricks, you can use the DESCRIBE DATABASE command followed by the database name. This command will provide information about the database, including its location.