ExamTopics Logo
Mail Us[email protected]
Menu
Databricks Discussions
exam questions

Exam Certified Associate Developer for Apache Spark All Questions

View all questions & answers for the Certified Associate Developer for Apache Spark exam
Go to Exam

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 Hide Answer
Suggested Answer: E 🗳️
by tangerine141 at Feb. 23, 2024, 3:23 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
PushpakKothekar
2 months, 4 weeks ago
Selected Answer: E
Answer is E instead D because "store" is created on dataframe = storeDF.
upvoted 1 times
...
6546a53
10 months, 2 weeks ago
Selected Answer: E
It's E
upvoted 1 times
...
Samir_91
1 year, 1 month ago
Selected Answer: E
It's E
upvoted 1 times
...
Sowwy1
1 year, 3 months ago
It's E
upvoted 1 times
...
Sowwy1
1 year, 3 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, 4 months ago
Selected Answer: D
spark.createOrReplaceTempView("stores") storesDF.sql("SELECT storeId, managerName FROM stores")
upvoted 1 times
Samir_91
1 year, 1 month ago
spark.createOrReplaceTempView("stores") gives an error AttributeError: 'SparkSession' object has no attribute 'createOrReplaceTempView'
upvoted 1 times
...
naman405verma
1 year, 4 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
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel