nerdexam
Microsoft

70-433 · Question #119

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…

The correct answer is B. ProductID ProductName VendorID. See the full explanation below for the reasoning.

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

How the community answered

(34 responses)
  • A
    6% (2)
  • B
    79% (27)
  • C
    3% (1)
  • D
    12% (4)

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice