An external object storage container has been mounted to the location /mnt/finance_eda_bucket.
The following logic was executed to create a database for the finance team:
After the database was successfully created and permissions configured, a member of the finance team runs the following code:
If all users on the finance team are members of the finance group, which statement describes how the tx_sales table will be created?
The table will be created as a managed table in the storage container mounted to /mnt/finance_eda_bucket. In Databricks, the default behavior when creating a table without specifying an external location is to create a managed table, which means that Databricks will manage both the data and the metadata for this table. Since the database 'finance_eda_db' has a specified location '/mnt/finance_eda_bucket', any managed tables created in this database will have their data stored in this location.
It will be created in database location, but it will be managed table (missing LOCATION keyword in CREATE TABLE).
D is correct
Correct Answer: D The table is still managed by Spark SQL in terms of metadata, but the data files are stored in the specified path due to the database’s location setting. Given the inherited location from the database, if the CREATE TABLE statement had explicitly used USING EXTERNAL or specified a LOCATION, it would definitely be an external table. However, since it inherits the database's location without these specifications, it creates a managed table.
Seems D