Which of the following is hosted completely in the control plane of the classic Databricks architecture?

• A.Worker node
• B.JDBC data source
• C.Databricks web application
• D.Databricks Filesystem
• E.Driver node

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: *

A data engineering team has noticed that their Databricks SQL queries are running too slowly when they are submitted to a non-running SQL endpoint. The data engineering team wants this issue to be resolved.
Which of the following approaches can the team use to reduce the time it takes to return results in this scenario?

• A.They can turn on the Serverless feature for the SQL endpoint and change the Spot Instance Policy to
  "Reliability Optimized."
• B.They can turn on the Auto Stop feature for the SQL endpoint.
• C.They can increase the cluster size of the SQL endpoint.
• D.They can turn on the Serverless feature for the SQL endpoint.
• E.They can increase the maximum bound of the SQL endpoint's scaling range

Comment: *

Name: *

Email: *

Verification: *

A data engineer has three tables in a Delta Live Tables (DLT) pipeline. They have configured the pipeline to drop invalid records at each table. They notice that some data is being dropped due to quality concerns at some point in the DLT pipeline. They would like to determine at which table in their pipeline the data is being dropped.
Which of the following approaches can the data engineer take to identify the table that is dropping the records?

• A.They can set up separate expectations for each table when developing their DLT pipeline.
• B.They cannot determine which table is dropping the records.
• C.They can set up DLT to notify them via email when records are dropped.
• D.They can navigate to the DLT pipeline page, click on each table, and view the data quality statistics.
• E.They can navigate to the DLT pipeline page, click on the "Error" button, and review the present errors.

Comment: *

Name: *

Email: *

Verification: *

A data architect has determined that a table of the following format is necessary:

Which of the following code blocks uses SQL DDL commands to create an empty Delta table in the above format regardless of whether a table already exists with this name?

• A.Option A
• B.Option E
• C.Option C
• D.Option B
• E.Option D

Comment: *

Name: *

Email: *

Verification: *