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
- 2026-11-03: A retailer's analytics systems need to join records by card number but never need the real number. The company wants to remove them from the scope of card data requirements. Which technique is BEST?
- 2026-11-04: A pipeline checks that Kubernetes manifests are valid YAML, and every manifest passes. One of them sets privileged: true for a container. Which addition is BEST?
- 2026-11-05: A firewall's events are collected both by an agent and by syslog forwarding. Counts are doubled and some alerts fire twice. Which action is BEST?
- 2026-11-06: An administrator who always signs in from the head office between 08:00 and 17:00 signs in at 03:00 from a new country and immediately lists all file shares. Which response is BEST?
- 2026-11-07: Which condition describes a log source that has silently stopped sending events to the SIEM?
- 2026-11-08: Which characteristic describes devices with very little processing power, memory and energy, so they cannot run security agents or strong cryptography?
- 2026-11-09: A server that normally runs no jobs after 18:00 starts new scheduled tasks at 03:00 and contacts an unfamiliar external host. What is the NEXT step?
- 2026-11-10: Battery-powered sensors cannot run TLS. The data they send crosses an office network to a cloud service. Which design is BEST?
- 2026-11-11: A company sets SIEM retention by asking what disk space costs. An investigation finds a breach that began 8 months ago, but only 90 days of logs exist. Which approach is BEST?
- 2026-11-12: A production database engine is out of support. Migration will take 14 months. The vendor sells extended security updates by the month for it. Which plan is BEST?
- 2026-11-13: A security team plans to buy machine learning analytics for its SIEM. About 30 percent of incoming events fail to parse, and several important log sources are not reporting. Which approach is BEST?
- 2026-11-14: Microservices in a cluster exchange personal data, and the company wants every service-to-service call to be encrypted and authenticated without changing application code. Which approach is BEST?
- 2026-11-15: A building system's management console cannot be updated. It presents the certificate below, and modern clients reject it. ``` Server certificate: Signature algorithm: sha1WithRSAEncryption Public key: RSA 1024 bit Valid: 2013-02-01 to 2023-02-01 Client alert: certificate expired; weak signature algorithm ``` Which approach is BEST?
- 2026-11-16: A domain controller stopped sending logs to the SIEM three days ago, and nobody noticed until an investigation. Which control is BEST?
Start a daily session
Several questions at a time, aimed at your gaps.