Databricks Certified Data Engineer Associate · Free Practice Question Medium

Question 35

Which statement correctly describes the difference between a Temporary View and a Global Temporary View?
  • A There is no difference; both Temporary and Global Temporary Views have the same scope and visibility across Spark sessions.
  • B Temporary Views are session-scoped and cannot be accessed by other Spark sessions, whereas Global Temporary Views are accessible across multiple Spark sessions within the same Spark application.
  • C Temporary Views can be created on disk, making them persistent across Spark sessions, whereas Global Temporary Views are in-memory only and lost after the session ends.
  • D Temporary Views are stored in the Hive metastore and are accessible across all sessions, whereas Global Temporary Views are session-scoped and not stored in the Hive metastore.
Reveal correct answer

Correct answer: B

Explanation

Temporary Views are tied to a single Spark session and are not visible to other sessions, while Global Temporary Views are visible across all sessions of a Spark application but are not stored in the Hive metastore.

Discussion

Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.

You must be logged in to post a comment.

Preparing For

Your Certification?

255+ certifications
Detailed explanations
Free PDF samples

Has All The Questions You Need