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
4 months agoLashaunda
5 months agoSamira
5 months agoElli
5 months agoFrederica
5 months agoIluminada
6 months agoLatonia
6 months agoKenia
6 months agoRoy
6 months agoVirgie
6 months agoLoise
6 months agoCristal
6 months agoKeneth
6 months agoMalika
6 months agoBrinda
6 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