Question 630
An ingestion SELECT should not abort because some expected YYYY-MM-DD date strings are invalid. What function applies?
Explanation
Correct Answer
Correct for TRY_TO_DATE: TRY_TO_DATE parses supported date strings while tolerating conversion errors with NULL.
Incorrect Answers
Not the right operation for TRY_TO_DATE: IFF(condition, a, b) chooses between two values according to a Boolean condition.
Not the right operation for TRY_TO_DATE: CASE expression supports multiple ordered conditional branches.
Not the right operation for TRY_TO_DATE: COUNT_IF counts records for which a Boolean condition is true.