Databricks Exam Databricks Certified Data Engineer Associate Topic 1 Question 51 Discussion

Actual exam question for Databricks's Databricks Certified Data Engineer Associate exam

Question #: 51
Topic #: 1

[All Databricks Certified Data Engineer Associate Questions]

Identify a scenario to use an external table.

A Data Engineer needs to create a parquet bronze table and wants to ensure that it gets stored in a specific path in an external location.

Which table can be created in this scenario?

AAn external table where the location is pointing to specific path in external location.

BAn external table where the schema has managed location pointing to specific path in external location.

CA managed table where the catalog has managed location pointing to specific path in external location.

DA managed table where the location is pointing to specific path in external location.

Show Suggested Answer

Suggested Answer: A

by Vilma at Jul 09, 2025, 09:36 AM

Limited Time Offer

25%

Off

Get Premium Databricks Certified Data Engineer Associate Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Stephen

2 days ago

I recall a practice question where we had to choose between managed and external tables. I think external tables are definitely the way to go here, leaning towards option A.

upvoted 0 times

...

Peggie

8 days ago

I'm not entirely sure, but I feel like managed tables are more common for internal storage. Could it be option B instead?

upvoted 0 times

...

Tarra

13 days ago

I think we discussed external tables in class, and I remember that they allow you to specify a location outside the database. So, option A seems right.

upvoted 0 times

...

Deonna

19 days ago

I'm leaning towards B. An external table where the schema has a managed location pointing to the specific path in the external location could also be a valid solution.

upvoted 0 times

...

Donte

24 days ago

Based on the question, I believe the correct answer is A. Creating an external table with a specific location in the external location is the best way to meet the requirements.

upvoted 0 times

...

Irving

29 days ago

Hmm, I'm a bit confused. Is an external table the only option here? I'm wondering if a managed table with a specific location could also work.

upvoted 0 times

...

Billi

1 month ago

I think the answer is A. An external table where the location is pointing to a specific path in an external location seems like the most straightforward way to meet the requirements.

upvoted 0 times

...

Yvonne

3 months ago

I think the real question here is, who came up with these options? They're about as clear as mud.

upvoted 0 times

...

Renea

3 months ago

Option E: Throw the whole thing out and start over. Who needs tables when you can just store everything in a shoebox?

upvoted 0 times

...

Zona

3 months ago

Hold up, why are we even considering a managed table? Clearly option A is the way to go. External tables are the way to go for this specific use case.

upvoted 0 times

...

Hildegarde

3 months ago

I see, so the correct answer is indeed A) An external table with specific path in external location.

upvoted 0 times

...

Loren

3 months ago

I think option B is not correct because the location should be explicitly specified for an external table.

upvoted 0 times

...

Lorean

3 months ago

Hmm, I'm not sure. Maybe option C is the way to go, since the catalog can manage the location and it's a managed table.

upvoted 0 times

Marla

2 months ago

I think option C makes sense, the catalog can handle the location for us.

upvoted 0 times

...

Haley

2 months ago

I think option C makes sense, the catalog can handle the location for us.

upvoted 0 times

...

Carisa

3 months ago

Option B seems more appropriate. The managed location in the schema would ensure the parquet bronze table is stored in the desired path.

upvoted 0 times

Sabra

2 months ago

Yes, it's important to specify the location in an external table for proper storage.

upvoted 0 times

...

Nickole

3 months ago

I agree, using a managed location in the schema would ensure the table is stored in the right path.

upvoted 0 times

...

Novella

3 months ago

I think option B is the best choice.

upvoted 0 times

...

Carma

3 months ago

But what about option B) An external table where the schema has managed location pointing to specific path in external location?

upvoted 0 times

...

Hildegarde

4 months ago

I agree with Loren, because an external table is needed for storing data in a specific path in an external location.

upvoted 0 times

...

Ria

4 months ago

I think option A is the way to go. Creating an external table with the specific location in the external location sounds like the perfect solution for this scenario.

upvoted 0 times

Marilynn

3 months ago

Yes, creating an external table with the specific location in the external location ensures the data is stored where it needs to be.

upvoted 0 times

...

Amie

3 months ago

I agree, option A seems like the most appropriate choice for this scenario.

upvoted 0 times

...

Loren

4 months ago

I think the answer is A) An external table where the location is pointing to specific path in external location.

upvoted 0 times

...