A data engineer is designing a Bronze-to-Silver pipeline on the Databricks Data Intelligence Platform. The source system sends daily CSV files, and new optional columns are added over time.
The engineer needs a storage format and table capabilities that provide all of the following:
Writes that do not conform to the defined schema are rejected.
The schema can evolve to include new optional columns without manually recreating the table.
Previous table versions can be queried for debugging and auditing.
Which solution fulfills these requirements?

• A.Use a Delta table with its native schema enforcement, schema evolution, and table-history capabilities.
• B.Use an external table with Auto Loader schema inference for the CSV files.
• C.Use a Delta table with schema enforcement and recreate the table whenever new columns are added.
• D.Use a Parquet table with Spark's default schema inference and rerun the job whenever the schema changes.

Comment: *

Name: *

Email: *

Verification: *

A data organization leader is upset about the data analysis team's reports being different from the data engineering team's reports. The leader believes the siloed nature of their organization's data engineering and data analysis architectures is to blame.
Which of the following describes how a data lakehouse could alleviate this issue?

• A.Both teams would autoscale their work as data size evolves
• B.Both teams would use the same source of truth for their work
• C.Both teams would reorganize to report to the same department
• D.Both teams would be able to collaborate on projects in real-time
• E.Both teams would respond more quickly to ad-hoc requests

Comment: *

Name: *

Email: *

Verification: *

A data engineer has configured a Structured Streaming job to read from a table, manipulate the data, and then perform a streaming write into a new table.
The code block used by the data engineer is below:

If the data engineer only wants the query to process all of the available data in as many batches as required, which of the following lines of code should the data engineer use to fill in the blank?

• A.trigger(continuous="once")
• B.trigger(availableNow=True)
• C.trigger(processingTime="once")
• D.processingTime(1)
• E.trigger(parallelBatch=True)

Comment: *

Name: *

Email: *

Verification: *

A data engineer only wants to execute the final block of a Python program if the Python variable day_of_week is equal to 1 and the Python variable review_period is True.
Which of the following control flow statements should the data engineer use to begin this conditionally executed code block?

• A.if day_of_week = 1 and review_period:
• B.if day_of_week = 1 and review_period = "True":
• C.if day_of_week == 1 and review_period == "True":
• D.if day_of_week == 1 and review_period:
• E.if day_of_week = 1 & review_period: = "True":

Comment: *

Name: *

Email: *

Verification: *

A data engineer needs access to a table new_table, but they do not have the correct permissions. They can ask the table owner for permission, but they do not know who the table owner is.
Which of the following approaches can be used to identify the owner of new_table?

• A.Review the Permissions tab in the table's page in Data Explorer
• B.All of these options can be used to identify the owner of the table
• C.Review the Owner field in the table's page in Data Explorer
• D.Review the Owner field in the table's page in the cloud storage solution
• E.There is no way to identify the owner of the table

Comment: *

Name: *

Email: *

Verification: *