Question 250
Application connections to an Azure SQL endpoint sometimes downgrade because clients ignore certificate errors. The team proposes this approach: Enforce encrypted connections with trusted certificate validation on supported clients. Which technical principle supports this approach?
Explanation
Correct Answer
TLS certificate validation is essential for authenticating endpoints and protecting data in transit. Encryption in transit does not control what an authorized client does with decrypted data.
Incorrect Answers
That explanation assumes the wrong technical cause: Confidentiality in transit needs both encryption and authenticated trusted certificate verification.
The proposed mechanism is not sufficient because IP reachability does not prove endpoint authenticity; validate hostname and certificate chain with compatible drivers.
This inference does not follow from the SQL or service behavior: Drivers and connection strings are part of the boundary; test failure on invalid certificates for every supported client. The stated assumption would still allow the documented defect to occur, so it cannot explain why the proposed fix works.