Free Preparation Discussions
MENU
Databricks Certified Data Engineer Associate Exam - 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
Gracia
3 months agoKathrine
3 months agoEleni
4 months agoMarshall
4 months agoKati
4 months agoAshanti
4 months agoKathrine
5 months agoNatalie
5 months agoAlesia
5 months agoDianne
5 months agoRima
5 months agoDenise
5 months agoNovella
5 months agoSharita
5 months agoSabra
5 months agoShonda
10 months agoFelicia
8 months agoKimi
8 months agoLaine
8 months agoGene
9 months agoNelida
10 months agoGearldine
10 months agoAshlyn
8 months agoEarnestine
8 months agoNettie
9 months agoAmie
10 months agoMariann
10 months agoAudra
9 months agoJusta
9 months agoClaudia
9 months agoCorrinne
11 months agoWerner
10 months agoJoseph
10 months agoGracia
10 months agoThomasena
10 months agoLeatha
10 months agoSue
10 months agoGilberto
11 months agoJeniffer
11 months agoEzekiel
11 months ago