Ultimate access to all questions.
Which SQL command is used to create a Global temporary view?
Explanation:
To create a Global temporary view, the correct SQL command is CREATE OR REPLACE GLOBAL TEMPORARY VIEW view_name AS SELECT * FROM table_name
. Global temporary views are accessible across all notebooks in a cluster but are lost if the cluster restarts. In contrast, Local temporary views are session-scoped and only available within the same Spark session, making them inaccessible to other notebooks in the same cluster and lost if the notebook is detached and reattached.