nerdexam
Databricks

DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE · Question #85

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…

The correct answer is D. COMMENT "Contains PII". In a CREATE TABLE statement, the COMMENT clause adds a human-readable description to the table, making it the correct way to document that a table contains PII. The syntax is: COMMENT 'Contains PII'. Option C (TBLPROPERTIES PII) is syntactically invalid - TBLPROPERTIES requires…

Submitted by wei.xz· Apr 18, 2026Data Management

Question

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?

Options

  • AThere is no way to indicate whether a table contains PII.
  • B"COMMENT PII"
  • CTBLPROPERTIES PII
  • DCOMMENT "Contains PII"
  • EPII

How the community answered

(50 responses)
  • A
    2% (1)
  • C
    2% (1)
  • D
    92% (46)
  • E
    4% (2)

Explanation

In a CREATE TABLE statement, the COMMENT clause adds a human-readable description to the table, making it the correct way to document that a table contains PII. The syntax is: COMMENT 'Contains PII'. Option C (TBLPROPERTIES PII) is syntactically invalid - TBLPROPERTIES requires key-value pair syntax like TBLPROPERTIES ('pii' = 'true'). Options A, B, and E are either invalid syntax or false statements.

Topics

#SQL DDL#Table Properties#Metadata Management

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE Practice