Which of the following lines of code fills in the above blank to successfully complete the task?

A data engineer wants to create a new table containing the names of customers that live in France.

They have written the following command:

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

View Answer

Answer: D

Explanation:

In Databricks, when creating a table, you can add a comment to columns or the entire table to provide more information about the data it contains. In this case, since it’s organization policy to indicate that the new table includes personally identifiable information (PII), option D is correct. The line of code would be added after defining the table structure and before closing with a semicolon.

Reference: Data Engineer Associate Exam Guide, CREATE TABLE USING (Databricks SQL)