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.
NOTE: Each correct selection is worth one point.

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

B. You must have SELECT access to the Products table.

C. You must have a user in the database.

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

E. Your IP address must be allowed to connect to the database.






 

Suggested Answer: BCE

Incorrect Answers:
A, D: Resource group permissions is not required to query an Azure SQL database table.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/getting-started-with-database-engine-permissions?view=sql-server-ver15

This question is in DP-900 Microsoft Azure Data Fundamentals Exam
For getting Microsoft Certified: Azure Data Fundamentals Certificate



Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.