Microsoft Azure Data Fundamentals — Question 96

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.

Answer options

• 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.

Correct answer: B, C, E

Explanation

The correct answers are B, C, and E because you need SELECT access to the Products table (B), a user in the database to authenticate (C), and your IP address must be whitelisted to connect (E). Options A and D are not required for querying the table but pertain to role permissions that do not directly affect access for querying.