Databricks Certified Data Engineer Associate — Question 119

A data engineer wants to create a relational object by pulling data from two tables. The relational object does not need to be used by other data engineers in other sessions. In order to save on storage costs, the data engineer wants to avoid copying and storing physical data.

Which of the following relational objects should the data engineer create?

Answer options

• A. Spark SQL Table
• B. View
• C. Delta Table
• D. Temporary view

Correct answer: D

Explanation

The correct answer is D, Temporary view, because it allows the creation of a relational object without storing physical data, thus saving on storage costs. Options A (Spark SQL Table) and C (Delta Table) involve creating persistent storage, which the engineer wants to avoid. Option B (View) also does not meet the requirement of not needing to be used by other sessions, as views can be accessed by multiple users.