Govern Unity Catalog Objects DP-750 Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

   Which tool in Databricks provides a visual interface to view data lineage, including table dependencies?

   • ASecrets Manager
   • BCatalog Explorer
   • CJob Scheduler
   • DCluster Manager
   Reveal Solution Discussion Select an answer first
2. 17application · medium

   A data governance team wants to ensure that all columns in a new Unity Catalog table have clear descriptions that are visible to data consumers. They also want to classify columns as `PII` or `non-PII` to support future access policies. What should they do?

   • AUse column masks to hide PII columns and rely on the mask for classification.
   • BAdd column comments to each column and apply tags such as `PII` to the relevant columns.
   • CGrant SELECT on the table only to users who already know the column meanings.
   • DCreate a separate metadata table that stores column descriptions and classifications.
   Reveal Solution Discussion Select an answer first
4. 18application · medium

   A retail company has a `sales` table in Unity Catalog. The sales team should only see transactions for their assigned region. The company also needs to track which users attempt to query rows outside their region for security auditing. What should the data engineer do?

   • AUse a view that joins the sales table with a user-region table and grant access to the view.
   • BApply a column mask on the region column so users cannot see regions outside their own.
   • CCreate separate tables per region and grant SELECT on the appropriate table to each salesperson.
   • DCreate a row filter that uses a mapping table of user-to-region and enable audit logging on the table.
   Reveal Solution Discussion Select an answer first
5. 19expert · hard

   A multinational corporation uses Unity Catalog to manage employee data. The security policy requires that HR managers see all employee records, but line managers see only records for their own department. The company also needs to audit all access to the employee table. The data engineering team is considering using a row filter with a CASE statement that checks the current user's group. What is the main challenge they should address?

   • ARow filters are not applied when users query the table through a view.
   • BRow filters cannot reference group membership directly; they must use a mapping table.
   • CRow filters must be created by the table owner, and the owner must have the necessary permissions.
   • DRow filters are evaluated at query time, so performance may degrade on large tables.
   Reveal Solution Discussion Select an answer first
6. 20expert · hard

   A data provider wants to share a table with multiple external partners using Delta Sharing. Each partner should see only a subset of rows based on a `partner_id` column, and the `revenue` column should be masked for all partners except one premium partner. The provider wants to avoid creating separate tables for each partner. What should they do?

   • AShare the table as-is and rely on each partner to filter and mask the data themselves.
   • BUse a column mask on `partner_id` to hide the partner identifier from all partners.
   • CCreate a single share with the table and apply a row filter on `partner_id` and a column mask on `revenue` that references the recipient's identity.
   • DCreate a separate share for each partner with a view that filters rows and masks revenue.
   Reveal Solution Discussion Select an answer first