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

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

Contribute your Thoughts:

Submit Cancel

Apolonia

2 months ago

I'm just gonna go with option E: Summon the Azure database gods and hope they fix it for me. That's how it works, right?

upvoted 0 times

Kendra

22 days ago

That makes sense. I'll go with that option. Thanks!

upvoted 0 times

...

Franklyn

28 days ago

I think the correct option is to create User1 in the master database.

upvoted 0 times

...

Tamar

29 days ago

Option E is not a valid choice. You need to choose from the provided options.

upvoted 0 times

...

Johanna

2 months ago

Option B sounds good to me. I mean, who doesn't love a little data reading? It's like reading a really boring book, but with databases instead of words.

upvoted 0 times

Breana

7 days ago

User1: Thanks, I'll give that a try.

upvoted 0 times

...

Hyman

30 days ago

User3: That makes sense, User1 needs access to all the databases.

upvoted 0 times

...

Carin

1 months ago

User2: You should assign User1 the db_datareader role for the master database.

upvoted 0 times

...

Renea

1 months ago

User1: I can't connect to the logical server in Azure Data Studio.

upvoted 0 times

...

Evette

2 months 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

Hobert

1 months ago

I agree, option C seems like the best solution to ensure User1 can see all the databases when connecting with Azure Data Studio.

upvoted 0 times

...

Gilma

1 months ago

I think option C is the correct choice. User1 should be assigned the db_datareader role for the databases they create.

upvoted 0 times

...

Johanna

2 months 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

...

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

2 months ago

Hmm, that makes sense too. Let's see what others think before we make our final decision.

upvoted 0 times

...

Howard

2 months 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

3 months 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

...

Microsoft Exam DP-300 Topic 9 Question 104 Discussion

Contribute your Thoughts:

Apolonia

Kendra

Franklyn

Tamar

Johanna

Breana

Hyman

Carin

Renea

Evette

Hobert

Gilma

Johanna

Alaine

Rodolfo

Howard

Rodolfo