You are a database developer. You plan to design a database solution by using SQL Server
2008. A stored procedure uses the INSERT, UPDATE, and DELETE statements separately
to load data into a table. You need to rewrite the stored procedure to use a single statement
to load the data. What should you do?

A.
Write a MERGE statement by using a WHEN MATCHED clause and two WHEN NOT
MATCHED BY SOURCE clauses.

B.
Write a MERGE statement by using a WHEN MATCHED clause, a WHEN NOT
MATCHED BY TARGET clause, and a WHEN NOT MATCHED BY SOURCE clause.

C.
Write a MERGE statement by using a WHEN MATCHED clause and a WHEN NOT
MATCHED BY SOURCE clause.

D.
Write a MERGE statement by using a WHEN MATCHED clause and a WHEN NOT
MATCHED BY TARGET clause.