Microsoft
70-433 · Question #63
You work as a network database administrator at ABC.com. ABC.com has a database server named ABC-DB01 which hosts the Inventory database. ABC.com recently created a table named ItemsSold which lists…
The correct answer is D. By using the WITH CHECK ((Purchases = 0 AND Discount = 0) OR (Purchase > 0 AND. 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 which hosts the Inventory database. ABC.com recently created a table named ItemsSold which lists the customers with their discount ratings. How can you configure ABC-DB01 to have customers who have made purchases before granted 15% discount?
Options
- ABy using the WITH CHECK (Purchases = 0 AND Discount = 0.15) constraint.
- BBy using the WITH CHECK (Purchases > 0 AND Discount 0.15) constraint.
- CBy using the WITH CHECK ((Purchases = 0 AND Discount = 0) AND (Purchase < 0 AND
- DBy using the WITH CHECK ((Purchases = 0 AND Discount = 0) OR (Purchase > 0 AND
How the community answered
(62 responses)- A6% (4)
- B5% (3)
- C16% (10)
- D73% (45)
Community Discussion
No community discussion yet for this question.