
Explanation:
A View (CREATE VIEW) stores the logical query execution plan for joining the tables in the metastore without storing a physical copy of the data. Because it is saved in the metastore, it is accessible across multiple sessions. A Temporary View is session-scoped and won't be accessible across sessions. A Delta Table stores physical data. A CTE is strictly query-scoped.
Ultimate access to all questions.
A
Delta Table
B
View
C
Common Table Expression (CTE)
D
Temporary View
No comments yet.