Answer-first summary for fast verification
Answer: Whenever a database is being created, make sure that the LOCATION keyword is used, Whenever a table is being created, make sure that the LOCATION keyword is used.
To ensure all tables in the Lakehouse are configured as external Delta Lake tables, the correct approach involves specifying a location for the data storage that is external to Databricks. This can be achieved by using the `LOCATION` keyword either when creating a database (option A) or when creating a table (option C). The `EXTERNAL` keyword (option D) is not applicable in Databricks for Delta Lake tables. Options B and E do not directly address the requirement of configuring tables as external. Therefore, the correct answers are A and C, as both methods ensure the data is stored in an external location, meeting the data architect's mandate.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
To comply with the data architect's mandate that all tables in the Lakehouse must be configured as external Delta Lake tables, which approach should be implemented?
A
Whenever a database is being created, make sure that the LOCATION keyword is used
B
When configuring an external data warehouse for all table storage, leverage Databricks for all ELT.
C
Whenever a table is being created, make sure that the LOCATION keyword is used.
D
When tables are created, make sure that the EXTERNAL keyword is used in the CREATE TABLE statement.
E
When the workspace is being configured, make sure that external cloud object storage has been mounted.
No comments yet.