Microsoft
70-432 · Question #17
You are the administrator of a SQL Server 2008 instance with a database named DB01. The company CIO wants all the application developers can capture traces to troubleshoot the application that uses…
The correct answer is C. All SQL Server logins of the application developers should be given the appropriate. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance with a database named DB01. The company CIO wants all the application developers can capture traces to troubleshoot the application that uses the database DB1, and they can perform this by using SQL Server Profiler. But they must have given little permission as possible. The company CIO assigns this task to you. Which action should you perform to achieve this goal?
Options
- AAll the SQL Server logins of the application developers have to be added to a fixed server role.
- BAll the database users of the application developers have to be added to a fixed database role
- CAll SQL Server logins of the application developers should be given the appropriate
- DAll database users of the application developers should be given the appropriate
How the community answered
(59 responses)- A12% (7)
- B3% (2)
- C78% (46)
- D7% (4)
Community Discussion
No community discussion yet for this question.