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

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
alinavit
7 months ago
Selected Answer: A
A is correct
upvoted 1 times
...
Stefan94
7 months, 2 weeks ago
Selected Answer: A
Correct Answer is A
upvoted 1 times
...
3fbc31b
9 months, 4 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
10 months, 2 weeks ago
also go with A
upvoted 1 times
...
31cadd7
10 months, 3 weeks ago
Selected Answer: A
it's A
upvoted 1 times
...
THC1138
11 months, 2 weeks 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
11 months, 2 weeks ago
Selected Answer: A
A - Both Data was deleted as well along with Metadata
upvoted 1 times
...
Ivan_Petrov
11 months, 4 weeks ago
Answer should be A as data was deleted table was managed
upvoted 1 times
...
jetplanes
11 months, 4 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
...
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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago