Question 340
An Azure SQL database can be reached from any public IP because default networking was accepted. Which security architecture decision most directly satisfies the stated requirement?
Explanation
Correct Answer
require private endpoint connectivity and deny unnecessary public SQL network access. This is the most relevant choice because Private connectivity limits exposure of platform data services. An acceptance test should demonstrate that an unapproved public client connection fails while the private application path works.
Incorrect Answers
It addresses a neighboring control requirement, not this one: A company deploys an internet-facing Azure App Service with no restriction on management endpoints. PaaS management surfaces require explicit authorization despite managed hosting. The present scenario specifically needs an unapproved public client connection fails while the private application path works.
That recommendation concerns A web API stores connection strings in application code and logs exception values. Managed PaaS does not automatically protect application-owned secrets. Here the required proof is that an unapproved public client connection fails while the private application path works.
This measure is suited to a different threat model: A platform team deploys Azure Functions that can invoke unrestricted resource-management APIs. Serverless functions still need narrowly scoped workload identities. It does not directly establish that an unapproved public client connection fails while the private application path works.