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.
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.