
Ultimate access to all questions.
Which SQL command can be used to manually verify that all three PII annotation requirements (column comments, table comments, and the 'contains_pii' table property set to true) have been properly implemented for the dev.pii_test table?
CREATE TABLE dev.pii_test
(id INT, name STRING COMMENT "PII")
COMMENT "Contains PII"
TBLPROPERTIES ('contains_pii' = true)
CREATE TABLE dev.pii_test
(id INT, name STRING COMMENT "PII")
COMMENT "Contains PII"
TBLPROPERTIES ('contains_pii' = true)
A
DESCRIBE EXTENDED dev.pii_test_
B
DESCRIBE DETAIL dev.pii_test_
C
SHOW TBLPROPERTIES dev.pii_test_
D
DESCRIBE HISTORY dev.pii_test_
E
SHOW TABLES dev