Exam Certified Associate Developer for Apache Spark topic 1 question 84 discussion

Actual exam question from Databricks's Certified Associate Developer for Apache Spark

Question #: 84
Topic #: 1

[All Certified Associate Developer for Apache Spark Questions]

The code block shown below should use SQL to return a new DataFrame containing column storeId and column managerName from a table created from DataFrame storesDF. Choose the response that correctly fills in the numbered blanks within the code block to complete this task.

Code block:

__1__.__2__("stores")
__3__.__4__("SELECT storeId, managerName FROM stores")

A. 1. spark
2. createOrReplaceTempView
3. storesDF
4. query
B. 1. spark
2. createTable
3. storesDF
4. sql
C. 1. storesDF
2. createOrReplaceTempView
3. spark
4. query
D. 1. spark
2. createOrReplaceTempView
3. storesDF
4. sql
E. 1. storesDF
2. createOrReplaceTempView
3. spark
4. sql

Show Suggested Answer

Suggested Answer: E 🗳️

by tangerine141 at Feb. 23, 2024, 3:23 a.m.

Comments

Submit Cancel

PushpakKothekar

4 months ago

Selected Answer: E

Answer is E instead D because "store" is created on dataframe = storeDF.

upvoted 1 times

...

6546a53

11 months, 3 weeks ago

Selected Answer: E

It's E

upvoted 1 times

...

Samir_91

1 year, 2 months ago

Selected Answer: E

It's E

upvoted 1 times

...

Sowwy1

1 year, 4 months ago

It's E

upvoted 1 times

...

Sowwy1

1 year, 4 months ago

It's E. df = spark.createDataFrame([(2, "Alice"), (5, "Bob")], schema=["age", "name"]) df.createTempView("people") df2 = spark.sql("SELECT * FROM people")

upvoted 3 times

...

tangerine141

1 year, 5 months ago

Selected Answer: D

spark.createOrReplaceTempView("stores") storesDF.sql("SELECT storeId, managerName FROM stores")

upvoted 1 times

Samir_91

1 year, 2 months ago

spark.createOrReplaceTempView("stores") gives an error AttributeError: 'SparkSession' object has no attribute 'createOrReplaceTempView'

upvoted 1 times

...

naman405verma

1 year, 5 months ago

no Bro https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/api/pyspark.sql.DataFrame.createTempView.html check this E is correct only

upvoted 2 times

...