Databricks Certified Associate Developer for Apache Spark
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
Which of the following code blocks uses SQL syntax to create a new DataFrame with columns storeId and managerName from a table derived from the storesDF DataFrame?
A
storesDF.createOrReplaceTempView() spark.sql("SELECT storeId, managerName FROM stores")
B
storesDF.query(”SELECT storeid, managerName from stores")
C
spark.createOrReplaceTempView("storesDF") storesDF.sql("SELECT storeId, managerName from stores")
D
storesDF.createOrReplaceTempView("stores") spark.sql("SELECT storeId, managerName FROM stores")
E
storesDF.createOrReplaceTempView("stores") storesDF.query("SELECT storeId, managerName FROM stores")