Free Access Salesforce Marketing-Cloud-Developer New Release

Page: 13 / 14

Question 52

A developerwants to transform the date and time 'Data_Enrolled' from Daylight Savings time. How would the developer change the time to fall back one hour?

Options:

%%=DataAdd(Date_Enrolled,-1)=%%

%%=DateAdd(Date_Enrolled,-1 'H')=%%

%%=DateDiff(Date_Enrolled, 1,'H')=%%

%%=FormatDate(Date_Enrolled,-1,'HH','en-us')=%%

Question 53

Customer data has been imported into a staging data extension andneeds to be normalized before adding into the master data extension. A text field named 'birthday' contains date values in various formats. Some of the values are valid dates, but some are not.

Which SQL keywords and functions could be used to write the query'' Choose 2 answers

Options:

CASE, ISDATE, CONVERT

WHERE, ISDATE, CONVERT

CASE, ISDATE, CAST

UPDATE, ISDATE, CONVERT

Question 54

Which SSJS library can be used in email messages? Choose 1.

Options:

Both

Platform

None

Core

Question 55

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?