Note: This question is part of a series of questions that use the same or similar answer choices. An answer
choice may be correct for more than one question in the series. Each question is independent of the other
questions in this series. Information and details provided in a question apply only to that question.
You are the database administrator for a company that hosts Microsoft SQL Server. You manage both onpremises and Microsoft Azure SQL Database environments.
Clients connect to databases by using line-of-business applications. Developers connect by using SQL Server
Management Studio (SSMS).
You need to provide permissions to a service account that will be used to provision a new database for a client.
Which permission should you grant?
A.
DDLAdmin
B.
db_datawriter
C.
dbcreator
D.
dbo
E.
View Database State
F.
View Server State
G.
View Definition
H.
sysadmin
Explanation:
Members of the dbcreator fixed server role can create, alter, drop, and restore any database.
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/serverlevel-roles