Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Databricks Exam Databricks Certified Data Engineer Professional Topic 1 Question 37 Discussion

Actual exam question for Databricks's Databricks Certified Data Engineer Professional exam
Question #: 37
Topic #: 1
[All Databricks 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?

Show Suggested Answer Hide Answer

Contribute your Thoughts:

Beckie
2 days ago
I remember practicing a similar question where we discussed managed vs external tables, and I feel like this one is leaning towards external too.
upvoted 0 times
...
Sherita
8 days ago
I think the answer might be B, since the table is created in the external storage container. But I'm not entirely sure.
upvoted 0 times
...
Vi
13 days ago
The question mentions that all users on the finance team are members of the finance group, so I think that's an important detail to consider when determining how the table will be created. Option B seems most likely, but I'll double-check my understanding.
upvoted 0 times
...
Carin
19 days ago
Hmm, I'm a bit unsure about the difference between a logical table and a managed table in this context. I'll need to review those Databricks table types again before selecting an answer.
upvoted 0 times
...
Tarra
24 days ago
Based on the code provided, it looks like they are creating an external table in the mounted storage container. I'm pretty confident that option B is the correct answer.
upvoted 0 times
...
Alfred
29 days ago
Okay, let me think this through step-by-step. The key information is that the finance team has an external storage container mounted at /mnt/finance_eda_bucket, and they are creating a database and table using that location.
upvoted 0 times
...
Deandrea
1 month ago
This question seems straightforward, but I want to make sure I understand the details correctly before answering.
upvoted 0 times
...
Elly
3 months ago
That could be a possibility too, as long as the table is created in the mounted storage container.
upvoted 0 times
...
Tanesha
3 months ago
I'm not sure, but I think it might be D) An managed table will be created in the storage container mounted to /mnt/finance eda bucket.
upvoted 0 times
...
Nilsa
3 months ago
I agree with Elly, because the external object storage container is mounted to that location.
upvoted 0 times
...
Lorita
4 months ago
Option D seems like the most logical choice here. A managed table will be created in the storage container mounted to /mnt/finance eda bucket. It makes sense to use a managed table since the location is specified.
upvoted 0 times
Otis
3 months ago
Yes, creating a managed table in the specified storage container is the way to go. Option D is the best choice here.
upvoted 0 times
...
Man
3 months ago
I agree, option D does seem like the most logical choice. It makes sense to use a managed table in this scenario.
upvoted 0 times
...
...
Cristy
4 months ago
Haha, I bet the finance team is really excited about this new database. I wonder if they'll use it to track all their 'creative accounting' strategies.
upvoted 0 times
...
Adrianna
4 months ago
I think the answer is C. A logical table will persist the physical plan to the Hive Metastore in the Databricks control plane. The code doesn't mention creating a managed table, so it must be a logical table.
upvoted 0 times
...
Cherrie
4 months ago
The correct answer is B. An external table will be created in the storage container mounted to /mnt/finance eda bucket. The code specifies the location of the table, which means it will be an external table.
upvoted 0 times
Ivette
3 months ago
That makes sense. The code clearly indicates the location for the table, so it must be an external table.
upvoted 0 times
...
Kaycee
3 months ago
I think the answer is B. An external table will be created in the storage container mounted to /mnt/finance eda bucket.
upvoted 0 times
...
...
Elly
4 months ago
I think the answer is B) An external table will be created in the storage container mounted to /mnt/finance eda bucket.
upvoted 0 times
...

Save Cancel