The Databricks workspace administrator has configured interactive clusters for each of the data engineering groups. To control costs, clusters are set to terminate after 30 minutes of inactivity. Each user should be able to execute workloads against their assigned clusters at any time of the day.
Assuming users have been added to a workspace but not granted any permissions, which of the following describes the minimal permissions a user would need to start and attach to an already configured cluster.

• A."Can Manage" privileges on the required cluster
• B.Workspace Admin privileges, cluster creation allowed. "Can Attach To" privileges on the required cluster
• C.Cluster creation allowed. "Can Attach To" privileges on the required cluster
• D."Can Restart" privileges on the required cluster
• E.Cluster creation allowed. "Can Restart" privileges on the required cluster

Comment: *

Name: *

Email: *

Verification: *

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."Manage" permission should be set on a secret scope containing only those credentials that will be used by a given team.
• D."Read" permissions should be set on a secret scope containing only those credentials that will be used by a given team.

Comment: *

Name: *

Email: *

Verification: *

Which statement describes the default execution mode for Databricks Auto Loader?

• A.New files are identified by listing the input directory; new files are incrementally and idempotently loaded into the target Delta Lake table.
• B.Cloud vendor-specific queue storage and notification services are configured to track newly arriving files; new files are incrementally and impotently into the target Delta Lake table.
• C.Webhook trigger Databricks job to run anytime new data arrives in a source directory; new data automatically merged into target tables using rules inferred from the data.
• D.New files are identified by listing the input directory; the target table is materialized by directory querying all valid files in the source directory.

Comment: *

Name: *

Email: *

Verification: *

A Delta Lake table was created with the below query:

Consider the following query:
DROP TABLE prod.sales_by_store -
If this statement is executed by a workspace admin, which result will occur?

• A.Nothing will occur until a COMMIT command is executed.
• B.The table will be removed from the catalog but the data will remain in storage.
• C.The table will be removed from the catalog and the data will be deleted.
• D.An error will occur because Delta Lake prevents the deletion of production data.
• E.Data will be marked as deleted but still recoverable with Time Travel.

Comment: *

Name: *

Email: *

Verification: *

The downstream consumers of a Delta Lake table have been complaining about data quality issues impacting performance in their applications. Specifically, they have complained that invalidlatitudeandlongitudevalues in theactivity_detailstable have been breaking their ability to use other geolocation processes.
A junior engineer has written the following code to addCHECKconstraints to the Delta Lake table:

A senior engineer has confirmed the above logic is correct and the valid ranges for latitude and longitude are provided, but the code fails when executed.
Which statement explains the cause of this failure?

• A.Because another team uses this table to support a frequently running application, two-phase locking is preventing the operation from committing.
• B.The activity details table already exists; CHECK constraints can only be added during initial table creation.
• C.The activity details table already contains records that violate the constraints; all existing data must pass CHECK constraints in order to add them to an existing table.
• D.The activity details table already contains records; CHECK constraints can only be added prior to inserting values into a table.
• E.The current table schema does not contain the field valid coordinates; schema evolution will need to be enabled before altering the table to add a constraint.

Comment: *

Name: *

Email: *

Verification: *