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

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

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

Veronika

3 days ago

I agree, having SELECT access to the table, a user in the database, and allowing your IP address to connect are essential.

upvoted 0 times

...

Brynn

21 days ago

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

upvoted 0 times

...

Hoa

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

Cassi

3 days ago

Yeah, it's important to pay attention to the details in the requirements.

upvoted 0 times

...

Adelina

8 days ago

I think so too, those resource group roles in A and D are just there to confuse us.

upvoted 0 times

...

Kandis

10 days ago

I agree, B, C, and E are definitely the requirements to query the table from the internet.

upvoted 0 times

...

Gwenn

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

Lezlie

11 days ago

Makes sense. It's important to focus on the access to the table and the connection permissions.

upvoted 0 times

...

Kristin

15 days ago

Yeah, those are the essential ones. The resource group roles don't directly impact querying the table.

upvoted 0 times

...

Celestine

21 days 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

2 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

Judy

23 hours ago

Looks like we both got it right with options B, C, and E.

upvoted 0 times

...

Annmarie

2 days ago

It's important that your IP address is allowed to connect to the database.

upvoted 0 times

...

Lizbeth

6 days ago

Having a user in the database is crucial for querying the table.

upvoted 0 times

...

Ena

11 days ago

I agree, you definitely need SELECT access to the Products table.

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

3 months ago

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

upvoted 0 times

...

Thaddeus

3 months ago

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

upvoted 0 times

...