Which permission or permissions should you choose?

DRAG DROP
You administer a Microsoft SQL Server 2012 server along with a Windows Azure SQL
Database database.
For both servers, you need to grant users the ability to create logins and create databases.
You need to determine which permission to grant users in each instance.
Which permission or permissions should you choose? (To answer, drag the appropriate
permission or permissions to their corresponding instance type or types in the answer area.
Answer choices may be used once, more than once, or not at all. Answer targets may be
used once or not at all. Additionally, you may need to drag the split bar between panes or
scroll to view content.)

DRAG DROP
You administer a Microsoft SQL Server 2012 server along with a Windows Azure SQL
Database database.
For both servers, you need to grant users the ability to create logins and create databases.
You need to determine which permission to grant users in each instance.
Which permission or permissions should you choose? (To answer, drag the appropriate
permission or permissions to their corresponding instance type or types in the answer area.
Answer choices may be used once, more than once, or not at all. Answer targets may be
used once or not at all. Additionally, you may need to drag the split bar between panes or
scroll to view content.)

Answer:



Leave a Reply 4

Your email address will not be published. Required fields are marked *


NB

NB

db_accessadmin is a fixed database role.

“Members of the db_accessadmin fixed database role can add or remove access to the database for Windows logins, Windows groups, and SQL Server logins.”

Perhaps db_accessadmin should not be selected at all!

http://msdn.microsoft.com/en-GB/library/ms189121.aspx

Server-Level Roles

http://msdn.microsoft.com/en-us/library/ms188659.aspx

Databases and Logins in Azure

http://msdn.microsoft.com/en-us/library/azure/ee336235.aspx

Ralf

Ralf

Agreed.
I would leave db_accessadmin blank as in this type of question a field may not be used at all. The other answers provide a complete answer.