Which permission should you grant?

You are the database administrator for a company that hosts Microsoft SQL Server. You manage both onpremisesand Microsoft Azure SQL Database environments.

Clients connect to databases by using line-of-business applications. Developers connect by using SQL ServerManagement Studio (SSMS).

You need to provide permissions to a service account that will be used to provision a new database for aclient.

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

View Answer

Answer: C

Explanation:

Members of the dbcreator fixed server role can create, alter, drop, and restore any database.

References: https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/serverlevel-roles