Free Preparation Discussions
MENU
Databricks Exam Databricks Certified Data Engineer Associate Topic 5 Question 30 Discussion
Topic #: 5
A data engineer is running code in a Databricks Repo that is cloned from a central Git repository. A colleague of the data engineer informs them that changes have been made and synced to the central Git repository. The data engineer now needs to sync their Databricks Repo to get the changes from the central Git repository.
Which of the following Git operations does the data engineer need to run to accomplish this 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
Shonda
1 months agoGene
9 days agoNelida
1 months agoGearldine
1 months agoNettie
6 days agoAmie
2 months agoMariann
2 months agoAudra
9 days agoJusta
10 days agoClaudia
27 days agoCorrinne
2 months agoWerner
1 months agoJoseph
1 months agoGracia
2 months agoThomasena
2 months agoLeatha
2 months agoSue
2 months agoGilberto
3 months agoJeniffer
3 months agoEzekiel
3 months ago