Microsoft Exam DP-900 Topic 10 Question 91 Discussion

Actual exam question for Microsoft's DP-900 exam

Question #: 91
Topic #: 10

You need to query a table named Products in an Azure SQL database.

Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. (Choose three.)

NOTE: Each correct selection is worth one point.

AYou must be assigned the Reader role for the resource group that contains the database.

BYou must have SELECT access to the Products table.

CYou must have a user in the database.

DYou must be assigned the Contributor role for the resource group that contains the database.

EYour IP address must be allowed to connect to the database.

Show Suggested Answer

Suggested Answer: D

by Bobbye at Sep 14, 2024, 04:03 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Laurel

12 days ago

I bet the exam writers were having a bit of fun with those resource group options. But I'm sticking with the basics: B, C, and E.

upvoted 0 times

...

Marguerita

14 days ago

Ah, this is a classic Azure SQL database question. I'm going with B, C, and E - no need for those resource group roles.

upvoted 0 times

Brynn

10 hours ago

I think you're right, B, C, and E are the correct requirements.

upvoted 0 times

...

Hoa

22 days ago

Haha, I wonder if the exam writers were trying to trick us with those resource group roles. But B, C, and E are clearly the requirements here.

upvoted 0 times

...

Gwenn

28 days ago

Definitely B, C, and E. The resource group roles in A and D don't seem necessary for just querying the table.

upvoted 0 times

Celestine

8 hours ago

I agree, having SELECT access to the table, a user in the database, and the IP address allowed are the key requirements.

upvoted 0 times

...

Laurel

1 months ago

Hmm, I think options B, C, and E are the correct answers here. You need to have access to the table, a user in the database, and your IP address must be allowed to connect.

upvoted 0 times

...

Thaddeus

2 months ago

Exactly. And our IP address must be allowed to connect to the database as well.

upvoted 0 times

...

Aileen

2 months ago

Yes, that makes sense. We also need to have a user in the database, right?

upvoted 0 times

...

Thaddeus

2 months ago

I think we need to have SELECT access to the Products table to query it from the internet.

upvoted 0 times

...