ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 149 - DP-900 discussion

Report
Export

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.

A.
You must be assigned the Reader role for the resource group that contains the database.
Answers
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.
Answers
B.
You must have SELECT access to the Products table.
C.
You must have a user in the database.
Answers
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.
Answers
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.
Answers
E.
Your IP address must be allowed to connect to the database.
Suggested answer: B, C, E

Explanation:

Section: Describe how to work with relational data on Azure

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

asked 02/10/2024
Joseph McCray
43 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first