DRAG DROP
You are creating a sales data warehouse. When a product exists in the product dimension, you
update the product name. When a product does not exist, you insert a new record. In the current
implementation, the DimProduct table must be scanned twice, once for the insert and again for the
update. As a result, inserts and updates to the DimProduct table take longer than expected. You
need to create a solution that uses a single command to perform an update and an insert. How
should you use a MERGE T-SQL statement to accomplish this goal? (To answer, drag the appropriate
answer choice from the list of options to the correct location or locations in the answer area. You
may need to drag the split bar between panes or scroll to view content.)

Answer:

Explanation:
Reference:
http://msdn.microsoft.com/en-us/library/bb510625.aspx
http://msdn.microsoft.com/en-us/library/cc280522.aspx