Microsoft Exam DP-300 Topic 9 Question 104 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 104
Topic #: 9

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?

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 Userl creates.

DGrant select on sys.databases to public in the master database.

Show Suggested Answer

Suggested Answer: C

by Justine at Sep 15, 2024, 02:01 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

I disagree, I believe the answer is D. Granting select on sys.databases to public in the master database would give User1 access to all databases.

upvoted 0 times

...

2 days ago

I think the answer is C. Assigning User1 the db_datareader role for the databases that User1 creates would allow them to see all the databases.

upvoted 0 times

...