DP-300 Question #156: Real Exam Question with Answer & Explanation

Question

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 the logical server by using Azure Data Studio and receives a login error. You need to ensure that when User1 connects to the logical server by using Azure Data Studio, User1 can see all the databases. What should you do?

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.

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.