CERTIFIED-DATA-ENGINEER-PROFESSIONAL · Question #43
The data governance team has instituted a requirement that all tables containing Personal Identifiable Information (PH) must be clearly annotated. This includes adding column comments, table…
The correct answer is A. DESCRIBE EXTENDED dev.pii test. DESCRIBE EXTENDED <table> is the correct command because it returns the most comprehensive metadata for a table, including: (1) all column names and their data types, (2) column-level comments, (3) table-level comment, and (4) detailed table properties including any custom…
Question
The data governance team has instituted a requirement that all tables containing Personal Identifiable Information (PH) must be clearly annotated. This includes adding column comments, table comments, and setting the custom table property "contains_pii" = true. The following SQL DDL statement is executed to create a new table:
Which command allows manual confirmation that these three requirements have been met?
Options
- ADESCRIBE EXTENDED dev.pii test
- BDESCRIBE DETAIL dev.pii test
- CSHOW TBLPROPERTIES dev.pii test
- DDESCRIBE HISTORY dev.pii test
- ESHOW TABLES dev
How the community answered
(50 responses)- A94% (47)
- C4% (2)
- E2% (1)
Explanation
DESCRIBE EXTENDED <table> is the correct command because it returns the most comprehensive metadata for a table, including: (1) all column names and their data types, (2) column-level comments, (3) table-level comment, and (4) detailed table properties including any custom properties like 'contains_pii'. DESCRIBE DETAIL shows physical storage details (file size, partitioning, format) but not comments or custom properties. SHOW TBLPROPERTIES only shows table properties, not column or table comments. DESCRIBE HISTORY shows the transaction log history of changes to the table. SHOW TABLES only lists table names in a database. Only DESCRIBE EXTENDED provides a single view to verify all three PII annotation requirements.
Topics
Community Discussion
No community discussion yet for this question.