Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam Certified Data Engineer Associate All Questions

View all questions & answers for the Certified Data Engineer Associate exam

Exam Certified Data Engineer Associate topic 1 question 7 discussion

Actual exam question from Databricks's Certified Data Engineer Associate
Question #: 7
Topic #: 1
[All Certified Data Engineer Associate Questions]

A data engineer has realized that they made a mistake when making a daily update to a table. They need to use Delta time travel to restore the table to a version that is 3 days old. However, when the data engineer attempts to time travel to the older version, they are unable to restore the data because the data files have been deleted.
Which of the following explains why the data files are no longer present?

  • A. The VACUUM command was run on the table
  • B. The TIME TRAVEL command was run on the table
  • C. The DELETE HISTORY command was run on the table
  • D. The OPTIMIZE command was nun on the table
  • E. The HISTORY command was run on the table
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Feroz_Raza
Highly Voted 1 year ago
Selected Answer: A
There is no DELETE HISTORY command in Databricks VACCUM command can remove history and we can also specify the retention period with VACCUM Command. Default Retention period is 7 days. To allow changing the default retention period you can rum the following command ALTER TABLE your_table SET TBLPROPERTIES ('delta.retentionDurationCheck.enabled' = 'true');
upvoted 11 times
...
mateo_vansweevelt
Most Recent 2 months ago
Selected Answer: A
Its vacuum
upvoted 1 times
...
vctrhugo
2 months ago
Selected Answer: A
A. The VACUUM command was run on the table The VACUUM command in Delta Lake is used to clean up and remove unnecessary data files that are no longer needed for time travel or query purposes. When you run VACUUM with certain retention settings, it can delete older data files, which might include versions of data that are older than the specified retention period. If the data engineer is unable to restore the table to a version that is 3 days old because the data files have been deleted, it's likely because the VACUUM command was run on the table, removing the older data files as part of data cleanup.
upvoted 3 times
...
9d4d68a
3 months ago
Selected Answer: A A. The VACUUM command was run on the table The VACUUM command in Delta Lake is used to clean up old data files that are no longer needed, which could include files that are older than a certain retention period. If the data engineer is unable to restore data to a version that is 3 days old, it is likely because the VACUUM command has deleted the old data files beyond the retention period.
upvoted 1 times
...
80370eb
3 months, 2 weeks ago
Selected Answer: A
vacuum command is used to remove the history of the table.
upvoted 1 times
...
ranjan24
4 months, 1 week ago
A is the correct answer
upvoted 1 times
...
3fbc31b
4 months, 2 weeks ago
Selected Answer: A
There is no DELETE HISTORY command anywhere in Databricks. The VACUUM command removes files older than the value that is set. The default value is 7 days.
upvoted 1 times
...
potaryxkug
5 months, 1 week ago
A is the good answer
upvoted 1 times
...
mascarenhaslucas
5 months, 2 weeks ago
The answer is A!
upvoted 1 times
...
bettermakeme
8 months ago
Answer is A. Just finished exam-got 100% [Databricks Associate Exam Practice Exams] All questions came from Databricks Certified Data Engineer Associate https://www.udemy.com/share/10aEFa3@9M_uT6vrKbnl68tOK96kfy-YWitjwzLTlVCrzPs-0hGUu8fyX8V4Tn_x_y65bwLm/
upvoted 1 times
...
Itmma
8 months, 1 week ago
Selected Answer: A
A is correct
upvoted 1 times
...
SerGrey
11 months ago
Selected Answer: A
A i correct
upvoted 1 times
...
Huroye
1 year ago
I agree with the first post. A is the correct answer. There is no such thing as a Delete History Command
upvoted 2 times
...
awofalus
1 year ago
Selected Answer: A
right answer is A
upvoted 1 times
...
vivekrrr
1 year ago
i think B is the answer, plz let me know if not correct
upvoted 1 times
...
vivekrrr
1 year ago
but vaccum allows to vaccum anything that's older than 7 days right
upvoted 1 times
...
VijayKula
1 year, 1 month ago
Selected Answer: A
Answer is A Vaccum
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...