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

Exam Certified Data Analyst Associate All Questions

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

Exam Certified Data Analyst Associate topic 1 question 11 discussion

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

A data analyst is attempting to drop a table my_table. The analyst wants to delete all table metadata and data.
They run the following command:
DROP TABLE IF EXISTS my_table;
While the object no longer appears when they run SHOW TABLES, the data files still exist.
Which of the following describes why the data files still exist and the metadata files were deleted?

  • A. The table's data was larger than 10 GB
  • B. The table did not have a location
  • C. The table was external
  • D. The table's data was smaller than 10 GB
  • E. The table was managed
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by RasipalayamRDK at March 4, 2024, 9:25 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
31cadd7
2 months, 3 weeks ago
Selected Answer: C
If the table was external, the DROP TABLE command only removes the metadata associated with the table, not the actual data files. External tables in Databricks are stored outside the default location and dropping them does not delete the data files.
upvoted 1 times
...
markiz
8 months ago
Answer C is correct, only table metada was removed and the underling files are still there in the storage
upvoted 2 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