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

Questions 6–10

1. 6foundation · easy

   Which SQL command adds a descriptive comment to a column in an existing table?

   • AALTER TABLE table_name MODIFY COLUMN column_name COMMENT 'description'
   • BUPDATE TABLE table_name SET COMMENT = 'description' WHERE COLUMN = 'column_name'
   • CALTER TABLE table_name ADD COLUMN column_name COMMENT 'description'
   • DCOMMENT ON COLUMN table_name.column_name IS 'description'
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   Which command displays the custom properties set on a table?

   • ASHOW TBLPROPERTIES table_name
   • BSELECT * FROM table_name
   • CDESCRIBE TABLE table_name
   • DSHOW COLUMNS table_name
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   Which command shows detailed metadata about a table, including its properties and storage information?

   • ADESCRIBE EXTENDED table_name
   • BSHOW TABLES
   • CSHOW SCHEMAS
   • DSELECT * FROM table_name
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   Which SQL clause is used to set custom key-value metadata on a table?

   • ASET TBLPROPERTIES
   • BMODIFY TBLPROPERTIES
   • CADD TABLEPROPERTY
   • DUPDATE TBLPROPERTIES
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A data governance team wants to add descriptions to all schemas in a catalog to improve discoverability. They have many schemas and want to do it efficiently. Which approach is most efficient?

   • ACreate a notebook that uses the Unity Catalog API to update descriptions.
   • BUse the Databricks CLI to update schema descriptions one by one.
   • CManually edit each schema in Catalog Explorer.
   • DUse a SQL script that runs COMMENT ON SCHEMA for each schema.
   Reveal Solution Discussion Select an answer first