
Databricks Certified Data Engineer - Professional
Get started today
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)
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)
Exam-Like