Ultimate access to all questions.
Answer-first summary for fast verification
Answer: COMMENT "Contains PII"
The correct answer is D: COMMENT "Contains PII". In Databricks SQL, you can add comments to tables to document metadata including whether they contain PII. The COMMENT clause is used to add descriptive text to a table. The reference example shows: `COMMENT 'Contains PII'` as part of the CREATE TABLE statement. This is the proper way to document that a table contains personally identifiable information according to organizational policies. **Key Points:** - Option A is incorrect because there are ways to indicate PII in tables - Option B is incorrect because it has incorrect syntax (quotes in wrong place) - Option C is incorrect because TBLPROPERTIES requires key-value pairs with proper syntax - Option E is incorrect because it's not valid SQL syntax - The COMMENT clause with descriptive text is the standard approach for documenting table metadata including PII information
Author: Keng Suppaseth
No comments yet.
CREATE TABLE customersInFrance AS SELECT id, firstName, lastName, FROM customerLocations WHERE country = 'FRANCE';
A senior data engineer mentions that it is organization policy to include a table property indicating that the new table includes personally identifiable information (PII).
Which of the following lines of code fills in the above blank to 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"
E
PII