Microsoft
70-432 · Question #71
70-432 Question #71: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #71. The question stem and answer options stay visible for context.
Question
You are the administrator of a SQL Server 2008 instance with a database named Service with a database user named ServiceGreatUser. A SQL Server login named ServiceGreatLogin maps to ServiceGreatUser in the Service database. According to the requirement of the company CIO, the database user can only perform the two tasks below: - the database user executes all stored procedures that currently exist in the Sales database - executes all stored procedures that will be created in the Sales database. What should you do to ensure this?
Options
- AServiceGreatUser should be added to the appropriate fixed database roles.
- BYou should assign the appropriate object-level permissions to ServiceGreatUser
- CYou should assign the appropriate server-level permissions to ServiceGreatLogin
- DYou should assign the appropriate database-level permissions to ServiceGreatUser
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.