Exam Databricks-Certified-Data-Engineer-Associate Topic 2 Question 173 Discussion

Actual exam question for Databricks's Databricks-Certified-Data-Engineer-Associate exam
Question #: 173
Topic #: 2
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?

Suggested Answer: A Vote an answer

In this scenario, the Data Engineer wants to create a parquet bronze table and ensure that it gets stored in a specific path in an external location. An external table allows you to define the table's structure while storing the actual data in an external location, which can be beneficial for data sharing and managing storage separately from the data warehouse catalog.
An external table where the schema has managed location pointing to specific path in external location: This is incorrect because an external table does not have a managed location; its data is stored in an external location specified by the user.
A managed table where the catalog has managed location pointing to specific path in external location: This is incorrect as managed tables typically store their data in the default location of the database unless specified otherwise, which does not fit the requirement for external storage.
A managed table where the location is pointing to specific path in external location: This is incorrect because managed tables do not allow you to specify an external location; they manage their own data storage.

by Ward at Jun 27, 2026, 03:35 AM

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
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.

0
0
0
10