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

Answer: D

Explanation:

Ref: https://www.databricks.com/discover/pages/data-quality-management

CREATE TABLE my_table (id INT COMMENT ‘Unique Identification Number’, name STRING COMMENT ‘PII’, age INT COMMENT ‘PII’) TBLPROPERTIES (‘contains_pii’=True) COMMENT ‘Contains PII’;