Salesforce Exam Marketing Cloud Developer Topic 2 Question 87 Discussion

Actual exam question for Salesforce's Marketing Cloud Developer exam

Question #: 87
Topic #: 2

[All Marketing Cloud Developer Questions]

A developer wants to write a query to compile data originating from an HTML form so it can be exported in CSV format. However, the source data extension may contain line breaks within the Comments field, which makes it difficult to read and sort the resulting CSV.

Which SQL functions could be used to change each line break to a single space?

AREPLACE and CHAR

BFORMAT and SPACE

CLTRIM and RTRJM

DREPLICATE and NCHAR

Show Suggested Answer

Suggested Answer: C

by Daron at Jan 26, 2025, 08:52 PM

Limited Time Offer

25%

Off

Get Premium Marketing Cloud Developer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Dyan

3 days ago

I think A) REPLACE and CHAR could be used to change line breaks to spaces.

upvoted 0 times

...