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.)
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.)
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
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.
See: Managing databases & logins in SQL Azure:
https://azure.microsoft.com/en-us/documentation/articles/sql-database-manage-logins/
so U mean to say the given answer is correct..