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 allows the ability to create, alter, drop, and restore any
database.
Which of the following is the fixed server-level role you are discussing?
A.
The public role.
B.
The dbcreator role.
C.
The setupadmin role.
D.
The processadmin role.
Explanation: