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
Lucia
1 months ago
Wait, what about UPDATE? Shouldn't we update the data extension with the normalized dates? Oh well, CASE, ISDATE, and CONVERT it is!
upvoted 0 times
...
Pamella
1 months ago
Hmm, I was also thinking about using CAST instead of CONVERT, but CONVERT seems more appropriate here since we're dealing with text fields and not just pure date values.
upvoted 0 times
Alyce
23 hours ago
Hmm, I was also thinking about using CAST instead of CONVERT, but CONVERT seems more appropriate here since we're dealing with text fields and not just pure date values.
upvoted 0 times
...
Sherill
7 days ago
B) WHERE, ISDATE, CONVERT
upvoted 0 times
...
Delsie
15 days ago
A) CASE, ISDATE, CONVERT
upvoted 0 times
...
...
Miss
1 months ago
I agree, CASE, ISDATE, and CONVERT are the perfect SQL functions to deal with this scenario. The CASE statement can help us identify the valid and invalid dates, and CONVERT can be used to standardize the date format.
upvoted 0 times
Nada
2 days ago
I agree, CASE, ISDATE, and CONVERT are the perfect SQL functions to deal with this scenario.
upvoted 0 times
...
Luisa
21 days ago
B) WHERE, ISDATE, CONVERT
upvoted 0 times
...
Viola
1 months ago
A) CASE, ISDATE, CONVERT
upvoted 0 times
...
...
Vilma
2 months ago
I'm not sure, but I think C) CASE, ISDATE, CAST could also work for this scenario.
upvoted 0 times
...
Shayne
2 months ago
I agree with Kenneth, those functions seem appropriate for normalizing the date values.
upvoted 0 times
...
Leoma
2 months 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
Abel
1 months ago
B) WHERE, ISDATE, CONVERT could also be useful for normalizing the data before adding it to the master data extension.
upvoted 0 times
...
Shad
1 months ago
A) CASE, ISDATE, CONVERT can help us handle the different date formats in the 'birthday' field.
upvoted 0 times
...
...
Kenneth
2 months ago
I think A) CASE, ISDATE, CONVERT could be used for this query.
upvoted 0 times
...
Annamae
2 months ago
I'm not sure about the correct answer. Can someone explain why A) is the right choice?
upvoted 0 times
...
Jose
2 months ago
I agree with Gayla. Those functions can help normalize the date values in the 'birthday' field.
upvoted 0 times
...
Gayla
2 months ago
I think A) CASE, ISDATE, CONVERT could be used to write the query.
upvoted 0 times
...

Save Cancel