If you drop a managed Delta table whose data resides in a folder, what happens to the table and data?

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards
From $25.99Unlock all

Prepare for the Fabric Analytics Engineer Associate Test with comprehensive materials. Explore flashcards, multiple choice questions, and detailed explanations. Get ready for your success!

Multiple Choice

If you drop a managed Delta table whose data resides in a folder, what happens to the table and data?

Explanation:
Dropping a managed Delta table removes both the table’s metadata and its data. In a managed table, the system controls the table’s storage location and the metastore entry. When you drop the table, the metastore entry is deleted and the entire directory that holds the table data (including the Delta transaction log and all data files) is removed. This is different from external tables, where dropping only removes the metadata and leaves the underlying data intact. So both the metadata and the data files disappear.

Dropping a managed Delta table removes both the table’s metadata and its data. In a managed table, the system controls the table’s storage location and the metastore entry. When you drop the table, the metastore entry is deleted and the entire directory that holds the table data (including the Delta transaction log and all data files) is removed. This is different from external tables, where dropping only removes the metadata and leaves the underlying data intact. So both the metadata and the data files disappear.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy