DP-750: Implementing Data Engineering Solutions Using Azure Databricks

DP-750: Implementing Data Engineering Solutions Using Azure Databricks practice questions, page 4 of 5, with answer review and explanations.

Question 16

You have an Azure Databricks workspace named Workspace1 that is attached to a Unity Catalog metastore named metastore1. You need to register an Azure Storage account named account1 that has a hierarchical namespace enabled as an external location. The external location must use a managed identity to authenticate to account1 and the solution must follow the principle of least privilege. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Question 17

You have an Azure Databricks workspace that is enabled for Unity Catalog. You need to ensure that data lineage is captured and can be reviewed for tables accessed by Databricks notebooks and jobs. The solution must minimize administrative effort. Which compute configuration should you use to capture the data lineage and what should you use to review the data lineage? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 18

You have an Azure Databricks workspace. You have an Azure key vault named kv-secure that stores a secret named storageKey. The value of storageKey is managed and updated by the cloud security team at your company. You need to enable a Databricks notebook named Notebook1 to retrieve the value of storageKey securely at runtime. The solution must follow the principle of least privilege and always retrieve the latest value. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 19

You have an Azure Databricks workspace that is enabled for Unity Catalog and contains a catalog named Catalog1. Catalog1 contains a schema named Schema1 and a table named Table1. You need to ensure that access to the data in Table1 is controlled by using attribute-based access control (ABAC). What should you apply to Table1, and how should you control access for users? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 20

You have an Azure Databricks workspace that is enabled for Unity Catalog. You need to implement a data lifecycle and expiration solution that meets the following requirements: Transaction logs and deleted data files that are older than 90 days must be removed from Delta tables to reclaim storage.All the tables must remain available for querying during the cleanup process.Administrative effort must be minimized. What should you do for each requirement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.