SAP-C02 Accelerate Workload Migration and Modernization — Timed 15 Questions

Question 1

A company is planning to modernize a legacy Java application that runs on a single on-premises server. The application uses a proprietary file-based storage system. The company wants to migrate to AWS with the following goals: reduce operational overhead, improve availability, and minimize code changes. Which TWO strategies should the company use? (Choose two.)

15 minute time limit — choose an answer to begin.

Accepted Answer

Use AWS Application Migration Service (MGN) to migrate the application server to Amazon EC2. AWS Application Migration Service (MGN) enables lift-and-shift of the application server to Amazon EC2 with minimal code changes, reducing operational overhead. Amazon EFS provides a managed NFS file system that can replace the proprietary file-based storage without code modifications, improving availability. Option D (RDS) is incorrect because migrating file-based data to a relational database would require significant application changes, contradicting the goal of minimizing code changes.

Answer

Migrate the proprietary storage to Amazon S3

Answer

Migrate the proprietary storage to Amazon RDS for PostgreSQL

Answer

Refactor the application into microservices and deploy on Amazon EKS

Question 2

A company is migrating a 2 TB Oracle database to Amazon Aurora PostgreSQL. The database has frequent write operations and the migration must have minimal downtime. The team uses AWS DMS for ongoing replication. After the initial full load, the target Aurora instance becomes unresponsive during ongoing replication. What is the MOST likely cause?

Accepted Answer

The number of logical replication slots on the Aurora PostgreSQL instance exceeds the maximum supported.. The most likely cause is that the number of logical replication slots on the Aurora PostgreSQL instance exceeds the maximum supported. While AWS DMS itself does not create replication slots on the target Aurora instance, multiple DMS tasks or other replication processes can create slots on the target. Aurora PostgreSQL has a default limit of 1 slot for Aurora Serverless v1 or a configurable limit for provisioned instances. Exceeding this limit can cause resource contention and make the instance unresponsive during ongoing replication.

Answer

The DMS task is configured to replicate DDL changes, which are not supported for Oracle to Aurora PostgreSQL.

Answer

The DMS task is using full LOB mode, which is not supported with ongoing replication.

Answer

The target Aurora instance's storage is full and cannot accept new writes.

Question 3

A company is planning to migrate a legacy application to AWS. The application requires a fixed IP address that clients whitelist. The company wants to achieve high availability across two Availability Zones. Which architecture should they use?

Accepted Answer

Network Load Balancer (NLB) with Elastic IPs attached to each subnet. (NLB with Elastic IPs) is correct because NLB supports static IP addresses via Elastic IPs attached per subnet, enabling fixed IP whitelisting across AZs. Option A (AWS Global Accelerator with ALB) provides two static IPs from Global Accelerator but adds complexity and cost; the ALB itself uses a DNS name. Option C (Classic Load Balancer) does not support Elastic IPs per AZ effectively, using a DNS name instead. Option D (ALB) provides only a DNS name, not fixed IPs.

Answer

AWS Global Accelerator with Application Load Balancer

Answer

Classic Load Balancer with Elastic IPs

Answer

Application Load Balancer (ALB) with EC2 instances

Question 4

A company is migrating an e-commerce website to AWS. The website has a MySQL database. The company wants to automate the migration of the database schema and data. Which AWS service should they use?

Accepted Answer

AWS Database Migration Service (DMS). (AWS Database Migration Service) is correct because it automates data migration and can convert schema using SCT. Option A (AWS Glue) is for ETL, not database migration. Option C (AWS Data Pipeline) is for data processing. Option D (AWS Schema Conversion Tool) converts schema but does not migrate data.

Answer

AWS Glue

Answer

AWS Data Pipeline

Answer

AWS Schema Conversion Tool (SCT)

Question 5

A company is planning to migrate its on-premises Oracle database to Amazon RDS for Oracle. The database is 2 TB in size and the company has a high-speed network connection to AWS. Which AWS service should the company use to migrate the database with minimal downtime?

Accepted Answer

AWS Database Migration Service (DMS). AWS DMS supports Oracle to RDS for Oracle migration with ongoing replication for minimal downtime. Option A is incorrect because S3 Transfer Acceleration is used for accelerating uploads to S3, not for database migration. Option C is incorrect because Snowball Edge is for offline data transfer and not suitable for databases with minimal downtime. Option D is incorrect because AWS Schema Conversion Tool (SCT) is used for schema conversion, not data migration.

Answer

Amazon S3 Transfer Acceleration

Answer

AWS Snowball Edge

Answer

AWS Schema Conversion Tool (SCT)

Question 6

A company is migrating a large Oracle database to Amazon Aurora PostgreSQL. The migration must have minimal downtime and support ongoing replication. Which THREE steps should the company take?

Accepted Answer

Use AWS Database Migration Service (DMS) with change data capture (CDC) to replicate ongoing changes.. AWS DMS can perform live migration from Oracle to Aurora PostgreSQL with minimal downtime using change data capture (CDC). Option D is correct because the AWS Schema Conversion Tool (SCT) is used to convert the Oracle schema to a PostgreSQL-compatible schema before migration. The unlabeled first option is correct because provisioning sufficient compute and storage for the Aurora PostgreSQL instance ensures it can handle the migration load without performance issues. Option B is wrong because AWS SCT is for schema conversion, not data migration. Option C is wrong because converting the entire database first defeats the purpose of using DMS for minimal downtime; DMS handles the data type conversion automatically. Option E is wrong because taking the source offline would cause downtime, which contradicts the requirement for minimal downtime.

Answer

Use AWS Schema Conversion Tool (SCT) to perform the data migration.

Answer

Convert the Oracle database to PostgreSQL first, then use AWS DMS for a homogeneous migration.

Answer

Take the source Oracle database offline to ensure data consistency during the migration.

Question 7

A company is modernizing a legacy application by refactoring it into microservices. The application uses a monolithic database. The company wants to adopt a microservices architecture with independent data stores. What pattern should the company use?

Accepted Answer

Database per Service. The Database per Service pattern ensures that each microservice owns its own data, promoting loose coupling and allowing independent scaling and technology choices. Option A is incorrect because a data lake with Amazon S3 is designed for analytics and large-scale storage, not for transactional microservices data stores. Option B is incorrect because a centralized database with an API layer still creates a single point of coupling and does not give each service its own data store. Option D is incorrect because a shared database with read replicas still uses a single database schema, which tightly couples the services.

Answer

Data lake with Amazon S3

Answer

Centralized database with an API layer

Answer

Shared database with read replicas

Question 8

A company is deploying a web application using the above CloudFormation template. The template fails to create the Auto Scaling group. What is the most likely cause?

Accepted Answer

The LaunchConfiguration resource type is incorrect.. The launch configuration uses the wrong resource type (AWS::AutoScaling::AutoScalingGroup) instead of AWS::AutoScaling::LaunchConfiguration. Option A is wrong because t2.micro is a valid instance type. Option B is wrong because MinSize=2 is valid and does not need to be less than DesiredCapacity; in fact, DesiredCapacity must be between MinSize and MaxSize. Option D is wrong because AvailabilityZones can be specified by names (e.g., us-east-1a) and are valid.

Answer

The instance type t2.micro is not supported in us-east-1.

Answer

The MinSize value must be less than the DesiredCapacity.

Answer

The AvailabilityZones list is invalid because it uses names instead of zone IDs.

Question 9

Refer to the exhibit. A company is using AWS Migration Hub to track database migration tasks. The migration task for 'app-server-01' has failed. The progress update stream is 'DMS'. Which AWS service is most likely responsible for the migration failure?

Accepted Answer

AWS Database Migration Service (DMS). The progress update stream 'DMS' indicates that the task is associated with AWS Database Migration Service (DMS). DMS is used for database migrations. AWS Application Migration Service (CloudEndure) would use a different stream. Server Migration Service (SMS) is deprecated. CloudEndure and SMS are for server migration, not database.

Answer

AWS Application Migration Service (CloudEndure)

Answer

AWS Server Migration Service (SMS)

Answer

AWS CloudEndure Migration

Question 10

A company is migrating a critical application to AWS using the 7 Rs migration strategy. The application is tightly coupled with legacy infrastructure and has compliance requirements that prevent any code changes. The migration must be completed in 3 months. Which strategy is most appropriate?

Accepted Answer

Rehost using AWS Application Migration Service (MGN) and Amazon EC2.. Rehosting (lift-and-shift) using AWS Application Migration Service (MGN) and EC2 meets the no-code-change requirement and can be completed within 3 months. Option A is wrong because retaining the application on-premises does not migrate it to AWS, failing the migration goal. Option C is wrong because replatforming to Amazon RDS would likely require code changes (e.g., database drivers, queries), violating the no-code-change constraint. Option D is wrong because refactoring into microservices requires significant code changes and is too time-consuming for the 3-month timeline.

Answer

Retain the application on-premises and use AWS Storage Gateway for backup.

Answer

Replatform to use Amazon RDS for MySQL.

Answer

Refactor into microservices on Amazon ECS.

Question 11

A company is migrating a legacy Oracle database to Amazon Aurora PostgreSQL. The migration must minimize downtime and support ongoing replication. Which AWS service should the company use?

