MENU
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?
Suggested Answer: D
Get Premium Databricks Certified Data Engineer Professional Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
26 comments · newest first
IV
Ivette
10 months ago
I’m surprised this is how it works! I thought it would be different.
SH
Shaniqua
10 months ago
No way, it's definitely not a managed table.
ME
Melvin
10 months ago
Wait, isn't it possible for a managed table to be created too?
DE
Deandrea
10 months ago
I think an external table will be created in the mounted storage.
GE
Genevieve
10 months ago
Totally agree, option B makes the most sense!
PA
Paris
11 months ago
I believe it's definitely not E, since the DBFS root isn't mentioned in the setup. B seems like the most plausible option.
FE
Felix
11 months ago
I’m a bit confused about the difference between logical and managed tables here. I thought logical tables don’t actually store data.
BE
Beckie
11 months 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.
SH
Sherita
11 months ago
I think the answer might be B, since the table is created in the external storage container. But I'm not entirely sure.
VI
Vi
12 months 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.
CA
Carin
12 months 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.
TA
Tarra
12 months 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.
AL
Alfred
1 year 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.
DE
Deandrea
1 year ago
This question seems straightforward, but I want to make sure I understand the details correctly before answering.
EL
Elly
1 year ago
That could be a possibility too, as long as the table is created in the mounted storage container.
TA
Tanesha
1 year 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.
NI
Nilsa
1 year ago
I agree with Elly, because the external object storage container is mounted to that location.
LO
Lorita
1 year 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.
OT
Otis
1 year ago
Yes, creating a managed table in the specified storage container is the way to go. Option D is the best choice here.
MA
Man
1 year ago
I agree, option D does seem like the most logical choice. It makes sense to use a managed table in this scenario.
CR
Cristy
1 year 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.
AD
Adrianna
1 year 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.
CH
Cherrie
1 year 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.
IV
Ivette
1 year ago
That makes sense. The code clearly indicates the location for the table, so it must be an external table.
KA
Kaycee
1 year ago
I think the answer is B. An external table will be created in the storage container mounted to /mnt/finance eda bucket.
EL
Elly
1 year ago
I think the answer is B) An external table will be created in the storage container mounted to /mnt/finance eda bucket.