Microsoft
70-432 · Question #120
70-432 Question #120: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #120. The question stem and answer options stay visible for context.
Question
You are a database administrator for your company. The company uses a SQL Server 2008 database that includes a table named Inventory. The table contains a column named Price. A company policy states that the value in the Price column cannot be decreased by more than 10 percent in any single database operation. Updates to the Price column are made by various means, including by using ad hoc queries. You need to ensure that this company policy is enforced. What should you do?
Options
- AYou should develop a trigger which rolls back changes to the Price column which breaks
- BOn the Price column, you should develop a primary key constraint to a table which includes
- CYou should develop a view which rolls back changes to the Price column which breaks
- DYou should develop a stored procedure which allows changes to the Price column which
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 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.