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

Questions 11–15

1. 11application · medium

   A company's data platform team spends significant time manually granting permissions on each table after creation and maintaining a separate audit log for data access. They are moving to Unity Catalog managed tables to reduce this administrative overhead. Which benefit directly addresses their current pain points?

   • AUnity Catalog automatically grants all users access to new tables, removing the need for manual grants.
   • BUnity Catalog centralizes permissions and auditing, so grants and access logs are managed at the catalog level rather than per table.
   • CUnity Catalog automatically backs up all table data to a separate region, eliminating the need for manual audit logs.
   • DUnity Catalog requires each table to have its own access control list, but it generates audit logs automatically.
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A startup is building a new data lakehouse and wants to minimize the time engineers spend on table creation. They currently use external tables and must specify a storage path for every table. They are considering Unity Catalog managed tables to simplify this process. What is the key operational advantage of managed tables in this context?

   • AEngineers must use a separate tool to generate the storage path before creating a managed table.
   • BEngineers no longer need to specify or track storage locations, as Unity Catalog manages the location automatically.
   • CEngineers must still specify a location, but Unity Catalog validates it automatically.
   • DEngineers can only create managed tables in a default location, which is fixed for the entire workspace.
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   Which statement best describes the storage cleanup effort for managed tables compared to external tables?

   • AManaged tables require more cleanup effort because Unity Catalog does not delete data files.
   • BManaged tables require the same cleanup effort as external tables.
   • CManaged tables require less cleanup effort because Unity Catalog automatically deletes data files when the table is dropped.
   • DManaged tables require more cleanup effort because you must manually delete the data files after dropping the table.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   When creating a managed table in Unity Catalog, what do you need to specify regarding the storage location?

   • AYou must specify a cloud storage path for the data files.
   • BYou do not need to specify a storage location; Unity Catalog manages it automatically.
   • CYou must specify a storage location only if the table is large.
   • DYou must specify a storage location only if you want to use a non-default format.
   Reveal Solution Discussion Select an answer first
6. 15expert · hard

   A data science team uses managed tables in Unity Catalog for their feature store. They need to provide documentation of data lineage for model validation. They are considering whether to rely on Unity Catalog's automatic lineage or maintain a separate documentation process. Which approach is most effective?

   • AUse external tables instead of managed tables to get better lineage tracking.
   • BRely on Unity Catalog's automatic lineage for managed tables, and supplement it with a lightweight process for any external data sources.
   • CRely solely on Unity Catalog's automatic lineage, as it covers all data sources including external tables.
   • DMaintain a separate documentation process for all tables, because Unity Catalog's lineage is not reliable.
   Reveal Solution Discussion Select an answer first