Which clause should you use to remove the subscribers from the table?

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?
A. WHEN NOT MATCHED BY TARGET
B. WHEN MATCHED
C. WHEN NOT MATCHED BY SOURCE
D. WHEN NOT MATCHED

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.