A data engineer wants to create a new table containing the names of customers who...

To include a property indicating that a table contains personally identifiable information (PII), theTBLPROPERTIESkeyword is used in SQL to add metadata to a table. The correct syntax to define a table property for PII is as follows:

CREATE TABLE customersInFrance

USING DELTA

TBLPROPERTIES ('PII' = 'true')

AS

SELECT id,

firstName,

lastName

FROM customerLocations

WHERE country = 'FRANCE';

TheTBLPROPERTIES ('PII' = 'true')line correctly sets a table property that tags the table as containing personally identifiable information. This is in accordance with organizational policies for handling sensitive information.