Pre-Winter Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: pass65

Salesforce Certified Marketing Cloud Engagement Developer MCE-Dev-201 Question # 29 Topic 3 Discussion

Salesforce Certified Marketing Cloud Engagement Developer MCE-Dev-201 Question # 29 Topic 3 Discussion

MCE-Dev-201 Exam Topic 3 Question 29 Discussion:
Question #: 29
Topic #: 3

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


A.

CASE, ISDATE, CONVERT


B.

WHERE, ISDATE, CONVERT


C.

CASE, ISDATE, CAST


D.

UPDATE, ISDATE, CONVERT


Get Premium MCE-Dev-201 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.