Salesforce Certified Marketing Cloud Developer (SP25) Marketing-Cloud-Developer Question # 8 Topic 1 Discussion

Salesforce Certified Marketing Cloud Developer (SP25) Marketing-Cloud-Developer Question # 8 Topic 1 Discussion

Marketing-Cloud-Developer Exam Topic 1 Question 8 Discussion:
Question #: 8
Topic #: 1

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 containline 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?


A.

REPLACE and CHAR


B.

FORMAT and SPACE


C.

LTRIM and RTRJM


D.

REPLICATE and NCHAR


Get Premium Marketing-Cloud-Developer Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.