Databricks Certified Data Engineer Associate — Question 96

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?

Answer options

• A. An external table where the location is pointing to specific path in external location.
• B. An external table where the schema has managed location pointing to specific path in external location.
• C. A managed table where the catalog has managed location pointing to specific path in external location.
• D. A managed table where the location is pointing to specific path in external location.

Correct answer: A

Explanation

The correct answer is A because an external table allows for data to be stored in a specified external location, fulfilling the requirement. Options B, C, and D do not meet the criteria since they either refer to managed tables or incorrect usage of managed locations.