Answer-first summary for fast verification
Answer: Using an external table when data must be stored in a specific, user-controlled location, enhancing data governance and accessibility by allowing direct management of data files.
An external table is advantageous when the data needs to be stored in a location that the user controls directly, such as for compliance reasons or to integrate with existing data infrastructure. This choice enhances data governance by allowing the user to manage data files directly and improves accessibility by ensuring data is stored in a known, accessible location.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Discuss a scenario where the use of an external table in Databricks would be advantageous over a managed table. Explain how this choice impacts data governance and accessibility.
A
Using an external table when data must be stored in a specific, user-controlled location, enhancing data governance and accessibility by allowing direct management of data files.
B
External tables are always less efficient than managed tables and should not be used for any scenario.
C
Both managed and external tables provide the same level of data governance and accessibility, making the choice irrelevant.
D
External tables are only used for non-critical data that does not require strict governance or accessibility.
No comments yet.