Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Databricks Certified Data Engineer Associate Exam - Topic 5 Question 30 Discussion

Posted by Berry on Jul 11, 2024 at 12:09 AM

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?

Suggested Answer: D

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


Get Premium Databricks Certified Data Engineer Associate Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test
40 comments · newest first
GR
Gracia 10 months ago
I thought Commit was for saving changes locally, not syncing.
KA
Kathrine 11 months ago
No way, you just need to Pull, not Clone or Push.
EL
Eleni 11 months ago
Wait, isn't Merge also a valid option sometimes?
MA
Marshall 11 months ago
Totally agree, Pull is the right move here!
KA
Kati 11 months ago
You need to run a Pull to sync changes.
AS
Ashanti 12 months ago
I feel like Commit is about saving local changes, so it can't be the answer here.
KA
Kathrine 12 months ago
I'm a bit confused; I thought Merge was for combining changes, not for syncing.
NA
Natalie 12 months ago
I remember practicing a similar question, and I think Pull is the right choice since it fetches and merges changes.
AL
Alesia 1 year ago
I think we need to use the Pull operation to get the latest changes from the central repository, but I'm not entirely sure.
DI
Dianne 1 year ago
Hmm, I'm not entirely sure about this one. I know Pull is used to fetch changes from a remote repository, but could Merge also be an option here? I'll have to think about this a bit more before deciding.
RI
Rima 1 year ago
This is a classic Git scenario. The data engineer needs to pull the changes from the central repo to their local Databricks Repo. That's the most straightforward way to sync the two. I'm confident C. Pull is the right answer here.
DE
Denise 1 year ago
I'm a bit confused here. Is it really that simple? Shouldn't the data engineer also consider merging the changes or something? I'm not sure, maybe I'm overthinking this. I'll go with C. Pull for now.
NO
Novella 1 year ago
Okay, let me think this through. If the colleague has already made changes and synced them to the central repo, then the data engineer needs to pull those changes to their local repo. So I'm going to go with C. Pull.
SH
Sharita 1 year ago
Hmm, this seems straightforward. I think the answer is C. Pull would be the right operation to sync the local Databricks Repo with the changes in the central Git repository.
SA
Sabra 1 year ago
I'm a bit confused by the options here. I thought we needed to use the `renderAs` attribute, but some of these options mention `readerAs` and `contentype`. I'll have to double-check the Visualforce documentation to be sure.
SH
Shonda 1 year ago
D) Commit? More like D) Commit seppuku if the data engineer tried that. C) Pull or bust, my friends!
FE
Felicia 1 year ago
↳ replying to Shonda
D: Yeah, C) Pull is the correct option
KI
Kimi 1 year ago
↳ replying to Shonda
C: Agreed, C) Pull is the way to go
LA
Laine 1 year ago
↳ replying to Shonda
B: Definitely C) Pull
GE
Gene 1 year ago
↳ replying to Shonda
A: C) Pull
NE
Nelida 1 year ago
E) Clone? What, is the data engineer going to create a whole new repo just to get the latest changes? That's like using a sledgehammer to crack a nut.
GE
Gearldine 1 year ago
B) Push? Really? Who would push to the remote repo when they need to pull the changes? C) Pull is the only sensible option here.
AS
Ashlyn 1 year ago
↳ replying to Gearldine
C) Pull
EA
Earnestine 1 year ago
↳ replying to Gearldine
B) Push
NE
Nettie 1 year ago
↳ replying to Gearldine
A) Merge
AM
Amie 1 year ago
Hmm, I was tempted to choose A) Merge, but that's usually for resolving conflicts, not just syncing. C) Pull is the correct answer, no doubt about it.
MA
Mariann 1 year ago
I was going to say D) Commit, but then I remembered that's for saving changes, not pulling them. C) Pull is the way to go here.
AU
Audra 1 year ago
↳ replying to Mariann
Data engineer: Got it, I'll make sure to do that right away. Thanks for the reminder!
JU
Justa 1 year ago
↳ replying to Mariann
Colleague: That's correct, C) Pull is the operation you need to perform to get the changes from the central Git repository.
CL
Claudia 1 year ago
↳ replying to Mariann
Data engineer: Thanks for letting me know about the changes. I'll go ahead and run C) Pull to sync my Databricks Repo.
CO
Corrinne 2 years ago
Well, duh, the answer is C) Pull. That's the obvious choice to sync the local repo with the remote one.
WE
Werner 1 year ago
↳ replying to Corrinne
User 2: Yeah, I need to run a Pull operation to get the changes.
JO
Joseph 1 year ago
↳ replying to Corrinne
Thomasena: I think it's C) Pull. That's how you sync the local repo with the remote one.
GR
Gracia 1 year ago
↳ replying to Corrinne
User 1: Hey, have you synced your Databricks Repo with the changes from Git?
TH
Thomasena 1 year ago
↳ replying to Corrinne
Leatha: You need to run a Git operation to get the changes. Do you know which one?
LE
Leatha 1 year ago
↳ replying to Corrinne
User 2: No, I haven't. What do I need to do?
SU
Sue 1 year ago
↳ replying to Corrinne
User 1: Hey, have you synced your Databricks Repo with the central Git repository?
GI
Gilberto 2 years ago
Yes, Pull is the correct operation to get the changes from the central Git repository to the Databricks Repo.
JE
Jeniffer 2 years ago
I agree with Ezekiel, Pull operation will sync the changes from the central Git repository.
EZ
Ezekiel 2 years ago
I think the data engineer needs to run the Pull operation.
0/2000 characters

Save Cancel