LeetQuiz Logo
Privacy Policy•contact@leetquiz.com
© 2025 LeetQuiz All rights reserved.
Databricks Certified Data Engineer - Associate

Databricks Certified Data Engineer - Associate

Get started today

Ultimate access to all questions.


Which SQL command is used to create a Global temporary view?

Real Exam




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.

Powered ByGPT-5