Which of the following describes the relationship between Bronze tables and raw data?

• A.Bronze tables contain less data than raw data files.
• B.Bronze tables contain more truthful data than raw data.
• C.Bronze tables contain aggregates while raw data is unaggregated.
• D.Bronze tables contain a less refined view of data than raw data.
• E.Bronze tables contain raw data with a schema applied.

Comment: *

Name: *

Email: *

Verification: *

Which of the following describes the relationship between Bronze tables and raw data?

• A.Bronze tables contain aggregates while raw data is unaggregated.
• B.Bronze tables contain less data than raw data files.
• C.Bronze tables contain more truthful data than raw data.
• D.Bronze tables contain a less refined view of data than raw data.
• E.Bronze tables contain raw data with a schema applied.

Comment: *

Name: *

Email: *

Verification: *

In which of the following scenarios should a data engineer use the MERGE INTO command instead of the INSERT INTO command?

• A.When the location of the data needs to be changed
• B.When the target table is an external table
• C.When the source table can be deleted
• D.When the target table cannot contain duplicate records
• E.When the source is not a Delta table

Comment: *

Name: *

Email: *

Verification: *

A data engineer and data analyst are working together on a data pipeline. The data engineer is working on the raw, bronze, and silver layers of the pipeline using Python, and the data analyst is working on the gold layer of the pipeline using SQL. The raw source of the pipeline is a streaming input. They now want to migrate their pipeline to use Delta Live Tables.
Which of the following changes will need to be made to the pipeline when migrating to Delta Live Tables?

• A.None of these changes will need to be made
• B.The pipeline will need to be written entirely in Python
• C.The pipeline will need to be written entirely in SQL
• D.The pipeline will need to stop using the medallion-based multi-hop architecture
• E.The pipeline will need to use a batch source in place of a streaming source

Comment: *

Name: *

Email: *

Verification: *

A data engineer has a Python variable table_name that they would like to use in a SQL query. They want to construct a Python code block that will run the query using table_name.
They have the following incomplete code block:
____(f"SELECT customer_id, spend FROM {table_name}")
Which of the following can be used to fill in the blank to successfully complete the task?

• A.spark.table
• B.spark.sql
• C.spark.delta.table
• D.dbutils.sql
• E.spark.delta.sql

Comment: *

Name: *

Email: *

Verification: *