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

Which of the following describes the relationship between Gold tables and Silver tables?

1. A. Gold tables are more likely to contain aggregations than Silver tables.
2. B. Gold tables are more likely to contain valuable data than Silver tables.
3. C. Gold tables are more likely to contain a less refined view of data than Silver tables.
4. D. Gold tables are more likely to contain more data than Silver tables.
5. E. Gold tables are more likely to contain truthful data than Silver tables.

Correct Answer: A
In some data processing pipelines, especially those following a typical "Bronze-Silver-Gold" data lakehouse architecture, Silver tables are often considered a more refined version of the raw or Bronze data. Silver tables may include data cleansing, schema enforcement, and some initial transformations. Gold tables, on the other hand, typically represent a stage where data is further enriched, aggregated, and processed to provide valuable insights for analytical purposes. This could indeed involve more aggregations compared to Silver tables.

A data engineer has a Job that has a complex run schedule, and they want to transfer that schedule to other Jobs.
Rather than manually selecting each value in the scheduling form in Databricks, which of the following tools can the data engineer use to represent and submit the schedule programmatically?

1. A. pyspark.sql.types.DateType
2. B. datetime
3. C. pyspark.sql.types.TimestampType
4. D. Cron syntax
5. E. There is no way to represent and submit this information programmatically

Correct Answer: D

Which of the following Git operations must be performed outside of Databricks Repos?

1. A. Commit
2. B. Pull
3. C. Push
4. D. Clone
5. E. Merge

Correct Answer: E
For following tasks, work in your Git provider:
Create a pull request. Resolve merge conflicts. Merge or delete branches. Rebase a branch.
https://docs.databricks.com/repos/index.html

Which of the following commands can be used to write data into a Delta table while avoiding the writing of duplicate records?

1. A. DROP
2. B. IGNORE
3. C. MERGE
4. D. APPEND
5. E. INSERT

Correct Answer: C
To write data into a Delta table while avoiding the writing of duplicate records, you can use the MERGE command. The MERGE command in Delta Lake allows you to combine the ability to insert new records and update existing records in a single atomic operation. The MERGE command compares the data being written with the existing data in the Delta table based on specified matching criteria, typically using a primary key or unique identifier. It then performs conditional actions, such as inserting new records or updating existing records, depending on the comparison results. By using the MERGE command, you can handle the prevention of duplicate records in a more controlled and efficient manner. It allows you to synchronize and reconcile data from different sources while avoiding duplication and ensuring data integrity.

A data engineer wants to schedule their Databricks SQL dashboard to refresh once per day, but they only want the associated SQL endpoint to be running when it is necessary.
Which of the following approaches can the data engineer use to minimize the total running time of the SQL endpoint used in the refresh schedule of their dashboard?

1. A. They can ensure the dashboard’s SQL endpoint matches each of the queries’ SQL endpoints.
2. B. They can set up the dashboard’s SQL endpoint to be serverless.
3. C. They can turn on the Auto Stop feature for the SQL endpoint.
4. D. They can reduce the cluster size of the SQL endpoint.
5. E. They can ensure the dashboard’s SQL endpoint is not one of the included query’s SQL endpoint.

Correct Answer: C