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…

The correct answer is D. Temporary view. A temporary view satisfies both requirements: (1) it is session-scoped, meaning it is automatically dropped when the Spark session ends and is not visible to other sessions or users, and (2) it stores no physical data - it is purely a logical alias over the underlying query. A…

Submitted by helene.fr· Apr 18, 2026ELT with Spark SQL and Python

Question

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?

Options

ASpark SQL Table
BView
CDatabase
DTemporary view
EDelta Table

How the community answered

(48 responses)

A
2% (1)
C
10% (5)
D
83% (40)
E
4% (2)

Explanation

A temporary view satisfies both requirements: (1) it is session-scoped, meaning it is automatically dropped when the Spark session ends and is not visible to other sessions or users, and (2) it stores no physical data - it is purely a logical alias over the underlying query. A regular View is also non-materializing, but it is persisted to the metastore and accessible across sessions, violating the first requirement. Spark SQL Tables and Delta Tables both write physical data to storage. A Database is just a namespace, not a relational object over data.

Topics

#Spark SQL#Temporary Views#Logical Data Objects#Session Scope

Community Discussion

No community discussion yet for this question.

Full DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE Practice