Question 220
An Azure SQL operations team investigates: A network engineer opens broad public firewall rules in response to a database permission-denied error. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.
Explanation
Correct Answers
The reported Azure SQL or SQL Server condition is: A network engineer opens broad public firewall rules in response to a database permission-denied error. The specific supported administrative response is: Separate network reachability, token validity, tenant identity, database mapping and SQL permission problems when troubleshooting failed authentication. The technical risk is: Treating every database error as a firewall block can conceal authentication and access-control faults. Confirm the correction with: Connection logs and controlled tests identify whether the failure occurs at network, authentication or authorization stage.
The acceptance evidence for this incident (A network engineer opens broad public firewall rules in response to a database permission-denied error.) is: Connection logs and controlled tests identify whether the failure occurs at network, authentication or authorization stage. It directly tests whether the remediation (Separate network reachability, token validity, tenant identity, database mapping and SQL permission problems when troubleshooting failed authentication.) solves the specified issue, instead of proving an unrelated database control works.
Incorrect Answers
Azure SQL private endpoints and public exposure (2.2) would demonstrate or implement: Inside-VNet DNS resolves the intended private endpoint, allowed clients connect and prohibited public access fails. This choice can be useful for that problem, but it does not establish the Diagnosing login and token failures (2.1) control being assessed here.
Always encrypted secure enclave workloads (2.2) addresses another technical failure: Assuming all encrypted-column operations work without enclave support can cause unsupported queries or unexpected decryption behavior. The required paired action and test concerns Diagnosing login and token failures (2.1); a passing result for this alternative could leave that requirement unresolved.
SQL authentication management on SQL server vms (2.1) addresses another technical failure: Poorly governed shared SQL logins are hard to rotate and can bypass centralized identity lifecycle management. The paired-answer requirement concerns Diagnosing login and token failures (2.1); this alternative does not provide the matching intervention and separate acceptance evidence.