CV0-004 Cloud Architecture and Design Practice Question
A company is migrating a legacy application to the cloud. The application uses a relational database and requires strong consistency and ACID transactions. Which cloud service model is most appropriate?
⚠ Common exam trap
The trap here is assuming that IaaS with self-managed databases is necessary for ACID compliance, when in fact managed PaaS databases also provide strong consistency and transactional support.
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
✓
Platform as a Service (PaaS) with a managed relational database.
PaaS with a managed relational database is ideal because it provides a platform for the application while the managed database ensures ACID compliance and strong consistency. The company benefits from reduced operational overhead and can focus on the application, aligning with the migration goals.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Infrastructure as a Service (IaaS) with self-managed database servers.
Why it's wrong here
IaaS with self-managed database servers provides control but requires the company to handle patching, backups, and high availability, increasing operational overhead. While it can support ACID transactions, it is not the most appropriate because it lacks the managed benefits of PaaS, which would simplify management for a legacy application migration.
- ✗
Function as a Service (FaaS) with a serverless database.
Why it's wrong here
FaaS with a serverless database is designed for event-driven, short-lived functions, not for hosting a monolithic legacy application. Serverless databases may not support the required ACID transactions across multiple operations, and the execution model is not suitable for a persistent application. This model does not meet the requirements.
- ✗
Software as a Service (SaaS) with a built-in database.
Why it's wrong here
SaaS offers fully managed applications, but the company needs to migrate a legacy application, not adopt a new SaaS solution. SaaS typically does not allow customization of the underlying database or application logic, so it cannot host the legacy application as-is. This model is unsuitable for the scenario.
- ✓
Platform as a Service (PaaS) with a managed relational database.
Why this is correct
PaaS with a managed relational database provides a platform that handles infrastructure management while supporting relational databases with ACID compliance and strong consistency. This allows the company to focus on the application while ensuring the database meets its transactional requirements, making it the most appropriate model.
Go deeper
Related to this question
About these practice questions
This CV0-004 question is part of Courseiva's 834-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official CompTIA exam blueprint
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.