CERTIFIED-DATA-ENGINEER-PROFESSIONAL Question #43: Real Exam Question with Answer & Explanation

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

Explanation

This is the correct answer because it allows manual confirmation that these three requirements have been met. The requirements are that all tables containing Personal Identifiable Information (PII) must be clearly annotated, which includes adding column comments, table comments, and setting the custom table property "contains_pii" = true. The DESCRIBE EXTENDED command is used to display detailed information about a table, such as its schema, location, properties, and comments. By using this command on the dev.pii_test table, one can verify that the table has been created with the correct column comments, table comment, and custom table property as specified in the SQL DDL statement.

No community discussion yet for this question.