nerdexam
Databricks

CERTIFIED-DATA-ENGINEER-PROFESSIONAL · Question #45

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 succes

The correct answer is D. An managed table will be created in the storage container mounted to /mnt/finance_eda_bucket.. When a database (schema) is created with a custom LOCATION clause pointing to an external mount (e.g., /mnt/finance_eda_bucket), any table created inside that database without an explicit LOCATION clause is treated as a managed table by the Hive Metastore, but its data files are

Data Storage and Management on Databricks

Question

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?

Options

  • AA logical table will persist the query plan to the Hive Metastore in the Databricks control plane.
  • BAn external table will be created in the storage container mounted to /mnt/finance eda bucket.
  • CA logical table will persist the physical plan to the Hive Metastore in the Databricks control plane.
  • DAn managed table will be created in the storage container mounted to /mnt/finance_eda_bucket.
  • EA managed table will be created in the DBFS root storage container.

How the community answered

(39 responses)
  • A
    5% (2)
  • B
    5% (2)
  • C
    3% (1)
  • D
    77% (30)
  • E
    10% (4)

Explanation

When a database (schema) is created with a custom LOCATION clause pointing to an external mount (e.g., /mnt/finance_eda_bucket), any table created inside that database without an explicit LOCATION clause is treated as a managed table by the Hive Metastore, but its data files are physically written to the database's custom location - in this case the mounted external storage container. This makes it a managed table (lifecycle controlled by Databricks/Hive Metastore) stored in the external bucket, not in the DBFS root. It is not an external table because no separate LOCATION was specified at the table level. It is not stored in DBFS root because the database overrides the default storage path.

Topics

#Managed Tables#Database Location#Databricks Storage#External Mounts

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full CERTIFIED-DATA-ENGINEER-PROFESSIONAL Practice