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.
- A storage account holds sensitive blobs and must be reachable only from a virtual network, with no exposure to the public internet. What should be configured?
- A developer needs to give a partner time-limited read access to one blob without sharing the account key. Which approach is best?
- A team wants to filter inbound traffic to a subnet by source, port and protocol, with explicit allow and deny rules. Which Azure feature should be used?
- An Azure web app must read a secret from Azure Key Vault without any password or key stored in its configuration. What is the best approach?
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.