Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Databricks Discussions
exam questions

Exam Certified Data Engineer Associate All Questions

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

Exam Certified Data Engineer Associate topic 1 question 107 discussion

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

A data engineer is attempting to drop a Spark SQL table my_table and runs the following command:

DROP TABLE IF EXISTS my_table;

After running this command, the engineer notices that the data files and metadata files have been deleted from the file system.

What is the reason behind the deletion of all these files?

  • A. The table was managed
  • B. The table's data was smaller than 10 GB
  • C. The table did not have a location
  • D. The table was external
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by jetplanes at May 9, 2024, 6:19 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
alinavit
1 month, 3 weeks ago
Selected Answer: A
A is correct
upvoted 1 times
...
Stefan94
2 months ago
Selected Answer: A
Correct Answer is A
upvoted 1 times
...
3fbc31b
4 months, 2 weeks ago
Selected Answer: A
The correct answer is A. BOTH data and metadata were deleted meaning the table was managed. If the metadata was gone, but the actual data files themselves were still there then it would be an external table.
upvoted 2 times
...
yolandi
5 months ago
also go with A
upvoted 1 times
...
31cadd7
5 months, 1 week ago
Selected Answer: A
it's A
upvoted 1 times
...
THC1138
6 months ago
Selected Answer: A
For D to be correct, the metadata would have been deleted, but the data would still exist. The answer is A
upvoted 1 times
...
PreranaC
6 months ago
Selected Answer: A
A - Both Data was deleted as well along with Metadata
upvoted 1 times
...
Ivan_Petrov
6 months, 2 weeks ago
Answer should be A as data was deleted table was managed
upvoted 1 times
...
jetplanes
6 months, 2 weeks ago
Selected Answer: A
The answer should be A --> the table was MANAGED. If the metadata and the underlined files have been deleted, then this is a MANAGED table and not an external table.
upvoted 3 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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