Microsoft
70-432 · Question #119
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…
Sign in or unlock 70-432 to reveal the answer and full explanation for question #119. The question stem and answer options stay visible for context.
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.
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.