ExamTopics Logo
Mail Us[email protected]
Menu
Databricks Discussions
exam questions

Exam Certified Data Engineer Professional All Questions

View all questions & answers for the Certified Data Engineer Professional exam
Go to Exam

Exam Certified Data Engineer Professional topic 1 question 166 discussion

Actual exam question from Databricks's Certified Data Engineer Professional
Question #: 166
Topic #: 1
[All Certified Data Engineer Professional Questions]

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?

  • A. A logical table will persist the query plan to the Hive Metastore in the Databricks control plane.
  • B. An external table will be created in the storage container mounted to /mnt/finance_eda_bucket.
  • C. A managed table will be created in the DBFS root storage container.
  • D. An managed table will be created in the storage container mounted to /mnt/finance_eda_bucket.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by MDWPartners at May 29, 2024, 8:02 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Sriramiyer92
1 month, 3 weeks ago
Selected Answer: D
D. Managed tables - Since Location is not mentioned. mounted to /mnt/finance_eda_bucket - This is where our database is created as per first query and in second query we are using it to create the table further.
upvoted 1 times
...
Isio05
7 months, 3 weeks ago
Selected Answer: D
It will be created in database location, but it will be managed table (missing LOCATION keyword in CREATE TABLE).
upvoted 3 times
...
hpkr
7 months, 4 weeks ago
Selected Answer: D
D is correct
upvoted 2 times
...
Freyr
8 months, 1 week ago
Selected Answer: D
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.
upvoted 2 times
...
MDWPartners
8 months, 1 week ago
Selected Answer: D
Seems D
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago