mediumMultiple ChoiceObjective-mapped
CV0-004 Practice Question: A healthcare organization uses a cloud-based…
A healthcare organization uses a cloud-based virtual private cloud (VPC) to host a web application that processes protected health information (PHI). The application consists of a public-facing load balancer, a web server tier in a public subnet, and a database tier in a private subnet. The database runs on a managed relational database service with encryption at rest enabled using a cloud provider-managed key. The security auditor requires that the database encryption key must be controlled by the organization and rotated every 90 days. Additionally, the database must only be accessible from the web server tier. The database is currently accessible from the entire VPC CIDR block. What should the cloud administrator do to meet these requirements?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Re-encrypt the database using a customer-managed key in the cloud provider's key management service, and update the database security group to only allow traffic from the web server security group.
It addresses both requirements: re-encrypting the database with a customer-managed key in the cloud provider's KMS allows the organization to control and rotate the key every 90 days, and updating the database security group to only allow traffic from the web server security group restricts access to only the web server tier. Option A is incorrect because exporting and re-importing the database is unnecessary and disabling encryption is not recommended; re-encrypting in place is the proper approach. Option B is incorrect because provider-managed keys do not give the organization control or the ability to rotate the key as required. Option D is incorrect because encrypting the web server's storage does not address database encryption or access control requirements.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Export the database, disable encryption, and import into a new database with a customer-managed key.
Why it's wrong here
Unencrypted data is not acceptable for PHI.
- ✗
Enable encryption with a provider-managed key and restrict database access using a network ACL.
Why it's wrong here
Provider-managed keys do not allow customer control or rotation.
- ✓
Re-encrypt the database using a customer-managed key in the cloud provider's key management service, and update the database security group to only allow traffic from the web server security group.
Why this is correct
Customer-managed keys allow rotation, and security groups restrict access to the web tier only.
- ✗
Encrypt the web server's storage with a customer-managed key and keep the database encryption as is.
Why it's wrong here
This does not address the database encryption and access control requirements.
Visual reference
Go deeper
Related to this question
About these practice questions
Courseiva writes every CV0-004 question from scratch — 977 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This CV0-004 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the CV0-004 exam.