Answer-first summary for fast verification
Answer: Global Temporary view
To avoid the overhead of copying and storing physical data, the optimal choice is a Global Temporary view. This virtual table, which is essentially a saved SQL query against actual tables, does not store physical data. Specifically, Global Temporary views are accessible in other sessions on the same cluster through a temporary database named global_temp. This approach efficiently meets the requirement without unnecessary storage costs. Reference: [Databricks Documentation](https://docs.databricks.com/sql/language-manual/sql-ref-syntax-ddl-create-view.html).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A data engineer aims to create a relational object by combining data from two tables, intended for use by other data engineers in different sessions on the same cluster. To minimize storage costs, the engineer wishes to avoid duplicating and storing physical data. Which relational object should the engineer create?
A
External table
B
Global Temporary view
C
Managed table
D
Temporary view
E
View