The data engineer team has been tasked with configured connections to an external database that does not have a supported native connector with Databricks. The external database already has data security configured by group membership. These groups map directly to user group already created in Databricks that represent various teams within the company. A new login credential has been created for each group in the external database. The Databricks Utilities Secrets module will be used to make these credentials available to Databricks users. Assuming that all the credentials are configured correctly on the external database and group membership is properly configured on Databricks, which statement describes how teams can be granted the minimum necessary access to using these credentials?

• A."Read'' permissions should be set on a secret key mapped to those credentials that will be used by a given team.
• B.No additional configuration is necessary as long as all users are configured as administrators in the workspace where secrets have been added.
• C."Read" permissions should be set on a secret scope containing only those credentials that will be used by a given team.
• D."Manage" permission should be set on a secret scope containing only those credentials that will be used by a given team.

Comment: *

Name: *

Email: *

Verification: *

A company stores account transactions in a Delta Lake table. The company needs to apply frequent account-level correlations (e.g., UPDATE statements) but wants to avoid rewriting entire Parquet files for each change to reduce file churn and improve write performance. Which Delta Lake feature should they enable?

• A.Enable automatic file compaction on writes
• B.Enable change data feed on the Delta table
• C.Partition the Delta table by account_id
• D.Enable deletion vectors on the Delta table

Comment: *

Name: *

Email: *

Verification: *

The business reporting tem requires that data for their dashboards be updated every hour. The total processing time for the pipeline that extracts transforms and load the data for their pipeline runs in 10 minutes.
Assuming normal operating conditions, which configuration will meet their service-level agreement requirements with the lowest cost?

• A.Schedule a job to execute the pipeline once an hour on a dedicated interactive cluster.
• B.Schedule a Structured Streaming job with a trigger interval of 60 minutes.
• C.Schedule a job to execute the pipeline once an hour on a new job cluster.
• D.Configure a job that executes every time new data lands in a given directory.

Comment: *

Name: *

Email: *

Verification: *

Given the following PySpark code snippet in a Databricks notebook:
filtered_df = spark.read.format("delta").load("/mnt/data/large_table")
\
.filter("event_date > '2024-01-01'")
filtered_df.count()
The data engineer notices from the Query Profiler that the scan operator for filtered_df is reading almost all files, despite the filter being applied.
What is the probable reason for poor data skipping?

• A.The Delta table lacks optimization that enables dynamic file pruning.
• B.The filter is executed only after the full data scan, preventing data skipping.
• C.The event_date column is outside the table's partitioning and Z-ordering scheme.
• D.The filter condition involves a data type excluded from data skipping support.

Comment: *

Name: *

Email: *

Verification: *

An external object storage container has been mounted to the location /mnt/finance_eda_bucket.
The following logic was executed to create a database for the finance team:

After the database was successfully created and permissions configured, a member of the finance team runs the following code:

If all users on the finance team are members of the finance group, which statement describes how the tx_sales table will be created?

• A.A logical table will persist the query plan to the Hive Metastore in the Databricks control plane.
• B.An external table will be created in the storage container mounted to /mnt/finance eda bucket.
• C.A logical table will persist the physical plan to the Hive Metastore in the Databricks control plane.
• D.An managed table will be created in the storage container mounted to /mnt/finance_eda_bucket.
• E.A managed table will be created in the DBFS root storage container.

Comment: *

Name: *

Email: *

Verification: *