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?
To complete the task of creating a new table while indicating that it contains personally identifiable information (PII), you should use the COMMENT keyword. The correct syntax is COMMENT "Contains PII". This will ensure that anyone who describes the table will see the comment indicating that the table contains PII.
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';
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.
syntax of C is wrong.
Exactly. The correct syntax for table properties is: TBLPROPERTIES ('foo'='bar');
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.
answer C : CREATE TABLE new_table AS SELECT customer_name FROM original_table WHERE country = 'France' TBLPROPERTIES ('PII'='true');
Option D
D https://learn.microsoft.com/en-us/azure/databricks/sql/language-manual/sql-ref-syntax-ddl-create-table-using
D. COMMENT "Contains PII"
D is correct
D is correct
correct :D
Correct answer is D
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.
D is correct
D is correct
The correct answer is D. There is no syntax for TBLPROPERTIES PII.