nerdexam
Microsoft

70-433 · Question #7

A database contains tables named Sales and SalesArchive. SalesArchive contains historical sales data. You configure Change Tracking on the Sales table. The minimum valid version of the Sales table…

The correct answer is A. FROM Sales. See the full explanation below for the reasoning.

Question

A database contains tables named Sales and SalesArchive. SalesArchive contains historical sales data. You configure Change Tracking on the Sales table. The minimum valid version of the Sales table is 10. You need to write a query to export only sales data that changed since version 10, including the primary key of deleted rows. Which method should you use?

Options

  • AFROM Sales
  • BFROM Sales
  • CFROM Sales
  • DFROM Sales

How the community answered

(35 responses)
  • A
    74% (26)
  • B
    14% (5)
  • C
    6% (2)
  • D
    6% (2)

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice