Case Study:
Fairstone Manufacturing Inc.
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?

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.