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