Free Preparation Discussions
MENU
Databricks Certified Data Engineer Associate Exam - Topic 1 Question 28 Discussion
Topic #: 1
A data engineer wants to create a new table containing the names of customers who live in France.
They have written the following command:
CREATE TABLE customersInFrance
_____ AS
SELECT id,
firstName,
lastName
FROM customerLocations
WHERE country = 'FRANCE';
A senior data engineer mentions that it is organization policy to include a table property indicating that the new table includes personally identifiable information (Pll).
Which line of code fills in the above blank to successfully complete the task?
To include a property indicating that a table contains personally identifiable information (PII), the TBLPROPERTIES keyword 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';
The TBLPROPERTIES ('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.
Reference: Databricks documentation on Delta Lake: Delta Lake on Databricks
Kerrie
9 months agoLashaunda
9 months agoSamira
9 months agoElli
10 months agoFrederica
10 months agoIluminada
10 months agoLatonia
10 months agoKenia
10 months agoRoy
11 months agoVirgie
11 months agoLoise
11 months agoCristal
11 months agoKeneth
11 months agoMalika
11 months agoBrinda
11 months agoVeda
2 years agoTy
2 years agoDannette
2 years agoDeja
2 years agoMargarett
2 years agoInes
2 years agoHobert
2 years agoKenia
2 years agoDaniela
2 years agoNicolette
2 years agoChandra
2 years ago