
Answer-first summary for fast verification
Answer: `COMMENT "Contains PII"`
Adding `COMMENT "Contains PII"` to the table creation command is a straightforward method to annotate the table with a note indicating it contains personally identifiable information (PII). This approach ensures that anyone reviewing the table's definition is immediately aware of the sensitive nature of its data. It aligns with data governance and privacy practices by making the PII designation visible in the table schema, serving as a clear, albeit informal, mechanism for signaling the presence of sensitive information.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A data engineer is creating a new table to store the names of customers from the USA. The initial command is: CREATE TABLE customersInUSA________ AS SELECT id, firstName, lastName FROM Locations WHERE country = 'USA';. According to company guidelines, any new table storing personally identifiable information (PII) must be clearly marked with a specific table property. Which code snippet should be inserted to meet this requirement?
A
TBLPROPERTIES ('PII'='true')
B
COMMENT 'PII'
C
PII
D
COMMENT "Contains PII"
E
Marking a table as containing PII is not supported.
No comments yet.