Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Describe 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.