Question 720
Following the issue — A regulated column must remain hidden from SQL server administrators but the team proposes only TDE. — the team takes this action: Evaluate Always Encrypted with appropriate client-side driver support and key management. Which continuing safeguard BEST prevents the same control weakness from returning?
Explanation
Correct Answer
The recurring safeguard is: Validate Always Encrypted client compatibility before adopting protected columns. This mitigates the control weakness because: Always Encrypted can protect eligible sensitive column values from server-side plaintext exposure. Keep the intervention, Evaluate Always Encrypted with appropriate client-side driver support and key management., in the approved deployment, monitoring and change governance process.
Incorrect Answers
This safeguard is for the dependency described by: Container configuration and operator privileges affect exposure of sensitive runtime secrets. The continuing risk here is determined by: Always Encrypted can protect eligible sensitive column values from server-side plaintext exposure. The targeted safeguard is “Validate Always Encrypted client compatibility before adopting protected columns”.
“Review SAS expiration and permission breadth before sharing storage links” addresses a different recurring failure: Shared access signatures grant delegated storage access according to their scope, permissions and expiry. For the condition in this question, maintain “Validate Always Encrypted client compatibility before adopting protected columns” because always Encrypted can protect eligible sensitive column values from server-side plaintext exposure.
This safeguard is for the dependency described by: Container vulnerabilities can exist in workloads even when host nodes are up to date. The continuing risk here is determined by: Always Encrypted can protect eligible sensitive column values from server-side plaintext exposure. The targeted safeguard is “Validate Always Encrypted client compatibility before adopting protected columns”.