You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
The SQL Server 2008 instance contains a database named CK_Tester that is used
by the Domain.com’s developers. You need to allow the developers to access the SQL Server
Profiler to get traces which can be used to troubleshoot the application that CK_Test uses.
What should you do?
A.
You should consider making use of Transaction Logs to grant login access to the developers.
B.
You should consider giving suitable server-level rights to the whole SQL Server to grant login access to the developers.
C.
You should consider converting the database roles of the developers to a fixed database role.
D.
You should consider giving suitable server-level rights to the default SQL Server grant login access to the developers.