Explanation:
To create an external (unmanaged) table, you must explicitly provide a storage path (e.g., S3, ADLS, or GCS URI) via the LOCATION clause in SQL or the .option("path", ...) method in the DataFrame API.
UNMANAGED keyword in Spark SQL; the EXTERNAL keyword or the use of LOCATION defines this behavior.LOCATION at the database level only changes the default storage path for managed tables; it does not force tables to be external.Ultimate access to all questions.
A data architect has established a policy requiring all tables in the Lakehouse to be configured as external (unmanaged) Delta Lake tables. Which of the following approaches ensures compliance with this requirement?
A
Include the UNMANAGED keyword in the CREATE TABLE statement.
B
Specify the full file path (using the LOCATION clause) along with the USING DELTA clause when creating the table.
C
Use the LOCATION keyword when creating a database to define the default storage path.
D
Ensure that external cloud object storage is mounted when configuring the workspace environment.
No comments yet.