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

A data engineer has been using a Databricks SQL dashboard to monitor the cleanliness of the input data to a data analytics dashboard for a retail use case. The job has a Databricks SQL query that returns the number of store-level records where sales is equal to zero. The data engineer wants their entire team to be notified via a messaging webhook whenever this value is greater than 0.
Which of the following approaches can the data engineer use to notify their entire team via a messaging webhook whenever the number of stores with $0 in sales is greater than zero?

1. A. They can set up an Alert with a custom template.
2. B. They can set up an Alert with a new email alert destination.
3. C. They can set up an Alert with one-time notifications.
4. D. They can set up an Alert with a new webhook alert destination.
5. E. They can set up an Alert without notifications.

Correct Answer: D

A data engineer needs to determine whether to use the built-in Databricks Notebooks versioning or version their project using Databricks Repos.
Which of the following is an advantage of using Databricks Repos over the Databricks Notebooks versioning?

1. A. Databricks Repos automatically saves development progress
2. B. Databricks Repos supports the use of multiple branches
3. C. Databricks Repos allows users to revert to previous versions of a notebook
4. D. Databricks Repos provides the ability to comment on specific changes
5. E. Databricks Repos is wholly housed within the Databricks Lakehouse Platform

Correct Answer: B
An advantage of using Databricks Repos over the built-in Databricks Notebooks versioning is the ability to work with multiple branches. Branching is a fundamental feature ofversion control systems like Git, which Databricks Repos is built upon. It allows you to create separate branches for different tasks, features, or experiments within your project. This separation helps in parallel development and experimentation without affecting the main branch or the work of other team members. Branching provides a more organized and collaborative development environment, making it easier to merge changes and manage different development efforts. While Databricks Notebooks versioning also allows you to track versions of notebooks, it may not provide the same level of flexibility and collaboration as branching in Databricks Repos.

Which of the following is stored in the Databricks customer's cloud account?

1. A. Databricks web application
2. B. Cluster management metadata
3. C. Repos
4. D. Data
5. E. Notebooks

Correct Answer: D

A data engineer has three tables in a Delta Live Tables (DLT) pipeline. They have configured the pipeline to drop invalid records at each table. They notice that some data is being dropped due to quality concerns at some point in the DLT pipeline. They would like to determine at which table in their pipeline the data is being dropped.
Which of the following approaches can the data engineer take to identify the table that is dropping the records?

1. A. They can set up separate expectations for each table when developing their DLT pipeline.
2. B. They cannot determine which table is dropping the records.
3. C. They can set up DLT to notify them via email when records are dropped.
4. D. They can navigate to the DLT pipeline page, click on each table, and view the data quality statistics.
5. E. They can navigate to the DLT pipeline page, click on the “Error” button, and review the present errors.

Correct Answer: D
To identify the table in a Delta Live Tables (DLT) pipeline where data is being dropped due to quality concerns, the data engineer can navigate to the DLT pipeline page, click on each table in the pipeline, and view the data quality statistics. These statistics often include information about records dropped, violations of expectations, and other data quality metrics. By examining the data quality statistics for each table in the pipeline, the data engineer can determine at which table the data is being dropped.

A data engineer has created a new database using the following command: CREATE DATABASE IF NOT EXISTS customer360;
In which of the following locations will the customer360 database be located?

1. A. dbfs:/user/hive/database/customer360
2. B. dbfs:/user/hive/warehouse
3. C. dbfs:/user/hive/customer360
4. D. More information is needed to determine the correct response

Correct Answer: B
dbfs:/user/hive/warehouse - which is the default location