Exam DP-300 topic 2 question 17 discussion

Actual exam question from Microsoft's DP-300

Question #: 17
Topic #: 2

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?

A. Create User1 in the master database.
B. Assign User1 the db_datareader role for the master database.
C. Assign User1 the db_datareader role for the databases that User1 creates.
D. Grant SELECT on sys.databases to public in the master database.

Show Suggested Answer

Suggested Answer: A 🗳️

by Behto at Sept. 16, 2021, 2:38 p.m.

Comments

Submit Cancel

Behto

Highly Voted 3 years, 3 months ago

Answer is correct knowing that granting select permissions to the public role in the master database will not impact User1, since this user is contained. The public role in Azure SQL Database only exists at the database-level.

upvoted 14 times

...

learnazureportal

Most Recent 6 months, 1 week ago

Selected Answer: D

Answer D is correct. "A" just says, Create User1 in the master database. This would create a login for User1 in the master database, but it won't automatically grant the ability to see all databases

upvoted 1 times

...