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 169 discussion

Actual exam question from Databricks's Certified Associate Developer for Apache Spark
Question #: 169
Topic #: 1
[All Certified Associate Developer for Apache Spark Questions]

Which of the following code blocks returns a DataFrame with column storeSlogan where single quotes in column storeSlogan in DataFrame storesDF have been replaced with double quotes?

A sample of DataFrame storesDF is below:

  • A. storesDF.withColumn("storeSlogan", col("storeSlogan").regexp_replace("’" "\""))
  • B. storesDF.withColumn("storeSlogan", regexp_replace(col("storeSlogan"), "’"))
  • C. storesDF.withColumn("storeSlogan", regexp_replace(col("storeSlogan"), "’", "\""))
  • D. storesDF.withColumn("storeSlogan", regexp_replace("storeSlogan", "’", "\""))
  • E. storesDF.withColumn("storeSlogan", regexp_extract(col("storeSlogan"), "’", "\""))
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by sionita at March 29, 2024, 7:56 p.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
Thameur01
2 months ago
Selected Answer: C
C and D, regexp_replace can take both string and column type object
upvoted 1 times
...
bp_a_user
3 months, 2 weeks ago
Selected Answer: C
both works: C+D tested it
upvoted 1 times
...
Sowwy1
6 months, 3 weeks ago
It's C. https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/api/pyspark.sql.functions.regexp_replace.html
upvoted 1 times
...
sionita
7 months ago
Why C and nod D ?
upvoted 1 times
jtu363
5 months, 1 week ago
yes,D also works. disregard my previous comment.
upvoted 1 times
...
jtu363
5 months, 1 week ago
needs a col object
upvoted 1 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago