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?