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 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

Suggested Answer: A 🗳️

by jetplanes at May 9, 2024, 6:19 p.m.

Comments

Submit Cancel

alinavit

9 months, 1 week ago

Selected Answer: A

A is correct

upvoted 1 times

...

Stefan94

9 months, 2 weeks ago

Selected Answer: A

Correct Answer is A

upvoted 1 times

...

3fbc31b

12 months 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

1 year ago

also go with A

upvoted 1 times

...

31cadd7

1 year ago

Selected Answer: A

it's A

upvoted 1 times

...

THC1138

1 year, 1 month 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

1 year, 1 month ago

Selected Answer: A

A - Both Data was deleted as well along with Metadata

upvoted 1 times

...

Ivan_Petrov

1 year, 1 month ago

Answer should be A as data was deleted table was managed

upvoted 1 times

...

jetplanes

1 year, 1 month 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

...