You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing a fixed server-level role that does not allow its members to add, modify, or delete any
data in the user tables within a database.
Which of the following is the fixed server-level role you are discussing?
A.
The db_ddladmin role.
B.
The db_denydatareader role.
C.
The db_denydatawriter role.
D.
The db_datareader role.
Explanation: