nerdexam
Microsoft

70-451 · Question #37

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…

The correct answer is C. Write a MERGE statement by using a WHEN MATCHED clause, a WHEN NOT. See the full explanation below for the reasoning.

Question

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?

Options

  • AWrite a MERGE statement by using a WHEN MATCHED clause and a WHEN NOT
  • BWrite a MERGE statement by using a WHEN MATCHED clause and a WHEN NOT
  • CWrite a MERGE statement by using a WHEN MATCHED clause, a WHEN NOT
  • DWrite a MERGE statement by using a WHEN MATCHED clause and two WHEN NOT

How the community answered

(40 responses)
  • A
    13% (5)
  • B
    5% (2)
  • C
    80% (32)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-451 Practice