Which of the following statements regarding the relationship between Silver tables and Bronze tables is always true?

1. A. Silver tables contain a less refined, less clean view of data than Bronze data.
2. B. Silver tables contain aggregates while Bronze data is unaggregated.
3. C. Silver tables contain more data than Bronze tables.
4. D. Silver tables contain a more refined and cleaner view of data than Bronze tables.
5. E. Silver tables contain less data than Bronze tables.

Correct Answer: D
https://www.databricks.com/glossary/medallion-architecture

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 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.

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