Understand How / Why Using Unity Catalog Managed Tables Reduces Operations Overhead and Maintenance Burden. DATA-ENGINEER-PROFESSIONAL Practice Questions (Page 4)

Questions 16–20

1. 16application · medium

   A multinational company must enforce consistent data access policies across all analytics tables. Currently, each team manages permissions separately for their tables, leading to inconsistent policies and audit gaps. They are moving to Unity Catalog managed tables to standardize governance. What is the primary governance benefit they will gain?

   • AUnity Catalog generates a unique audit log for each table, but permissions must still be managed per table.
   • BPermissions and audit policies can be applied centrally at the catalog or schema level, ensuring consistency.
   • CEach table automatically inherits the most permissive policy from any team, simplifying access.
   • DUnity Catalog automatically grants access to all users based on their role in the organization.
   Reveal Solution Discussion Select an answer first
2. 17expert · hard

   A large enterprise has multiple business units, each with its own Databricks workspace. They are adopting Unity Catalog to centralize governance and reduce the overhead of managing permissions and audit logs per table. However, each business unit has specific compliance requirements for data access. What is the best way to balance centralized governance with business-unit-specific controls?

   • AUse a single catalog for all business units and apply the same permissions to all tables to ensure consistency.
   • BUse external tables for each business unit so that each unit can manage its own permissions independently.
   • CUse a separate metastore for each business unit to ensure complete isolation.
   • DUse Unity Catalog to create separate catalogs or schemas for each business unit, and apply centralized policies at the metastore level while allowing unit-specific grants at the catalog/schema level.
   Reveal Solution Discussion Select an answer first
4. 18expert · hard

   A data platform team is responsible for managing hundreds of tables. They currently use external tables and have a nightly job that deletes orphaned data files from cloud storage. They are considering moving to managed tables to eliminate this job. However, they are concerned about the risk of accidentally dropping a table and losing data. Which approach best addresses their concern while still reducing operational overhead?

   • AUse managed tables, but disable the drop table permission for all users to prevent accidental drops.
   • BUse managed tables for most workloads, but implement strict access controls and rely on Unity Catalog's audit logs to prevent and detect accidental drops.
   • CUse managed tables, but also maintain a separate backup of all data files to recover from accidental drops.
   • DContinue using external tables to avoid the risk of data loss on drop, and keep the nightly cleanup job.
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   A data engineer is creating a new table for a one-time data load. They want to minimize setup time and avoid having to choose a storage path. Which table type should they use in Unity Catalog?

   • AAn external table, because it automatically uses the default managed storage location.
   • BA managed table, because it automatically uses a managed storage location without requiring a path.
   • CA managed table, but only if the engineer provides a storage path for the data.
   • DAn external table, because it does not require any location specification.
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   Which feature of Unity Catalog provides a centralized view of who accessed what data and when?

   • AData lineage
   • BSchema evolution
   • CStorage credentials
   • DAudit logging
   Reveal Solution Discussion Select an answer first