A data engineer has a DataFrame named `salesDF` and wants to query it using Spark SQL in the same notebook. Which method registers the DataFrame as a temporary view so that SQL statements can reference it?

spark.catalog.createTable("sales", salesDF)

salesDF.createOrReplaceTempView("sales")

spark.sql("CREATE VIEW sales AS SELECT * FROM salesDF")

salesDF.registerTempTable("sales")

A data engineer has a temporary view `inventory` that is used by a long-running SQL query in another thread. They need to update the view with new data while the query is still running. What is the impact of using `createOrReplaceTempView` to replace the view?

The running query fails because the view is replaced mid-execution.

The running query automatically switches to the new data.

The running query continues to use the old data, and new queries use the new data.

The view replacement is blocked until the running query finishes.

DatabricksCertified Associate Developer for Apache Spark

Domain 2Objective 4

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

Part of the Using Spark SQL domain, which accounts for 20% of the ASSOCIATE-DEVELOPER-APACHE-SPARK exam. Databricks does not publish an official question count, but from its 90-minute exam (~35–60 total, ~7–12 in this domain), expect 2–3 from this objective — we provide 12 practice questions to prepare you well beyond it. (estimate)

12questions here

3free pages

5concepts

20%of the exam

Questions 11–12

11foundation · easy
A data engineer has a DataFrame named `salesDF` and wants to query it using Spark SQL in the same notebook. Which method registers the DataFrame as a temporary view so that SQL statements can reference it?
Select an answer first
12expert · hard
A data engineer has a temporary view `inventory` that is used by a long-running SQL query in another thread. They need to update the view with new data while the query is still running. What is the impact of using `createOrReplaceTempView` to replace the view?
Select an answer first

Finished these 2 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to ASSOCIATE-DEVELOPER-APACHE-SPARK

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Databricks. “ASSOCIATE-DEVELOPER-APACHE-SPARK” is a trademark of its owner, used for identification only.

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

Questions 11–12

A data engineer has a DataFrame named `salesDF` and wants to query it using Spark SQL in the same notebook. Which method registers the DataFrame as a temporary view so that SQL statements can reference it?

A data engineer has a temporary view `inventory` that is used by a long-running SQL query in another thread. They need to update the view with new data while the query is still running. What is the impact of using `createOrReplaceTempView` to replace the view?

Keep studying — Using Spark SQL