Accepted Answer

AWS Database Migration Service (DMS) with change data capture (CDC). B is correct because AWS DMS with ongoing replication (CDC) can migrate data with minimal downtime. A is wrong because AWS DataSync is designed for file-based data transfers, not database replication. C is wrong because AWS Direct Connect provides a dedicated network connection but does not handle database migration or replication. D is wrong because the AWS Schema Conversion Tool (SCT) only converts schema and code, not the actual data.

Answer

AWS DataSync

Answer

AWS Direct Connect

Answer

AWS Schema Conversion Tool (SCT)

Question 12

A company is migrating a legacy Java application to AWS. The application currently runs on a single on-premises server and uses a MySQL database. The company wants to modernize the application by decoupling components and improving scalability. Which THREE steps should the architect include in the migration plan?

Accepted Answer

Place an Application Load Balancer in front of the application. Migrating the database to Amazon RDS for MySQL reduces operational overhead and provides high availability. Placing an Application Load Balancer in front of the application distributes traffic across multiple instances, improving scalability. Refactoring the application into microservices and deploying on Amazon ECS with Fargate enables decoupling of components, independent scaling, and reduces infrastructure management. These three steps together modernize the application and improve scalability. Option A (rewriting to NoSQL in a single migration step) is too risky because it changes both the database technology and requires significant application code changes. Option D (deploying on a single larger EC2 instance) does not improve scalability as it remains a single point of failure and cannot scale horizontally.

Answer

Rewrite the application to use a NoSQL database in a single migration step

Answer

Deploy the application on a single larger EC2 instance

Question 13

A company is migrating its on-premises file server to AWS. The file server contains 5 TB of data and is accessed by hundreds of users. The company wants a fully managed file storage solution that supports SMB protocol. Which AWS service should the architect consider?

Accepted Answer

Amazon FSx for Windows File Server. The two services that meet the requirements are Amazon FSx for Windows File Server and AWS Storage Gateway File Gateway. Amazon FSx for Windows File Server is a fully managed native Windows file system that supports the SMB protocol, making it ideal for migrating on-premises file servers. AWS Storage Gateway File Gateway is also a fully managed service that provides SMB file access to data stored in Amazon S3, and it can be used for file server migration. Amazon FSx for Lustre is designed for high-performance computing and does not support SMB. Amazon S3 is object storage, not file storage. Amazon EFS supports NFS, not SMB.

Answer

Amazon FSx for Lustre

Answer

Amazon S3

Answer

Amazon Elastic File System (Amazon EFS)

Question 14

During an on-premises to AWS migration using AWS MGN (Application Migration Service), the replication is stuck at 99% for the last few GB. The source server is a Linux database server with a large InnoDB redo log. What is the most likely cause?

Accepted Answer

Continuous writes to the database redo logs preventing final sync. AWS MGN uses changed block tracking (CBT) to replicate changed blocks. Large InnoDB redo logs are continuously written, causing constant changes and preventing final sync. Option A (High disk I/O) can slow replication but would not cause a stall at exactly 99%. Option B (source server reboot) is not required after agent installation and would reset replication, not stall at 99%. Option C (insufficient network bandwidth) would affect all stages, not just final sync. Therefore, continuous writes to the redo logs (Option D) is the most likely cause.

Answer

High disk I/O on the source server

Answer

The source server needs reboot after MGN agent installation

Answer

Insufficient network bandwidth between source and AWS

Question 15

A company is planning to migrate a 50 TB Oracle database to Amazon Aurora PostgreSQL. The company requires minimal downtime and wants to use AWS DMS for the migration. The source database is currently running on a dedicated server with high transaction volume. The network bandwidth between on-premises and AWS is 1 Gbps. What additional step should the company take to accelerate the migration and reduce downtime?

Accepted Answer

Use AWS Snowball to transfer an initial full load of the database to Amazon S3, then use AWS DMS for ongoing replication. For a 50 TB Oracle database migration to Aurora PostgreSQL with a 1 Gbps network link, using AWS DMS alone for the full load would take many days due to bandwidth limitations. AWS Snowball can be used to transfer an initial full load of the database to Amazon S3, bypassing the network bottleneck. After the data is loaded into Aurora PostgreSQL, AWS DMS can be used for ongoing Change Data Capture (CDC) replication to apply changes that occurred during the initial load, minimizing downtime. This approach accelerates the migration by handling the bulk data transfer offline while using DMS only for the incremental changes.

Answer

Migrate the database in smaller batches by moving individual schemas sequentially

Answer

Use AWS DMS with a single task and disable validation to speed up the process

Answer

Increase the network bandwidth to 10 Gbps for the duration of the migration