Databricks Certified Data Engineer - Professional
Get started today
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;
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';
If all finance team users belong to the finance group, which statement describes how the tx_sales table will be created?
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;
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';
If all finance team users belong to the finance group, which statement describes how the tx_sales table will be created?
Explanation:
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.