Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
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?
Real Exam
Community
KKeng
A
There is no way to indicate whether a table contains PII.
B
"COMMENT PII"
C
TBLPROPERTIES PII
D
COMMENT "Contains PII"
E
PII
Explanation:
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
Comments
Loading comments...