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.

Simulated

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.

89.4%

Managed tables are always preferred over external tables for compliance reasons as they provide better data governance.

6.0%

Both managed and external tables offer the same level of control over data location, making the choice irrelevant for compliance.

1.7%

External tables cannot be used for compliance reasons as they do not support data location control.

3.0%

Databricks Certified Data Engineer - Associate

Get started today

Comments

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.