You create five Azure SQL Database instances on the same logical server. In each database, you create a user for an Azure Active Directory (Azure AD) user named User1. User1 attempts to connect to…

Question

Options

• ACreate User1 in the master database.
• BAssign User1 the db_datareader role for the master database.
• CAssign User1 the db_datareader role for the databases that User1 creates.
• DGrant SELECT on sys.databases to public in the master database.

• A
  71% (12)
• B
  6% (1)
• C
  6% (1)
• D
  18% (3)

Explanation

Logins and users: A user account in a database can be associated with a login that is stored in the master database or can be a user name that is stored in an individual database. A login is an individual account in the master database, to which a user account in one or more databases can be linked. With a login, the credential information for the user account is stored A user account is an individual account in any database that may be, but does not have to be, linked to a login. With a user account that is not linked to a login, the credential information is stored with the user account. https://docs.microsoft.com/en-us/azure/azure-sql/database/logins-create-manage

No community discussion yet for this question.