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

Questions 1–5

1. 1application · medium

   A team has experienced issues where table metadata becomes inconsistent with the actual data files, especially after schema changes. They want to reduce these inconsistencies and the associated maintenance work. They are considering Unity Catalog managed tables. How do managed tables help ensure consistent metadata?

   • AUnity Catalog requires manual metadata refresh after every data change, ensuring consistency.
   • BUnity Catalog automatically updates metadata for managed tables, keeping it consistent with the data files.
   • CUnity Catalog stores metadata in the same file as the data, preventing inconsistencies.
   • DUnity Catalog only updates metadata during scheduled maintenance windows, reducing conflicts.
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A financial services company must document data lineage for regulatory audits. Currently, they manually track which tables feed into reports and update documentation after every pipeline change. They are adopting Unity Catalog managed tables to reduce this effort. Which feature of managed tables directly helps with lineage documentation?

   • AUnity Catalog stores lineage information in a separate system that requires manual export.
   • BUnity Catalog only tracks lineage for external tables, not managed tables.
   • CUnity Catalog automatically captures lineage for managed tables, so manual documentation is no longer required.
   • DUnity Catalog generates lineage reports only when explicitly requested by an administrator.
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   For a Unity Catalog external table, who is responsible for managing the lifecycle of the underlying data files?

   • AUnity Catalog automatically manages the data files, including deletion when the table is dropped.
   • BThe Databricks workspace administrator is responsible for managing the data files.
   • CThe cloud provider manages the data files as part of the storage service.
   • DThe user or system that owns the storage location is responsible for managing the data files.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   What is a key operational advantage of Unity Catalog managed tables when evolving a table's schema?

   • AYou can change the data type of a column without rewriting the data files.
   • BYou do not need to manually update the underlying data files to match the new schema.
   • CYou can add a column without affecting any downstream queries.
   • DYou can drop a column without any impact on the table's metadata.
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A company has a mix of tables: some are managed and some are external in Unity Catalog. A data engineer accidentally drops a table that was used for a critical report. The team needs to recover the data. Which table type is more likely to have the data still available in cloud storage after the drop?

   • AThe external table, because dropping it only removes metadata and leaves the data files in place.
   • BNeither table type, because Unity Catalog immediately purges all data on any drop.
   • CThe managed table, because Unity Catalog retains a backup of the data for 30 days.
   • DBoth table types, because Unity Catalog always preserves data files on drop.
   Reveal Solution Discussion Select an answer first