Explanation:
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.
Ultimate access to all questions.
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
No comments yet.