Question 820
While validating an Azure workload, the security team finds: An app connects to SQL using an old driver that ignores certificate validation, allowing a man-in-the-middle risk despite nominal encryption. Which condition most directly explains the failure?
Explanation
Correct Answer
The described technical condition is: Encrypted SQL transport without trusted server certificate validation can leave client identity vulnerable to spoofing. The appropriate corrective action is: Configure supported SQL driver encryption with certificate chain and hostname validation enabled. Confirm with: The client connects only to the legitimate database endpoint and rejects an untrusted test certificate.
Incorrect Answers
Azure SQL auditing has not been enabled or delivered to an appropriate storage or Log Analytics destination. “Enable supported SQL auditing with the necessary categories and protected retention settings” would address that alternative cause, not the condition in this question: encrypted SQL transport without trusted server certificate validation can leave client identity vulnerable to spoofing.
“Verify and enable supported SQL Transparent Data Encryption with the approved key management configuration” responds to this separate finding: tLS encrypts data in transit and does not replace database storage encryption provided by Transparent Data Encryption. This question instead needs “Configure supported SQL driver encryption with certificate chain and hostname validation enabled”, so the alternative does not meet the stated condition.
The SQL server or managed instance has not enabled and governed the intended Microsoft Entra database authentication. “Configure the Microsoft Entra administrator and create appropriate contained database users and roles” applies to that separate problem. The observed case is an app connects to SQL using an old driver that ignores certificate validation, allowing a man-in-the-middle risk despite nominal encryption; choosing this alternative would address the wrong failure mode.