Skip to content

SC-500 practice question 7: Data and networking

An Azure SQL database must reject connections from the internet and accept them only from an application in a virtual network. Which control does this?

The options

  • A. Adding the database administrator to the Contributor role on the subscription
  • B. A private endpoint for the SQL server, with public network access disabled
  • C. Leaving the server firewall open to all addresses
  • D. Renaming the database

Answer and why

The correct answer is B: A private endpoint for the SQL server, with public network access disabled

A. A role assignment does not limit network reachability.

B. Private connectivity keeps database traffic inside the virtual network.

C. An open firewall accepts connections from anywhere.

D. A name is not a control.

What Data and networking tests

Secure storage, databases and networking is the heaviest domain at 29%. It covers storage access and encryption, database protection and network controls such as private endpoints and network security groups. Prefer private connectivity and identity-based access over keys and public endpoints.

Secure storage, databases, and networking is 29% of the SC-500 exam. The exam runs 120 minutes and Microsoft publishes no fixed question count, so this question is a slice of the real mix, not a prediction of your result.

Try these next

Each one is a free question from the same practice test, with the answer and the reason for every option on its own page.

Keep going

This is question 7 of 15 in the free SC-500 practice test. If you missed it, say why in one sentence before you read on: the reason is what transfers to a differently worded question.