Question 780
Following the issue — A developer tries to rotate a SQL column encryption key by changing only the server-side schema without coordinating application clients. — the team takes this action: Follow the supported Always Encrypted key rotation and client deployment sequence. Which continuing safeguard BEST prevents the same control weakness from returning?
Explanation
Correct Answer
The recurring safeguard is: Test encrypted-column key rotations in staging before changing production. This mitigates the control weakness because: Client-side cryptography depends on coordinated keys, metadata and compatible application drivers. Keep the intervention, Follow the supported Always Encrypted key rotation and client deployment sequence., in the approved deployment, monitoring and change governance process.
Incorrect Answers
This safeguard is for the dependency described by: Shared access signatures grant delegated storage access according to their scope, permissions and expiry. The continuing risk here is determined by: Client-side cryptography depends on coordinated keys, metadata and compatible application drivers. The targeted safeguard is “Test encrypted-column key rotations in staging before changing production”.
That review protects the control associated with: A gateway can enforce consumer controls independently from the API's internal application code. It does not directly prevent the stated recurrence, which concerns: Client-side cryptography depends on coordinated keys, metadata and compatible application drivers. The appropriate guardrail is “Test encrypted-column key rotations in staging before changing production”.
This safeguard is for the dependency described by: Azure Storage uses encryption at rest even when an organization has not configured its own CMK. The continuing risk here is determined by: Client-side cryptography depends on coordinated keys, metadata and compatible application drivers. The targeted safeguard is “Test encrypted-column key rotations in staging before changing production”.