A data engineer wants to create a data entity from a couple of tables. The data entity must be used by other data engineers in other sessions. It also must be saved to a physical location. Which of…

The correct answer is E. Table. The two requirements are: (1) accessible by other data engineers in other sessions, and (2) saved to a physical location. A Table satisfies both - it persists across sessions and stores data physically. A Temporary View is session-scoped and disappears when the session ends…

Submitted by neha2k· Apr 18, 2026ELT with Spark SQL and Python

Question

A data engineer wants to create a data entity from a couple of tables. The data entity must be used by other data engineers in other sessions. It also must be saved to a physical location. Which of the following data entities should the data engineer create?

Options

ADatabase
BFunction
CView
DTemporary view
ETable

How the community answered

(27 responses)

B
7% (2)
D
4% (1)
E
89% (24)

Explanation

The two requirements are: (1) accessible by other data engineers in other sessions, and (2) saved to a physical location. A Table satisfies both - it persists across sessions and stores data physically. A Temporary View is session-scoped and disappears when the session ends, failing requirement 1. A regular View is session-persistent but is virtual (no physical storage), failing requirement 2. A Database is a namespace container, not a data entity. A Function is a callable routine, not a data storage entity. Only a Table meets both criteria.

Topics

#Tables#Data Persistence#Data Entities#SQL Operations

Community Discussion

No community discussion yet for this question.

Full DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE Practice