Microsoft
70-433 · Question #119
70-433 Question #119: Real Exam Question with Answer & Explanation
Sign in or unlock 70-433 to reveal the answer and full explanation for question #119. The question stem and answer options stay visible for context.
Question
You have the following two tables. Products ProductID ProductName VendorID 1 Product1 0 2 Product2 1 3 Product3 1 4 Product4 0 ProductChanges ProductID ProductName VendorID 1 Product1 1 2 Product2 1 3 NewProduct3 2 5 Product5 1 You execute the following statement. MERGE Products USING ProductChanges ON (Products.ProductID = ProductChanges.ProductID) WHEN MATCHED AND Products.VendorID = 0 THEN DELETE WHEN MATCHED THEN UPDATE SET Products.ProductName = ProductChanges.ProductName Products.VendorID = ProductChanges.VendorID; You need to identify the rows that will be displayed in the Products table. Which rows will be displayed?
Options
- AProductID ProductName VendorID
- BProductID ProductName VendorID
- CProductID ProductName VendorID
- DProductID ProductName VendorID
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.