Exam 70-461 topic 1 question 125 discussion

HOTSPOT -
You are developing an SQL Server database for an automobile manufacturer. The manufacturer maintains the list of vehicles sold and vehicles that have been recalled. The tables are shown below:

You have the following Transact-SQL code. Line numbers are included for reference only.

You must update the VehiclesToRecall table with the list of vehicles that were recalled in 2014. You must maximize the performance of the operation.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Hot Area:

Suggested Answer:
Reference: MERGE (Transact-SQL)
https://msdn.microsoft.com/en-us/library/bb510625.aspx