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.
Click on the arrows to vote for the correct answer
A. B. C. D. E.BCE
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-ver15To query a table named Products in an Azure SQL database from the internet, there are three requirements that must be met:
A. You must be assigned the Reader role for the resource group that contains the database: The Reader role grants you read-only access to all resources in the resource group. This role is sufficient to query the database but does not allow you to make any changes to the resources.
B. You must have SELECT access to the Products table: SELECT access is required to query a specific table in the database. Without this access, you will not be able to retrieve any data from the table.
C. You must have a user in the database: To access the database, you need to have a user account that is associated with the database. This account provides authentication and authorization for accessing the data.
D. You must be assigned the Contributor role for the resource group that contains the database: The Contributor role grants you permissions to create and manage all resources in the resource group, including the database. This role is not required for querying the database but is needed if you need to make any changes to the resources.
E. Your IP address must be allowed to connect to the database: By default, Azure SQL database firewall rules block all incoming traffic from outside Azure. Therefore, you need to configure the firewall to allow connections from your IP address or range of IP addresses. This configuration can be done in the Azure portal or by using the Azure SQL database REST API.
In summary, to query a table named Products in an Azure SQL database from the internet, you need to have the Reader role for the resource group, SELECT access to the Products table, a user account in the database, and your IP address must be allowed to connect to the database. The Contributor role is not required for querying the database but is needed if you need to make any changes to the resources.