Skip to content

Interview question · Application & API Security

Compare disk, transparent, column-level and application-level encryption for databases: what does each actually protect against?

Every database encryption option protects against someone. The question is whether it protects against the attacker you are worried about, and most only stop thieves of disks and backups.

mediumNewPreparation tags: Amazon, Microsoft, GoogleUpdated Nov 2026

Every database encryption option protects against someone. The question is whether it protects against the attacker you are worried about, and most only stop thieves of disks and backups.

Make your first attempt

What would you say before reading the answer?

  1. 01 State the assumptions your answer depends on.
  2. 02 Explain the mechanism and choose a control.
  3. 03 Name a condition that would change your decision.

The worked answer includes an approach, scoring criteria and follow-up questions. Compare the reasoning with your own.

10 answers per topic instead of 5, plus saved progress and bookmarks · costs nothingor unlock all 529 remaining answers · $25

Every worked answer in all 17 topics, every lesson in every course, the full concept curriculum, the complete practice-test bank, and the downloadable security field guides.

6 months · One payment · No auto-renewal

What if · the follow-ups in this answer

The answer works through 6 follow-ups like an interviewer would

A healthcare app's auditors ask how patient records are protected if the database administrator account is compromised.

  1. What does disk or storage encryption protect against?
  2. What does transparent data encryption add?
  3. What about column-level encryption in the engine?
  4. What protects against a compromised database admin?
  5. What are the trade-offs?
  6. How would you answer the auditors?

Each rung has a nudge, a model answer, the principle that carries over and the weak answer to avoid. Premium opens every answer and ladder.

UP NEXT ON YOUR JOURNEY
DISCUSSION · 0

No comments yet. Share a correction or a different way to answer it.