Answer-first summary for fast verification
Answer: External tables are chosen when data must be stored in a specific location controlled by the user, allowing for more flexible data lifecycle management and compliance with data regulations.
External tables in Databricks are used when the data needs to be stored in a location directly controlled by the user, which is often required for compliance with data regulations. This choice allows for more flexible data lifecycle management as the user retains full control over the data storage and can manage backups, deletions, and other lifecycle aspects independently.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Given a scenario where you need to store data in a location that you control directly for compliance reasons, explain why you would choose an external table over a managed table in Databricks. Discuss the implications of this choice on data lifecycle management.
A
External tables are chosen when data must be stored in a specific location controlled by the user, allowing for more flexible data lifecycle management and compliance with data regulations.
B
Managed tables are always preferred over external tables for compliance reasons as they provide better data governance.
C
Both managed and external tables offer the same level of control over data location, making the choice irrelevant for compliance.
D
External tables cannot be used for compliance reasons as they do not support data location control.
No comments yet.