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?
The correct command to manually confirm that all three requirements have been met, including column comments, table comments, and the custom table property, is 'DESCRIBE EXTENDED dev.pii_test' as it provides a detailed description of the table including all its properties and comments.
correct A !
looks like A & C are correct.. https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-aux-show-tblproperties.html#show-tblproperties
if we want to see also columns comments then A