Databricks Certified Associate Developer for Apache Spark
Comments
Loading comments...
Ultimate access to all questions.
The code block shown below should return a new DataFrame where single quotes in column storeSlogan have been replaced with double quotes. Choose the response that correctly fills in the numbered blanks within the code block to complete this task.
A sample of DataFrame storesDF is below:
storeId storeSlogan
0 consequat vitae …
1 'aliquam at pelle…
2 'non ac leo phare…
3 l'eget purus vel sed"
4 'vitae phasellus …
storeId storeSlogan
0 consequat vitae …
1 'aliquam at pelle…
2 'non ac leo phare…
3 l'eget purus vel sed"
4 'vitae phasellus …
Code block:
storesDF.__1__(__2__, __3__(__4__, __5__, __6__))
storesDF.__1__(__2__, __3__(__4__, __5__, __6__))
A
{'1': 'withColumn', '2': '"storeSlogan"', '3': 'regexp_extract', '4': 'col("storeSlogan")', '5': '"\""', '6': '"'"'}_
B
{'1': 'newColumn', '2': 'storeSlogan', '3': 'regexp_extract', '4': 'col(storeSlogan)', '5': '"\""', '6': '"'"'}_
C
{'1': 'withColumn', '2': '"storeSlogan"', '3': 'regexp_replace', '4': 'col("storeSlogan")', '5': '"\""', '6': '"'"'}_
D
{'1': 'withColumn', '2': '"storeSlogan"', '3': 'regexp_replace', '4': 'col("storeSlogan")', '5': '"'"', '6': '"\""'}_
E
{'1': 'withColumn', '2': '"storeSlogan"', '3': 'regexp_extract', '4': 'col("storeSlogan")', '5': '"'"', '6': '"\""'}_