Microsoft
70-451 · Question #81
You need to provide a developer the ability to create and modify database diagrams from an existing database by using SQL Server Management Studio. The solution must minimize the amount of…
The correct answer is B. Add the developer to the db_owner role. See the full explanation below for the reasoning.
Question
You need to provide a developer the ability to create and modify database diagrams from an existing database by using SQL Server Management Studio. The solution must minimize the amount of permissions assigned to the developer. What should you do?
Options
- AAdd the developer to the sysadmin role.
- BAdd the developer to the db_owner role.
- CGrant the developer the CREATE TABLE permission only.
- DGrant the developer the CREATE SCHEMA permission only.
How the community answered
(30 responses)- A7% (2)
- B73% (22)
- C17% (5)
- D3% (1)
Community Discussion
No community discussion yet for this question.