Microsoft
70-433 · Question #63
70-433 Question #63: Real Exam Question with Answer & Explanation
Sign in or unlock 70-433 to reveal the answer and full explanation for question #63. 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 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
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.