Create and Add Descriptions/metadata About Enterprise Data to Make It More Discoverable. DATA-ENGINEER-PROFESSIONAL Practice Questions (Page 5)

Questions 21–25

1. 21foundation · easy

   What does data lineage in Unity Catalog help you understand?

   • AThe physical storage location of the data files
   • BHow data flows from source to destination, including transformations
   • CThe number of users who have accessed the data
   • DThe cluster configuration used to process the data
   Reveal Solution Discussion Select an answer first
2. 22application · easy

   A data engineer needs to verify that a table property `retention_days` is set to '30' on table `logs.app_events`. Which SQL command should they run?

   • ADESCRIBE logs.app_events
   • BSHOW TBLPROPERTIES logs.app_events
   • CSHOW CREATE TABLE logs.app_events
   • DSELECT * FROM logs.app_events
   Reveal Solution Discussion Select an answer first
4. 23expert · medium

   A large enterprise is adopting Unity Catalog and needs to ensure that metadata for tables and schemas is consistent across multiple workspaces. They want to avoid duplicating metadata management efforts. Which approach best leverages Unity Catalog's architecture?

   • AUse a single Unity Catalog metastore that is attached to all workspaces, and manage metadata centrally.
   • BCreate a separate metastore for each workspace to isolate metadata.
   • CUse the Databricks CLI to sync metadata between workspaces.
   • DManually update metadata in each workspace using Catalog Explorer.
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   A data team wants to document the lineage of a table `analytics.revenue` by noting that it is derived from `raw.orders` and `raw.payments`. They also want to record the data owner. Which approach best captures this in the table's metadata?

   • AAdd a table comment describing the lineage and set a table property for `owner`.
   • BOnly set table properties for `lineage` and `owner`.
   • COnly add a table comment that includes both lineage and owner.
   • DCreate a separate lineage document in a wiki and link it in the table comment.
   Reveal Solution Discussion Select an answer first
6. 25application · medium

   A data team wants to store custom metadata on a table to indicate the data owner and the refresh schedule. They plan to use table properties. Which approach is correct?

   • AUse ALTER TABLE ... SET TBLPROPERTIES to add key-value pairs for owner and refresh_schedule.
   • BUse the COMMENT ON TABLE command with multiple key-value pairs.
   • CCreate a separate metadata table to store the information.
   • DAdd a comment to the table that includes the owner and refresh schedule in the text.
   Reveal Solution Discussion Select an answer first