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.

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
A . CASE, ISDATE, CONVERT
B . WHERE, ISDATE, CONVERT
C . CASE, ISDATE, CAST
D . UPDATE, ISDATE, CONVERT

View Answer

Answer: A,C