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?
A temporary view should be created because it allows combining data from multiple tables without storing physical data. Since it is session-based, it is not meant to be used by other data engineers in other sessions. This makes it an ideal choice for saving on storage costs while achieving the required functionality within a single session.
D is correct. Temp view : session based Create temp view view_name as query All these are termed as session ended: Opening a new notebook Detaching and reattaching a cluster Installing a python package Restarting a cluster
D. Temporary view Explanation: Temporary View: A temporary view in database systems like Apache Spark provides a temporary and ephemeral representation of data based on an SQL query's result set. It exists for the duration of a Spark session and is not persisted to storage. Similar to a regular view, a temporary view allows the data engineer to define a logical schema by pulling and combining data from multiple tables using SQL queries, but it does not store any physical data on disk. Temporary views are suitable when there's no need for long-term storage of the combined data and are helpful for immediate analysis or processing within the current session without incurring storage costs.
Answer is D. key phrase is "...does not need to be used by other data engineers in other sessions..."
https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-ddl-create-view.html Should be a view or temporary view to avoid copying and storing data. Does not need to be used by other data engineers in other sessions. So this view should be temporary. TEMPORARY views are visible only to the session that created them and are dropped when the session ends.
D is right option