Answer-first summary for fast verification
Answer: Managed tables are appropriate when Databricks should manage all aspects of the table, including data storage, ideal for ephemeral environments. External tables are suitable when the user needs to control the data location, crucial for long-term data storage and compliance.
Managed tables in Databricks are fully managed by Databricks, including data storage and lifecycle management, making them suitable for scenarios where Databricks should handle all aspects of the table, such as in ephemeral environments. External tables, on the other hand, are appropriate when the user needs to control the data location, which is crucial for long-term data storage and compliance with regulations.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Discuss the implications of using managed versus external tables in Databricks on data lifecycle management. Provide examples of scenarios where each type of table would be more appropriate.
A
Managed tables are appropriate when Databricks should manage all aspects of the table, including data storage, ideal for ephemeral environments. External tables are suitable when the user needs to control the data location, crucial for long-term data storage and compliance.
B
Both managed and external tables offer the same lifecycle management capabilities, making the choice irrelevant.
C
External tables are always preferred over managed tables for better lifecycle management and data control.
D
Managed tables cannot be used for any scenario involving data lifecycle management.
No comments yet.