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.