Administering a SQL Database Infrastructure — Question 229

You need to provide a group of users from the IT and Manufacturing departments the minimum administrative rights to view database information and server state for the Manufacturing database on MainDB1.
What should you do?

Answer options

• A. You should configure a Database Role.
• B. You should configure a Server Role.
• C. You should configure a Shared SQL Server Login.
• D. You should configure a Local Security Group.

Correct answer: B

Explanation

The correct answer is B, as configuring a Server Role allows you to grant the necessary permissions at the server level, which is appropriate for viewing server state information. Options A and C are more focused on database-specific permissions and do not provide the necessary server-level access, while option D pertains to local machine access rather than SQL Server permissions.