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

Questions 6–10

1. 6foundation · easy

   In Unity Catalog, which object is used to define what data is shared with a recipient in Delta Sharing?

   • ARecipient
   • BCatalog
   • CProvider
   • DShare
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   Where are Unity Catalog audit logs typically delivered for long-term storage and analysis?

   • ATo a cloud storage location such as Azure Blob Storage or AWS S3
   • BTo the local disk of the cluster
   • CTo the user's browser cache
   • DTo the Databricks control plane database
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A company needs to monitor who is accessing a sensitive Unity Catalog table and whether row filters are being applied correctly. The security team wants to receive alerts when a user outside the allowed group queries the table. What should they configure?

   • AGrant SELECT only to authorized users and use table history to see who accessed the table.
   • BUse column masks to hide sensitive columns and assume that masked queries are logged.
   • CEnable audit logging on the workspace and set up alerts on the audit logs for table access events.
   • DCreate a row filter that denies access to unauthorized users and rely on the filter to generate alerts.
   Reveal Solution Discussion Select an answer first
5. 9expert · hard

   A large enterprise uses Unity Catalog to govern a `transactions` table. The compliance team requires that users from the `fraud_analysts` group see only rows where `status = 'flagged'`. The security team wants to log every query that returns zero rows due to the row filter to detect potential unauthorized access attempts. The data engineering team wants to avoid creating multiple views or duplicating data. What should they do?

   • AUse a column mask on the `status` column to hide non-flagged rows from non-fraud analysts.
   • BApply a row filter on the `transactions` table that returns rows only for `fraud_analysts` when `status = 'flagged'`, and enable audit logging on the table.
   • CCreate a view that filters rows for `fraud_analysts` and grant access to the view, while relying on the view's query logs.
   • DCreate separate tables for flagged and non-flagged transactions and grant access to the appropriate table.
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A media company stores user activity logs in a Unity Catalog table. The legal team requires that raw logs be retained for exactly 90 days, after which they must be automatically deleted. The data engineering team also wants to track when the retention policy was last modified for compliance reporting. What should they do?

   • ACreate a scheduled job that runs daily and deletes rows older than 90 days.
   • BApply a column mask on the timestamp column to hide old rows.
   • CSet a table retention policy of 90 days using Unity Catalog's lifecycle management and review the table's history for policy changes.
   • DUse a view that filters out rows older than 90 days and grant access to the view.
   Reveal Solution Discussion Select an answer first