nerdexam
Microsoft

70-433 · Question #64

70-433 Question #64: Real Exam Question with Answer & Explanation

Sign in or unlock 70-433 to reveal the answer and full explanation for question #64. The question stem and answer options stay visible for context.

Question

You work as a network database administrator at ABC.com. ABC.com has a database server named ABC-DB01 that hosts the Inventory database. ABC.com has a Sales division which makes changes to the ItemSold and Stock tables of the Inventory database. How can the Inventory database be configured ensuring changes listed in the ItemSold table corresponds to records in the Stock table?

Options

  • ABy making use of the MERGE statement.
  • BBy making use of CLR triggers.
  • CBy making use of a Clustered Index and INNER JOIN constraints.
  • DBy making use of a Foreign key constraint.
  • EBy making use of a Unique constraint.

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.

Full 70-433 Practice