Register DataFrames as Temporary Views in Spark SQL, Allowing Them to Be Queried with SQL Syntax. ASSOCIATE-DEVELOPER-APACHE-SPARK Practice Questions (Page 2)

Questions 6–10

1. 6foundation · easy

   Which method should be used to replace an existing temporary view with a new DataFrame, regardless of whether the view already exists?

   • Adf.createTempView("my_view")
   • Bdf.createOrReplaceTempView("my_view")
   • Cspark.catalog.dropTempView("my_view") then df.createTempView("my_view")
   • Ddf.registerTempTable("my_view")
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   What is the key difference between a temporary view and a global temporary view in Spark?

   • ATemporary views are session-scoped, while global temporary views are cluster-scoped and visible across sessions.
   • BTemporary views are automatically cached, while global temporary views are not.
   • CTemporary views are stored in memory, while global temporary views are stored on disk.
   • DTemporary views can only be created from DataFrames, while global temporary views can be created from RDDs.
   Reveal Solution Discussion Select an answer first
4. 8expert · hard

   A data engineering team runs a long-lived Spark application that processes streaming data. They register a temporary view `streaming_events` in the main thread. Later, they spawn a separate thread within the same Spark application to run a SQL query against this view. What is the outcome?

   • AThe query succeeds because the temporary view is visible to all threads within the same Spark session.
   • BThe query fails because temporary views are not thread-safe and cannot be accessed from multiple threads.
   • CThe query fails because the temporary view is not visible to the new thread's session.
   • DThe query succeeds only if the view is registered as a global temporary view.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   A data engineer runs `df.createTempView("my_view")` and then later runs `df2.createTempView("my_view")` in the same session. What is the result?

   • AThe second call overwrites the existing view silently.
   • BThe second call fails because a view with the same name already exists.
   • CThe second call creates a new view with a suffix, such as `my_view_1`.
   • DThe second call succeeds and replaces the existing view with `df2`.
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A data engineer runs the following code in a notebook: ```python df1.createTempView("my_view") df2.createTempView("my_view") ``` What is the result?

   • AThe second call is ignored and the view remains as `df1`.
   • BThe second call replaces the view with `df2`.
   • CThe second call throws an error because the view already exists.
   • DThe second call creates a new view with a different name automatically.
   Reveal Solution Discussion Select an answer first