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

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

21 days ago

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

upvoted 0 times

...

Aileen

27 days ago

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

upvoted 0 times

...

Thaddeus

29 days ago

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

upvoted 0 times

...