Microsoft
70-433 · Question #159
You have a table named Subscribers. You receive an updated list of subscribers. You need to remove subscribers that are no longer on the list. Which clause should you use to remove the subscribers…
The correct answer is C. WHEN NOT MATCHED BY SOURCE. See the full explanation below for the reasoning.
Question
You have a table named Subscribers. You receive an updated list of subscribers. You need to remove subscribers that are no longer on the list. Which clause should you use to remove the subscribers from the table?
Options
- AWHEN NOT MATCHED
- BWHEN MATCHED
- CWHEN NOT MATCHED BY SOURCE
- DWHEN NOT MATCHED BY TARGET
How the community answered
(40 responses)- A8% (3)
- B3% (1)
- C73% (29)
- D18% (7)
Community Discussion
No community discussion yet for this question.