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

Questions 26–30

1. 26foundation · easy

   Which SQL statement adds a description to a schema (database) in Databricks?

   • AUPDATE SCHEMA schema_name SET COMMENT = 'description'
   • BCREATE SCHEMA schema_name WITH COMMENT 'description'
   • CCOMMENT ON SCHEMA schema_name IS 'description'
   • DALTER SCHEMA schema_name SET DESCRIPTION 'description'
   Reveal Solution Discussion Select an answer first
2. 27foundation · easy

   What is a valid use case for setting TBLPROPERTIES on a table?

   • ATo grant permissions to users
   • BTo change the table's file format
   • CTo define the table's physical storage location
   • DTo store custom metadata like a data owner's email or a business classification tag
   Reveal Solution Discussion Select an answer first
4. 28application · medium

   A data engineer wants to add a comment to a column `customer_id` in table `sales.customers` and also set a table property `data_classification` to 'PII'. Which SQL statement correctly performs both actions?

   • AALTER TABLE sales.customers CHANGE COLUMN customer_id COMMENT 'Unique customer identifier'; ALTER TABLE sales.customers SET TBLPROPERTIES ('data_classification' = 'PII');
   • BCOMMENT ON COLUMN customer_id IS 'Unique customer identifier'; ALTER TABLE sales.customers SET TBLPROPERTIES data_classification = 'PII';
   • CCOMMENT ON COLUMN sales.customers.customer_id IS 'Unique customer identifier'; ALTER TABLE sales.customers SET TBLPROPERTIES ('data_classification' = 'PII');
   • DCOMMENT ON TABLE sales.customers.customer_id IS 'Unique customer identifier'; ALTER TABLE sales.customers SET TBLPROPERTIES ('data_classification' = 'PII');
   Reveal Solution Discussion Select an answer first
5. 29foundation · easy

   Which of the following can you view in Catalog Explorer for a table?

   • AThe job's run logs
   • BThe cluster's autoscaling metrics
   • CThe table's schema, comments, and properties
   • DThe notebook's execution history
   Reveal Solution Discussion Select an answer first
6. 30expert · medium

   A data architect needs to document lineage for a table that is built by a complex pipeline with multiple upstream sources. They want the lineage to be discoverable by data consumers. Which approach best captures this in Unity Catalog?

   • AUse a notebook to document lineage and attach it to the table as a property.
   • BCreate a separate lineage table that maps the table to its upstream sources.
   • CRely solely on Unity Catalog's automatic lineage tracking from the pipeline.
   • DAdd a detailed table comment describing the pipeline and upstream sources, and use table properties for key metadata like owner.
   Reveal Solution Discussion Select an answer first