Databricks-Spark-Assoc Using Spark SQL Practice Question

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✗

  CREATE GLOBAL TABLE

  Why it's wrong here

  Global tables are persistent structures stored in the metastore that persist across different sessions and users. They are not intended for temporary, session-scoped data referencing, as they require explicit management and storage allocation, making them unsuitable for ephemeral data processing tasks that should not leave traces after the job completes.

• ✓

  CREATE TEMPORARY VIEW

  Why this is correct

  This command creates a temporary view that exists only within the current SparkSession. It is the ideal tool for ad-hoc analysis or intermediate transformations where the data does not need to be saved to long-term storage or shared across different clusters or users within the organization's wider data environment.

• ✗

  CREATE PERSISTENT VIEW

  Why it's wrong here

  Persistent views are saved to the metastore and remain accessible after the session terminates. They are used for shared datasets that multiple users or processes need to query repeatedly, which is the opposite of the requested temporary, session-scoped behavior required for managing ephemeral data during complex ETL execution.

• ✗

  CREATE SESSION TABLE

  Why it's wrong here

  There is no SQL command named CREATE SESSION TABLE in Spark SQL. Using incorrect syntax will result in a parsing error. Spark SQL uses the TEMPORARY VIEW or GLOBAL TEMPORARY VIEW nomenclature to define the scope and visibility of intermediate datasets within the Spark execution engine's memory management system.