Exam Certified Data Engineer Associate topic 1 question 14 discussion

The correct answer is D. COMMENT "Contains PII". Context matters. Yes, you can use Table Property to add additional metadata. But you cannot view that property when you describe the table. With the Comment "this is ..." anyone who describe the table <DESC <table name> will see the comment.

D 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';

The correct answer is D. There is no syntax for TBLPROPERTIES PII.

D is correct

D is correct

https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-ddl-create-table-using.html COMMENT column_comment A string literal to describe the column.

answer C : CREATE TABLE new_table AS SELECT customer_name FROM original_table WHERE country = 'France' TBLPROPERTIES ('PII'='true');

Correct answer is D

correct :D

D is correct

D is correct

D. COMMENT "Contains PII"

D The COMMENT keyword is used to add a comment to a table. The comment can be used to provide additional information about the table, such as its purpose or the data that it contains. In this case, the data engineer wants to add a comment to the customersInFrance table indicating that the table contains PII. The following line of code will do this: Code snippet COMMENT "Contains PII" Use code with caution. Learn more This will add the comment "Contains PII" to the customersInFrance table. The other options are not valid ways to indicate that a table contains PII. The TBLPROPERTIES keyword is used to set the table properties, but there is no property for indicating whether a table contains PII. The PII keyword is not a valid keyword in SQL. Therefore, the only valid way to indicate that a table contains PII is to use the COMMENT keyword.

syntax of C is wrong.

Correct answer should be C asommand creates a new table called "customersInFrance" with the properties of Personally Identifiable Information (PII) and selects the columns ID, FIRSTNAME, LASTNAME, ADDRESS, and PHONE_NUMBER from the existing "customers" table where the country is France.

D https://learn.microsoft.com/en-us/azure/databricks/sql/language-manual/sql-ref-syntax-ddl-create-table-using

Option D