Exam: DP-900: Microsoft Azure Data Fundamentals 0 Likes
You need to query a table named Products in an Azure SQL database (DP-900)
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.
Solution
Correct answer: 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.
These requirements ensure that you have the necessary permissions to access the table (SELECT access), a valid user account in the database, and that your IP address is allowed to connect to the database, which is a security feature to prevent unauthorized access.
Category: Identify considerations for relational data on Azure