- A
Flyway, integrated into the CI/CD pipeline to run database migrations as part of the application deployment.
Flyway is a well-known database migration tool that can be integrated into CodePipeline for versioned schema changes.
- B
AWS Database Migration Service (DMS) to continuously replicate schema changes from the source Oracle database.
Why wrong: DMS is for data migration, not for managing schema versions in a new database.
- C
AWS CloudFormation with custom resource Lambda functions to run SQL scripts.
Why wrong: CloudFormation is for infrastructure, not a standard database schema migration tool; custom resources add complexity.
- D
AWS CLI scripts executed in CodeBuild to run SQL commands against the target databases.
Why wrong: Manual scripts are error-prone and not a best-practice for automated schema versioning.
Quick Answer
The answer is Flyway, integrated into the CI/CD pipeline to run database migrations as part of the application deployment. This is the correct choice because Flyway is a version-controlled database migration tool that applies schema changes sequentially, ensuring each microservice’s separate Amazon RDS for PostgreSQL database stays in sync with its application code. In a CI/CD pipeline using AWS CodePipeline and CodeBuild, Flyway runs as a build step or container, automating schema updates without manual intervention—critical for a microservices architecture where each service owns its database. On the AWS Certified Solutions Architect Professional SAP-C02 exam, this scenario tests your understanding of database modernization patterns, often contrasting Flyway (which integrates into the pipeline) against manual scripts or AWS DMS (which handles data migration, not schema versioning). A common trap is choosing a data migration tool like DMS for schema changes; remember, Flyway is for schema versioning, DMS is for data replication. Memory tip: Flyway flies your schema forward with code.
SAP-C02 Practice Question: Accelerate Workload Migration and Modernization
This SAP-C02 practice question tests your understanding of accelerate workload migration and modernization. Match the stated requirement to the specific cloud service, access model, or configuration option — many options are valid in isolation but not for this scenario. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
A company is migrating a monolithic Java application to AWS. The current architecture uses a single Oracle database. The migration plan is to refactor the application into microservices and use separate Amazon RDS for PostgreSQL databases per service. The company also wants to implement a CI/CD pipeline using AWS CodePipeline and AWS CodeBuild. Which tool should the company use to automate the database schema changes for each microservice?
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
Flyway, integrated into the CI/CD pipeline to run database migrations as part of the application deployment.
Flyway is a database migration tool that integrates directly into CI/CD pipelines, allowing schema changes to be version-controlled and applied automatically during application deployment. For a microservices architecture with separate PostgreSQL databases, Flyway can manage each service's schema independently, ensuring consistency and rollback capability. This aligns with the requirement to automate schema changes per microservice as part of the migration and modernization effort.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Flyway, integrated into the CI/CD pipeline to run database migrations as part of the application deployment.
Why this is correct
Flyway is a well-known database migration tool that can be integrated into CodePipeline for versioned schema changes.
Related concept
Read the scenario before looking for a memorised answer.
- ✗
AWS Database Migration Service (DMS) to continuously replicate schema changes from the source Oracle database.
Why it's wrong here
DMS is for data migration, not for managing schema versions in a new database.
- ✗
AWS CloudFormation with custom resource Lambda functions to run SQL scripts.
Why it's wrong here
CloudFormation is for infrastructure, not a standard database schema migration tool; custom resources add complexity.
- ✗
AWS CLI scripts executed in CodeBuild to run SQL commands against the target databases.
Why it's wrong here
Manual scripts are error-prone and not a best-practice for automated schema versioning.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates may confuse data migration tools (like AWS DMS) with schema migration tools, or assume that any scripting approach (like AWS CLI) is sufficient, overlooking the need for version control, repeatability, and integration with application deployment pipelines that Flyway provides.
Detailed technical explanation
How to think about this question
Flyway uses a versioned migration approach where each schema change is a numbered SQL script (e.g., V1__initial.sql, V2__add_column.sql) stored in the application repository. It maintains a metadata table (flyway_schema_history) in the target database to track which migrations have been applied, ensuring idempotent and incremental updates. In a CI/CD pipeline, Flyway can be executed as a CodeBuild build step or via a CodePipeline action, applying migrations only when the corresponding microservice is deployed, which prevents schema drift across services.
KKey Concepts to Remember
- Read the scenario before looking for a memorised answer.
- Find the constraint that changes the correct option.
- Eliminate answers that are true in general but not in this case.
TExam Day Tips
- Watch for words such as best, first, most likely and least administrative effort.
- Review why wrong options are wrong, not only why the correct option is correct.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
How this comes up in practice
A cloud solutions architect for a retail company is evaluating services for a new workload. The correct answer here reflects best practice for the specific scenario described — not a general cloud recommendation. Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option. Cloud exam questions reward reading the constraint carefully: the same technology can be right or wrong depending on the use case.
What to study next
Got this wrong? Here's your next step.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
- →
Accelerate Workload Migration and Modernization — study guide chapter
Learn the concepts, then practise the questions
- →
Accelerate Workload Migration and Modernization practice questions
Targeted practice on this topic area only
- →
All SAP-C02 questions
1,746 questions across all exam domains
- →
AWS Certified Solutions Architect Professional SAP-C02 study guide
Full concept coverage aligned to exam objectives
- →
SAP-C02 practice test guide
How to use practice tests most effectively before exam day
Related practice questions
Related SAP-C02 practice-question pages
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
Design Solutions for Organizational Complexity practice questions
Practise SAP-C02 questions linked to Design Solutions for Organizational Complexity.
Design for New Solutions practice questions
Practise SAP-C02 questions linked to Design for New Solutions.
Continuous Improvement for Existing Solutions practice questions
Practise SAP-C02 questions linked to Continuous Improvement for Existing Solutions.
Accelerate Workload Migration and Modernization practice questions
Practise SAP-C02 questions linked to Accelerate Workload Migration and Modernization.
SAA-C03 VPC practice questions
Practise SAP-C02 questions linked to SAA-C03 VPC.
SAA-C03 S3 lifecycle policy questions
Practise SAP-C02 questions linked to SAA-C03 S3 lifecycle policy questions.
SAA-C03 RDS Multi-AZ questions
Practise SAP-C02 questions linked to SAA-C03 RDS Multi-AZ questions.
SAA-C03 IAM policy practice questions
Practise SAP-C02 questions linked to SAA-C03 IAM policy.
SAA-C03 Route 53 failover questions
Practise SAP-C02 questions linked to SAA-C03 Route 53 failover questions.
SAA-C03 CloudFront practice questions
Practise SAP-C02 questions linked to SAA-C03 CloudFront.
SAA-C03 NAT gateway questions
Practise SAP-C02 questions linked to SAA-C03 NAT gateway questions.
SAA-C03 VPC endpoint questions
Practise SAP-C02 questions linked to SAA-C03 VPC endpoint questions.
Practice this exam
Start a free SAP-C02 practice session
Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.
FAQ
Questions learners often ask
What does this SAP-C02 question test?
Accelerate Workload Migration and Modernization — This question tests Accelerate Workload Migration and Modernization — Read the scenario before looking for a memorised answer..
What is the correct answer to this question?
The correct answer is: Flyway, integrated into the CI/CD pipeline to run database migrations as part of the application deployment. — Flyway is a database migration tool that integrates directly into CI/CD pipelines, allowing schema changes to be version-controlled and applied automatically during application deployment. For a microservices architecture with separate PostgreSQL databases, Flyway can manage each service's schema independently, ensuring consistency and rollback capability. This aligns with the requirement to automate schema changes per microservice as part of the migration and modernization effort.
What should I do if I get this SAP-C02 question wrong?
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
What is the key concept behind this question?
Read the scenario before looking for a memorised answer.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Last reviewed: Jun 11, 2026
This SAP-C02 practice question is part of Courseiva's free Amazon Web Services 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 SAP-C02 exam.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.