Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft Exam DP-300 Topic 9 Question 104 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 104
Topic #: 9
[All DP-300 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: C

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

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Evette
1 days ago
Hmm, this is a tricky one. I'm leaning towards option C, since User1 is an Azure AD user and the databases they created should be visible to them. But I could be wrong.
upvoted 0 times
...
Johanna
2 days ago
I'm not sure about this one. Maybe option D would work, but that seems a bit too broad. I'll have to think about this one a bit more.
upvoted 0 times
...
Alaine
4 days ago
I think the answer is B. Assigning User1 the db_datareader role for the master database will allow them to see all the databases, since the master database contains metadata about all the databases on the logical server.
upvoted 0 times
...
Rodolfo
6 days ago
Hmm, that makes sense too. Let's see what others think before we make our final decision.
upvoted 0 times
...
Howard
8 days ago
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
...
Rodolfo
10 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
...

Save Cancel