Exam DP-800 Topic 1 Question 85 Discussion

Drag and Drop Question
You have a Microsoft SQL Server 2025 database that contains a table named dbo.CustomerMessages. dbo.CustomerMessages contains two columns named MessageID (int) and MessageRaw (nvarchar(max)).
MessageRaw can contain a phone number in multiple formats, and some rows do NOT contain a phone number.
You need to write a single SELECT query that meets the following requirements:
- The query must return MessageID, RawNumber, DigitsOnly, and
PhoneStatus.
- RawNumber must contain the first substring that matches a phone-
number pattern, or NULL if no match exists.
- DigitsOnly must remove all non-digit characters from RawNumber, or
return NULL.
- PhoneStatus must return valid when a phone number exists in
MessageRaw, otherwise return Missing.
How should you complete the Transact-SQL query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.