A data engineer is using the following code block as part of a batch ingestion pipeline to read from a composable table:

Which of the following changes needs to be made so this code block will work when the transactions table is a stream source?

• A.Replace predict with a stream-friendly prediction function
• B.Replace schema(schema) with option ("maxFilesPerTrigger", 1)
• C.Replace "transactions" with the path to the location of the Delta table
• D.Replace format("delta") with format("stream")
• E.Replace spark.read with spark.readStream

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.delta.table
• B.dbutils.sql
• C.spark.table
• D.spark.delta.sql
• E.spark.sql

Comment: *

Name: *

Email: *

Verification: *

Which query is performing a streaming hop from raw data to a Bronze table?

• A.
• B.
• C.
• D.

Comment: *

Name: *

Email: *

Verification: *

What is the functionality of AutoLoader in Databricks?

• A.Auto Loader automatically ingests and processes new files from cloud storage, handling both batch and streaming data with support for schema evolution.
• B.Auto Loader automatically ingests and processes new files from cloud storage, handling batch and streaming data with no support for schema evolution.
• C.Auto Loader automatically ingests and processes new files from cloud storage, handling only streaming data with no support for schema evolution.
• D.Auto Loader automatically ingests and processes new files from cloud storage, handling batch data with support for schema evolution.

Comment: *

Name: *

Email: *

Verification: *

A data engineer runs a statement every day to copy the previous day's sales into the table transactions. Each day's sales are in their own file in the location "/transactions/raw".
Today, the data engineer runs the following command to complete this task:

After running the command today, the data engineer notices that the number of records in table transactions has not changed.
Which of the following describes why the statement might not have copied any new records into the table?

• A.The format of the files to be copied were not included with the FORMAT_OPTIONS keyword.
• B.The names of the files to be copied were not included with the FILES keyword.
• C.The previous day's file has already been copied into the table.
• D.The PARQUET file format does not support COPY INTO.
• E.The COPY INTO statement requires the table to be refreshed to view the copied rows.

Comment: *

Name: *

Email: *

Verification: *