
Answer-first summary for fast verification
Answer: COMMENT "Contains PII"
The correct answer is D. The COMMENT keyword is used to add a comment to a table. This comment can be viewed when the table is described using the DESC command. Though TBLPROPERTIES can also add metadata, it is not visible when describing the table, making COMMENT "Contains PII" the appropriate choice according to the given requirement.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A data engineer is tasked with creating a new table that contains the names of customers residing in France. To accomplish this, they have written a specific command. However, a senior data engineer advises that it is organizational policy to include a table property specifying that the new table contains personally identifiable information (PII). Which of the following lines of code should be added to the command in order to adhere to organizational policy and successfully complete the task?
A
There is no way to indicate whether a table contains PII.
B
"COMMENT PII"
C
TBLPROPERTIES PII
D
COMMENT "Contains PII"