Question 20
A payroll SQL table contains salaries that database administrators should not read in plaintext. The team proposes this approach: Encrypt payroll columns using managed client-side keys and test authorized application access. Which technical principle supports this approach?
Explanation
Correct Answer
Always Encrypted can keep supported sensitive column values encrypted at the client and protected from server-side plaintext access. Unsupported operations and key rotation require careful application design.
Incorrect Answers
TDE protects files at rest, not SELECT plaintext for DBAs; client-side column encryption needs supported drivers and operation testing.
Presentation masks are not encryption; the stated threat model requires DBA-inaccessible plaintext via client-held keys.
Keys must be used by a supported encrypted-column design; vault inventory alone does not protect data or remove operational limits.