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

Questions 1–5

1. 1foundation · easy

   Which statement correctly describes the purpose of the `createOrReplaceTempView` method in Spark?

   • AIt registers the DataFrame as a temporary view that can be queried using SQL syntax within the current Spark session.
   • BIt creates a view that is visible to all sessions in the cluster, similar to a global temporary view.
   • CIt creates a permanent table in the Hive metastore that can be shared across sessions.
   • DIt converts the DataFrame into a SQL table that is automatically persisted to disk for fault tolerance.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which method is used to register a DataFrame as a global temporary view?

   • Adf.createOrReplaceTempView("global_view")
   • Bdf.registerGlobalTempTable("global_view")
   • Cdf.createGlobalTempView("global_view")
   • Dspark.sql("CREATE GLOBAL VIEW global_view AS SELECT * FROM df")
   Reveal Solution Discussion Select an answer first
4. 3expert · hard

   A data engineer has a temporary view `orders` with columns `order_id`, `customer_id`, `order_date`, and `amount`. They need to find the top 3 customers by total order amount. They run the following SQL: ```sql SELECT customer_id, SUM(amount) AS total FROM orders GROUP BY customer_id ORDER BY total DESC LIMIT 3 ``` What is the result?

   • AThe query returns the top 3 customers by number of orders, not by total amount.
   • BThe query returns all customers, but only the first 3 rows are displayed.
   • CThe top 3 customers by total order amount, sorted in descending order.
   • DThe query fails because `total` cannot be used in the ORDER BY clause.
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A team runs a multi-notebook job in Databricks. Notebook A creates a global temporary view `shared_metrics`. Notebook B, running in a different Spark session, needs to query this view. Which SQL statement should Notebook B use?

   • A`SELECT * FROM shared_metrics`
   • B`SELECT * FROM global_temp.shared_metrics`
   • C`SELECT * FROM temp.shared_metrics`
   • D`SELECT * FROM default.shared_metrics`
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   A data engineer registers a temporary view named `customer_vw` in a Spark session. What happens to this view when the Spark session ends?

   • AIt becomes a global temporary view that other sessions can access.
   • BIt is automatically removed and is no longer available for querying.
   • CIt is persisted to disk and can be reloaded with `spark.catalog.refreshTable`.
   • DIt remains available in the Hive metastore for future sessions.
   Reveal Solution Discussion Select an answer first