Explanation:
The COMMENT clause accepts a string describing the table, for example: CREATE TABLE france_customers COMMENT 'Contains PII' AS SELECT name FROM customers WHERE country = 'France';. TBLPROPERTIES would require valid key-value syntax such as TBLPROPERTIES ('contains_pii' = 'true').
A new table must contain customer names from France and include metadata indicating that it contains PII. Which line correctly fills the CREATE TABLE AS SELECT statement?
A
There is no way to indicate whether a table contains PII.
B
"COMMENT PII"
C
TBLPROPERTIES PII
D
COMMENT "Contains PII"
E
PII
No comments yet.