Answer-first summary for fast verification
Answer: CREATE OR REPLACE GLOBAL TEMPORARY VIEW view_name AS SELECT * FROM table_name
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.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which SQL command is used to create a Global temporary view?
A
CREATE OR REPLACE LOCAL TEMPORARY VIEW view_name AS SELECT * FROM table_name
B
CREATE OR REPLACE VIEW view_name AS SELECT * FROM table_name
C
CREATE OR REPLACE GLOBAL TEMPORARY VIEW view_name AS SELECT * FROM table_name
D
CREATE OR REPLACE LOCAL VIEW view_name AS SELECT * FROM table_name
E
CREATE OR REPLACE TEMPORARY VIEW view_name AS SELECT * FROM table_name
No comments yet.