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

Questions 1–5

1. 1expert · medium

   A data governance team wants to enforce that every schema in a catalog has a description. They have hundreds of schemas and want to identify which ones are missing descriptions. Which approach is most efficient?

   • AQuery the Unity Catalog system tables (e.g., `system.information_schema.schemata`) to list schemas with null comments.
   • BManually browse each schema in Catalog Explorer to check for descriptions.
   • CUse the Databricks CLI to list schemas and parse the output.
   • DUse `SHOW SCHEMAS` and then run `DESCRIBE SCHEMA` for each one.
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A data governance team needs to document the ownership and lineage of a critical table `risk.exposures`. They want to record the owning team and the upstream source table in the table's metadata. Which approach best achieves this?

   • ACreate a separate documentation notebook and store the information there.
   • BUse the `OWNER` clause in ALTER TABLE to set the owner and rely on automatic lineage tracking.
   • CSet table properties for `owner_team` and `upstream_source`, and add a table comment describing the lineage.
   • DOnly add a table comment that includes both the owner and lineage information.
   Reveal Solution Discussion Select an answer first
4. 3expert · medium

   A data engineer is troubleshooting why a table property `quality_status` is not visible to some users when they run `SHOW TBLPROPERTIES`. The table is in Unity Catalog. What is the most likely reason?

   • AThe property is stored in the Hive metastore, not Unity Catalog.
   • BThe users lack the necessary permissions on the table to view its properties.
   • CThe users are querying a cached version of the table metadata.
   • DThe property was set using a different case, and SHOW TBLPROPERTIES is case-sensitive.
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A data engineer needs to check if a table `inventory.products` has a comment and also see all its table properties. They want to use a single SQL command. Which command should they use?

   • ASHOW TBLPROPERTIES inventory.products
   • BDESCRIBE EXTENDED inventory.products
   • CDESCRIBE inventory.products
   • DSHOW CREATE TABLE inventory.products
   Reveal Solution Discussion Select an answer first
6. 5application · easy

   A data analyst wants to view the comments and table properties of a table `marketing.campaigns` without writing any SQL. Which UI feature should they use?

   • AThe Jobs UI, which displays table metadata for scheduled jobs.
   • BThe Query Editor, which shows metadata in the results pane.
   • CCatalog Explorer, navigating to the table's Overview page.
   • DThe Data tab in the workspace, which lists all tables and their metadata.
   Reveal Solution Discussion Select an answer first