
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.