Skip to content

All certifications

CAS-005 question of the day

Question for 2026-11-17. Domain: Security Engineering. Objective 3.8: Cryptographic use cases. Original SecLern question, written for practice.

Database administrators must be able to manage a payments database without being able to read card numbers. Which design is BEST?

Show the explanation

Column-level encryption with external keys protects data from privileged database users.

Each option

  • A. Administrators can read data through the running database. It would be right for stolen disks.
  • B. A password does not hide the data. It would be right for account protection.
  • C. A banner does not restrict reading. It would be right for legal notice.
  • D (correct). Correct: Without the key, administrators see only ciphertext.

What this question tests

It maps to CAS-005 objective 3.8, Cryptographic use cases: Given a scenario, apply the appropriate cryptographic use case and/or technique. Related ideas: data at rest.

The published topics under this objective, so you can check what you have covered:

  • Use cases: Data at rest, Data in transit, Data in use/processing, Secure email
  • Techniques: Tokenization, Code signing, Cryptographic erase/obfuscation, Digital signatures

More from the archive

Start a daily session

Several questions at a time, aimed at your gaps.