nerdexam
DatabricksDatabricks

CERTIFIED-DATA-ENGINEER-PROFESSIONAL · Question #45

CERTIFIED-DATA-ENGINEER-PROFESSIONAL Question #45: Real Exam Question with Answer & Explanation

Sign in or unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to reveal the answer and full explanation for question #45. The question stem and answer options stay visible for context.

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.

Unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL to see the answer

You've previewed enough free CERTIFIED-DATA-ENGINEER-PROFESSIONAL questions. Unlock CERTIFIED-DATA-ENGINEER-PROFESSIONAL for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Managed Tables#Database Location#Databricks Storage#External Mounts
Full CERTIFIED-DATA-ENGINEER-PROFESSIONAL PracticeBrowse All CERTIFIED-DATA-ENGINEER-PROFESSIONAL Questions