nerdexam
Microsoft

DP-900 · Question #81

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…

The correct answer is B. You must have SELECT access to the Products table. C. You must have a user in the database. E. Your IP address must be allowed to connect to the database. Incorrect Answers: A, D: Resource group permissions is not required to query an Azure SQL database table. https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/getting- started-with-database-engine-permissions?view=sql-server-ver15

Submitted by andreas_gr· Mar 30, 2026Identify considerations for relational data on Azure

Question

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.

Options

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

How the community answered

(32 responses)
  • A
    6% (2)
  • B
    81% (26)
  • D
    13% (4)

Explanation

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

Topics

#Azure SQL Database#firewall rules#database permissions#access control

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-900 Practice