PrepAway - Latest Free Exam Questions & Answers

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.)

PrepAway - Latest Free Exam Questions & Answers

Answer:

4 Comments on “Which permission or permissions should you choose?

  1. NB says:

    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




    0



    0

Leave a Reply