Microsoft
70-432 · Question #119
70-432 Question #119: Real Exam Question with Answer & Explanation
The correct answer is B. Grant the appropriate server-level permissions to all SQL Server logins of the application. See the full explanation below for the reasoning.
Question
You administer a SQL Server 2008 instance. The instance contains a database named DB1. You plan to allow all the application developers to use SQL Server Profiler to capture traces to troubleshoot the application that uses the database DB1. You need to grant the minimum necessary permission to the application developers. What should you do?
Options
- AGrant the appropriate database-level permissions to all database users of the application
- BGrant the appropriate server-level permissions to all SQL Server logins of the application
- CAdd all the database users of the application developers to a fixed database role.
- DAdd all the SQL Server logins of the application developers to a fixed server role.
Community Discussion
No community discussion yet for this question.