Exam 70-764 topic 1 question 15 discussion

Actual exam question from Microsoft's 70-764

Question #: 15
Topic #: 1

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 on-premises 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

Show Suggested Answer

Suggested Answer: C 🗳️
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/server-level-roles

by New2me123 at Sept. 26, 2020, 3:29 p.m.

Comments

Submit Cancel

Chandra111

4 years, 4 months ago

For DB Creation, it needs to be grant DBCreator permission.

upvoted 1 times

...

New2me123

4 years, 9 months ago

Not suprising that creating a database requires the dbcreator role

upvoted 1 times

...