Answer-first summary for fast verification
Answer: An managed table will be created in the storage container mounted to /mnt/finance_eda_bucket.
The database `finance_eda_db` was created with `LOCATION '/mnt/finance_eda_bucket'`, which means any managed table created within this database will have its data stored in the mounted external storage location. The `CREATE TABLE` statement does not specify an external location, so it defaults to creating a managed table within the database's specified location. The permissions granted allow the finance group to create tables in this database. Therefore, the `tx_sales` table will be a managed table created in the storage container mounted to `/mnt/finance_eda_bucket`.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
An external object storage container is mounted at /mnt/finance_eda_bucket.
The following logic was executed to create a database for the finance team:
CREATE DATABASE finance_eda_db
LOCATION '/mnt/finance_eda_bucket';
GRANT USAGE ON DATABASE finance_eda_db TO finance;
GRANT CREATE ON DATABASE finance_eda_db TO finance;
CREATE DATABASE finance_eda_db
LOCATION '/mnt/finance_eda_bucket';
GRANT USAGE ON DATABASE finance_eda_db TO finance;
GRANT CREATE ON DATABASE finance_eda_db TO finance;
After the database was successfully created and permissions configured, a finance team member executes:
CREATE TABLE finance_eda_db.tx_sales AS
SELECT *
FROM sales
WHERE state = 'TX';
CREATE TABLE finance_eda_db.tx_sales AS
SELECT *
FROM sales
WHERE state = 'TX';
If all finance team users belong to the finance group, which statement describes how the tx_sales table will be created?
A
A logical table will persist the query plan to the Hive Metastore in the Databricks control plane.
B
An external table will be created in the storage container mounted to /mnt/finance_eda_bucket.
C
A managed table will be created in the DBFS root storage container.
D
An managed table will be created in the storage container mounted to /mnt/finance_eda_bucket.