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

Questions 6–10

1. 6foundation · easy

   How does Unity Catalog provide data lineage for managed tables?

   • AIt provides lineage only for tables created in the Databricks SQL editor.
   • BIt requires users to manually document data flow in a separate tool.
   • CIt automatically tracks lineage by analyzing query history and table dependencies.
   • DIt only tracks lineage for external tables, not managed tables.
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A data platform team is evaluating whether to use managed or external tables for a new analytics environment. They want to minimize the operational burden of table lifecycle management, including creation, deletion, and cleanup. Which approach best meets this requirement?

   • AUse managed tables, but only if the team is willing to manually delete data files after dropping tables.
   • BUse external tables, as they provide automatic lifecycle management without any manual steps.
   • CUse managed tables, as Unity Catalog automatically handles creation, deletion, and cleanup of underlying data files.
   • DUse external tables, as they allow Unity Catalog to manage the storage location automatically.
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   What operational benefit does built-in data lineage provide for managed tables?

   • AIt reduces the need for manual documentation of data flow.
   • BIt eliminates the need for data quality checks.
   • CIt ensures that all tables are backed up automatically.
   • DIt automatically optimizes query performance.
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A team is planning to add several new columns to a large managed table to support new analytics. They are concerned about the operational effort required to update the schema and ensure data files are compatible. What should they expect when using a Unity Catalog managed table?

   • AThey must manually update the schema in the metastore and then rewrite all data files to match.
   • BThe schema change is applied automatically, and Unity Catalog ensures metadata consistency without manual file updates.
   • CThey must pause all queries and run a separate schema migration tool.
   • DThey must create a new table with the updated schema and copy all data into it.
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A team frequently alters table schemas to add new columns for evolving business requirements. With external tables, they must manually update the schema in the metastore and ensure the underlying files match. They are moving to Unity Catalog managed tables to reduce this maintenance. How does Unity Catalog simplify schema evolution?

   • AUnity Catalog requires the team to manually update both the schema and the data files, but it provides a validation tool.
   • BUnity Catalog automatically propagates schema changes to the underlying data files, so no manual file updates are needed.
   • CUnity Catalog prevents any schema changes after table creation, eliminating the need for updates.
   • DUnity Catalog only allows schema changes through a separate administrative tool, adding overhead.
   Reveal Solution Discussion Select an answer first