Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Salesforce Exam Marketing Cloud Developer Topic 3 Question 67 Discussion

Actual exam question for Salesforce's Marketing Cloud Developer exam
Question #: 67
Topic #: 3
[All Marketing Cloud Developer Questions]

Customer data has been imported into a staging data extension and needs 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

Show Suggested Answer Hide Answer
Suggested Answer: A

by Tesha at Apr 28, 2024, 01:49 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
Vilma
14 days ago
I'm not sure, but I think C) CASE, ISDATE, CAST could also work for this scenario.
upvoted 0 times
...
Shayne
16 days ago
I agree with Kenneth, those functions seem appropriate for normalizing the date values.
upvoted 0 times
...
Leoma
16 days ago
CASE, ISDATE, CONVERT seem like the best options to handle the various date formats in the 'birthday' field and normalize the data before adding to the master data extension.
upvoted 0 times
...
Kenneth
17 days ago
I think A) CASE, ISDATE, CONVERT could be used for this query.
upvoted 0 times
...
Annamae
20 days ago
I'm not sure about the correct answer. Can someone explain why A) is the right choice?
upvoted 0 times
...
Jose
25 days ago
I agree with Gayla. Those functions can help normalize the date values in the 'birthday' field.
upvoted 0 times
...
Gayla
26 days ago
I think A) CASE, ISDATE, CONVERT could be used to write the query.
upvoted 0 times
...

Save Cancel