🔥 40% Off Crucial Exams Memberships — This Week Only

2 days, 12 hours remaining!
Crucial Exams

ISC2 Systems Security Certified Practitioner (SSCP) Practice Question

Your team is designing an Amazon RDS PostgreSQL database to store protected health information (PHI). Compliance rules mandate that data must remain confidential on disk and that any unauthorized modification must be detectable when records are read. The solution should minimize performance overhead at scale. Which approach best meets both confidentiality and integrity requirements?

  • Rely on security groups and IAM policies to restrict access; store records in plaintext to avoid performance impact.

  • Encrypt each record with an RSA public key and sign it with the corresponding private key before storage.

  • Encrypt each record with AES-256 and store an HMAC of the ciphertext generated with a secret key kept in AWS KMS.

  • Store only a SHA-1 hash of each record in the database to detect tampering and avoid the need for encryption.

ISC2 Systems Security Certified Practitioner (SSCP)
Cryptography
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot