Answer-first summary for fast verification
Answer: 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 is to use the LOCATION keyword whenever a table is being created. This specifies the path to the data in cloud storage, making the table external. Option A is incorrect because using the LOCATION keyword when creating a database only sets the default location for managed tables within that database, not ensuring all tables are external. Option B is incorrect as mounting external cloud object storage is a prerequisite but does not by itself configure tables as external. Option D is incorrect because the UNMANAGED keyword is not valid syntax in Delta Lake table creation.
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 the workspace is being configured, make sure that external cloud object storage has been mounted.
C
Whenever a table is being created, make sure that the LOCATION keyword is used.
D
When tables are created, make sure that the UNMANAGED keyword is used in the CREATE TABLE statement.
No comments yet.