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

Exam Certified Data Engineer Professional All Questions

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

Exam Certified Data Engineer Professional topic 1 question 122 discussion

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

A Delta Lake table was created with the below query:



Consider the following query:


DROP TABLE prod.sales_by_store -

If this statement is executed by a workspace admin, which result will occur?

  • A. Data will be marked as deleted but still recoverable with Time Travel.
  • B. The table will be removed from the catalog but the data will remain in storage.
  • C. The table will be removed from the catalog and the data will be deleted.
  • D. An error will occur because Delta Lake prevents the deletion of production data.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
robodog
3 months ago
Selected Answer: C
no location keyword, so its a managed table
upvoted 1 times
...
Isio05
5 months, 1 week ago
Selected Answer: C
It's managed table, so data will be also removed
upvoted 3 times
...
hpkr
5 months, 2 weeks ago
Selected Answer: C
C is correct
upvoted 2 times
...
hpkr
5 months, 2 weeks ago
Selected Answer: C
Option C
upvoted 1 times
...
imatheushenrique
5 months, 3 weeks ago
C because its a managed table
upvoted 1 times
...
Freyr
5 months, 3 weeks ago
Selected Answer: C
Correct Answer: C No location provided in the table. So, it is a managed table. This will result in deleting the table meta data as well as table data.
upvoted 1 times
...
MDWPartners
5 months, 4 weeks ago
Selected Answer: C
Seems C, it's a managed table
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 ...