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

Questions 26–30

1. 26foundation · easy

   What is Delta Sharing primarily used for?

   • ATo backup data to a different region
   • BTo securely share live data across organizations without copying it
   • CTo improve query performance
   • DTo migrate data between clouds
   Reveal Solution Discussion Select an answer first
2. 27application · medium

   A financial services firm stores customer data in a Unity Catalog table. The compliance team requires that the `account_number` column be visible only to users in the `finance_managers` group. All other users should see a masked value. The data engineering team also wants to document the masking rule for future data discovery. What should they do?

   • ACreate a column mask on `account_number` that returns the original value for `finance_managers` and a masked value for others, and add a column comment describing the mask.
   • BGrant SELECT on the table only to `finance_managers` and create a separate table with masked data for all other users.
   • CCreate a view that selects `account_number` only for finance managers and a NULL for others, then grant access to the view.
   • DUse a tag on the column to indicate sensitivity and rely on the tag to hide the column from non-privileged users.
   Reveal Solution Discussion Select an answer first
4. 28foundation · easy

   Which SQL command is used to add a comment to an existing column in a Unity Catalog table?

   • AALTER TABLE ... ALTER COLUMN ... COMMENT
   • BUPDATE TABLE ... SET COLUMN COMMENT
   • CCOMMENT ON COLUMN ... IS
   • DMODIFY COLUMN ... COMMENT
   Reveal Solution Discussion Select an answer first
5. 29application · medium

   A multi-national company uses Unity Catalog to govern data access. They have a requirement that users from the EU region should only see rows where `region = 'EU'` and the `tax_id` column should be masked for all users except `tax_auditors`. They want to implement this using a centralized policy that can be reused across multiple tables. What should they do?

   • ACreate a materialized view that pre-filters EU rows and masks tax_id, then grant access to the view.
   • BCreate a row filter and a column mask function that reference a user's region attribute, then apply them to each table.
   • CCreate separate views for EU users and grant access to those views.
   • DUse tags to mark EU rows and rely on tag-based access control to filter rows.
   Reveal Solution Discussion Select an answer first
6. 30application · medium

   A data governance team needs to understand how a sales table was created, who modified it last, and which downstream reports depend on it. They also need to see a history of all queries that accessed the table. What should they use?

   • AThe table's owner and the workspace's activity log.
   • BThe metastore's audit log and the table's change history.
   • CCatalog Explorer's lineage tab and the audit log.
   • DThe table's properties and the query history tab in the SQL editor.
   Reveal Solution Discussion Select an answer first