
Ultimate access to all questions.
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.