Posted by: Pdfprep
Post Date: January 6, 2021
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
Leave a Reply