Which Lakehouse table type is a managed table?

Prepare for the DP-600 Fabric Analytics Engineer Exam. Test your knowledge with multiple choice questions and detailed explanations. Gear up for your success now!

Multiple Choice

Which Lakehouse table type is a managed table?

Explanation:
In Lakehouse setups, a managed table means the platform owns both the metadata and the data, storing the data in the system’s default location and handling its lifecycle. Because the system manages where the data lives, dropping a managed table typically also deletes the underlying data. A Delta table can be managed or external depending on how it’s created. If you don’t specify a storage location, it’s treated as managed. If you point to a specific path in the data lake, it becomes external, and dropping the table only removes the metadata, leaving the data behind. So the best answer is the one described as a managed table, since it aligns with the idea of the platform managing the data and its lifecycle.

In Lakehouse setups, a managed table means the platform owns both the metadata and the data, storing the data in the system’s default location and handling its lifecycle. Because the system manages where the data lives, dropping a managed table typically also deletes the underlying data.

A Delta table can be managed or external depending on how it’s created. If you don’t specify a storage location, it’s treated as managed. If you point to a specific path in the data lake, it becomes external, and dropping the table only removes the metadata, leaving the data behind.

So the best answer is the one described as a managed table, since it aligns with the idea of the platform managing the data and its lifecycle.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy