Microsoft
70-433 · Question #64
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…
The correct answer is D. By making use of a Foreign key constraint. See the full explanation below for the reasoning.
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.
How the community answered
(24 responses)- A4% (1)
- B4% (1)
- C8% (2)
- D83% (20)
Community Discussion
No community discussion yet for this question.