PdfPrep.com

Which Windows Azure SQL Database role should you assign the junior database administrator?

You are the senior database administrator for a Microsoft SQL Server environment that uses Windows Azure SQL Database.

You need to grant a junior database administrator only the permissions required to create new logins.

Which Windows Azure SQL Database role should you assign the junior database administrator?
A . securityadmin
B . loginmanager
C . serveradmin
D . setupadmin

Answer: B

Explanation:

Members of the login manager role can create new logins in the master database.

References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-logins

Exit mobile version