DatabricksDatabricks
DATABRICKS-CERTIFIED-ASSOCIATE-DEVELOPER-FOR-APACHE-SPARK · Question #113
DATABRICKS-CERTIFIED-ASSOCIATE-DEVELOPER-FOR-APACHE-SPARK Question #113: Real Exam Question with Answer & Explanation
The correct answer is D: storesDF.createOrReplaceTempView("stores"). See the full explanation below for the reasoning.
Data Manipulation with Spark SQL
Question
Which of the following code blocks uses SQL to return a new DataFrame containing column storeId and column managerName from a table created from DataFrame storesDF?
Options
- AstoresDF.createOrReplaceTempView()
- BstoresDF.query("SELECT storeid, managerName from stores")
- Cspark.createOrReplaceTempView("storesDF")
- DstoresDF.createOrReplaceTempView("stores")
- EstoresDF.createOrReplaceTempView("stores")
Topics
#Spark SQL#DataFrame Operations#Temporary Views
Community Discussion
No community discussion yet for this question.