SAP-C02 Accelerate Workload Migration and Modernization Practice Test 22 — 15 Questions

Question 1

A company is migrating a legacy application that uses Windows Authentication for SQL Server. The company wants to use AWS Managed Microsoft AD. Which migration strategy should be used for the database to maintain compatibility?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Replatform to Amazon RDS for SQL Server with Windows Authentication. AWS Managed Microsoft AD is a managed Active Directory service that supports Windows Authentication (Kerberos/NTLM) natively. Amazon RDS for SQL Server can be domain-joined to AWS Managed Microsoft AD, allowing the database to continue using Windows Authentication without code changes. This preserves the legacy application's authentication model during migration.

Answer

Use AWS DMS to migrate to Amazon DynamoDB

Answer

Replatform to Amazon RDS for MySQL

Answer

Replatform to Amazon Aurora PostgreSQL

Question 2

A company is migrating a legacy Oracle database to Amazon Aurora PostgreSQL. The migration must be completed with minimal downtime and minimal manual effort. Which AWS service should be used?

Accepted Answer

AWS DMS with ongoing replication. AWS Database Migration Service (DMS) with ongoing replication enables continuous data replication from the source Oracle database to the target Aurora PostgreSQL with minimal downtime. It supports heterogeneous migrations when combined with the AWS Schema Conversion Tool (SCT) for schema conversion. DMS handles the data migration and keeps the target in sync until cutover, minimizing manual effort and downtime.

Answer

AWS DataSync

Answer

AWS Snowball Edge

Answer

AWS Schema Conversion Tool (SCT)

Question 3

A company is planning to migrate a large .NET application to AWS. The application uses IIS and SQL Server. Which TWO AWS services can be used to rehost the application with minimal changes?

Accepted Answer

Amazon EC2 with Windows Server. Amazon EC2 with Windows Server (B) is correct because it lets the company rehost the existing .NET/IIS application on a Windows Server instance with minimal changes, since IIS and the .NET runtime run natively on the VM just as they did on-premises. Amazon RDS for SQL Server (D) is correct because it provides a managed SQL Server engine that is compatible with the application's existing database, so the database can be migrated with little or no code change. AWS Elastic Beanstalk (C) is not the best fit here because it is a PaaS that abstracts the infrastructure and typically requires application packaging/deployment changes rather than a straight rehost of an IIS/SQL Server stack. Amazon Aurora (A) is a MySQL/PostgreSQL-compatible engine and does not support SQL Server, so it would require database conversion. AWS Lambda (E) is a serverless compute service that cannot run a full IIS/.NET application with SQL Server dependencies without significant re-architecture.

Answer

Amazon Aurora

Answer

AWS Elastic Beanstalk

Answer

AWS Lambda

Question 4

A company is migrating a legacy on-premises application to AWS. The application uses a proprietary database that runs on a single Windows server. The company wants to minimize downtime and avoid re-architecting the database. Which migration strategy should the solutions architect recommend?

Accepted Answer

Rehost using AWS Application Migration Service (CloudEndure). Rehosting (lift-and-shift) with AWS Application Migration Service (formerly CloudEndure) moves the Windows server and its proprietary database to EC2 with minimal changes and minimal downtime, preserving the existing database engine. This aligns with the goal of avoiding re-architecture while meeting the migration timeline.

Answer

Retire the application and replace it with a SaaS solution

Answer

Re-architect the application to use Amazon DynamoDB

Answer

Replatform by migrating the database to Amazon RDS for SQL Server

Question 5

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database is 2 TB in size and the company has a 1 Gbps AWS Direct Connect connection. They need to minimize downtime. Which approach should the solutions architect recommend?

Accepted Answer

Use AWS DMS with full load followed by ongoing replication using change data capture (CDC). AWS Database Migration Service (DMS) with change data capture (CDC) allows continuous replication and minimal downtime. Export/import would cause downtime. AWS Schema Conversion Tool (SCT) is for schema conversion, not data migration. Snowball is for offline data transfer and would delay the process.

Answer

Export the database using Oracle Data Pump and import into RDS

Answer

Use AWS Snowball Edge to transfer the database files and then restore to RDS

Answer

Use AWS Schema Conversion Tool to convert the schema and AWS DMS for data migration without CDC

Question 6

A company is migrating a stateful web application to AWS. The application currently runs on a single on-premises server and uses local storage for session data. The company wants to make the application highly available and scalable. What should the solutions architect do?

Accepted Answer

Migrate session data to Amazon ElastiCache or DynamoDB, then use an Auto Scaling group behind an ALB. Moving session state to ElastiCache or DynamoDB makes the application stateless, enabling Auto Scaling. Sticky sessions on an ALB are a workaround but do not provide full statelessness. Using a larger instance does not provide high availability. Multi-AZ RDS for session data is not ideal for high-frequency session access.

Answer

Store session data in a Multi-AZ Amazon RDS database and use Route 53 with health checks

Answer

Use an Application Load Balancer with sticky sessions and an Auto Scaling group

Answer

Use a larger EC2 instance to handle all traffic and take regular snapshots

Question 7

A company is migrating an on-premises .NET application to AWS. The application uses a SQL Server database with a large number of stored procedures and triggers. The company wants to reduce licensing costs by moving to an open-source database. Which AWS service should the solutions architect use to automate the database conversion?

Accepted Answer

AWS Schema Conversion Tool (SCT). AWS Schema Conversion Tool (SCT) automates the conversion of database schema and code to a target database like PostgreSQL or MySQL. DMS handles data migration, not schema conversion. App2Container is for containerizing applications. CloudEndure is for server migration.

Answer

AWS Database Migration Service (DMS)

Answer

AWS App2Container

Answer

AWS Application Migration Service (CloudEndure)

Question 8

A company is migrating a legacy application that uses Windows Authentication for SQL Server. The company wants to use AWS Managed Microsoft AD. Which migration strategy should be used for the database to maintain compatibility?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Replatform the database to Amazon RDS for MySQL. Option C is correct because replatforming the local MySQL database to Amazon RDS for MySQL preserves the MySQL engine and schema while offloading patching, backups, and high availability to AWS, which reduces operational overhead with minimal application changes. Option D is correct because rehosting (lift-and-shift) the application onto Amazon EC2 moves the existing server workload to the cloud with little or no code modification, directly satisfying the goal of minimizing changes. Option A is not appropriate because refactoring into microservices requires significant redesign and development effort, contradicting the minimize-changes requirement. Option B is wrong because retiring the application eliminates the workload rather than migrating it. Option E is wrong because repurchasing a SaaS alternative replaces the application entirely, which is a larger change than the company wants.

Answer

Refactor the application to use microservices

Answer

Retire the application

Answer

Repurchase a SaaS alternative

Question 9

A company is migrating a multi-tier e-commerce application to AWS. The application consists of a web tier, an application tier, and a MySQL database tier. The company wants to improve scalability and availability while reducing administrative overhead. Which THREE actions should the solutions architect take? (Select THREE.)

Accepted Answer

Migrate the MySQL database to Amazon RDS Multi-AZ. Option A is correct because Amazon RDS Multi-AZ maintains a synchronous standby replica in a second Availability Zone and automatically fails over the DNS endpoint during an AZ outage, which improves database availability while removing the administrative overhead of self-managed MySQL replication and patching. Option B is correct because storing session state in Amazon ElastiCache (Redis or Memcached) externalizes sessions from individual web instances, allowing any instance in the Auto Scaling group to serve any user request and enabling stateless, horizontally scalable web and application tiers. Option D is correct because an Application Load Balancer distributes HTTP/HTTPS traffic across targets in multiple AZs and an Auto Scaling group automatically replaces unhealthy instances and scales capacity with demand, directly delivering the required scalability and availability. Option C is not appropriate here because Amazon EFS is a shared POSIX file system that is unnecessary once sessions are externalized to ElastiCache, and it adds latency and cost without addressing the stated goals. Option E is not appropriate because Spot Instances can be reclaimed with a two-minute interruption notice, making them unsuitable for all instances of a production e-commerce application; they should be limited to fault-tolerant, stateless workloads.

Answer

Use Amazon EFS for shared storage between web instances

Answer

Use Spot Instances for all EC2 instances to reduce costs

Question 10

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 is explicitly 'DMS', which stands for AWS Database Migration Service. In AWS Migration Hub, the progress update stream identifies the migration tool that is reporting the task status. Since the stream is DMS, the task was created and is being executed by AWS Database Migration Service, making it the service responsible for the failure. Other services like Application Migration Service or Server Migration Service would report under different progress update streams (e.g., 'MGN' or 'SMS').

Answer

AWS Application Migration Service (CloudEndure)

Answer

AWS Server Migration Service (SMS)

Answer

AWS CloudEndure Migration

Question 11

A company is migrating a 10 TB Oracle database to Amazon Aurora PostgreSQL. The migration must have minimal downtime and support ongoing replication. The application uses stored procedures and advanced Oracle features. The company has already set up an AWS DMS replication instance and validated connectivity. However, during the full load, DMS reports errors for certain tables containing LOBs. What is the most likely cause and solution?

Accepted Answer

The LOB mode is set to 'Limited LOB mode' and some LOBs exceed the maximum allowed size. Set LOB mode to 'Full LOB mode'.. AWS DMS offers two LOB handling modes: Limited LOB mode (default) and Full LOB mode. In Limited LOB mode, DMS truncates any LOB larger than the specified MaxLobSize (default 32 KB), which can cause errors or data loss for tables with larger LOBs. Since the migration involves an Oracle database with advanced features and LOBs, it's likely that some LOBs exceed the limit. Switching to Full LOB mode allows DMS to migrate LOBs of any size, though it may impact performance. This directly addresses the reported errors during full load.

Answer

The DMS replication instance does not have enough memory. Increase the instance size.

Answer

The target Aurora PostgreSQL cluster does not have enough storage. Increase the allocated storage.

Answer

The source database is not configured for change data capture (CDC). Enable supplemental logging.

Question 12

A company is planning to migrate a web application to AWS. The application currently runs on a single on-premises server with a few thousand users. The company wants to use a managed container service and minimize operational overhead. Which AWS service should the company use to run the application?

Accepted Answer

Amazon ECS with AWS Fargate. Amazon ECS with AWS Fargate is the right choice because it is a managed container service that runs containers without requiring the company to provision or manage EC2 instances, minimizing operational overhead. Fargate handles the underlying compute, scaling, and patching, so the team focuses on the application. For a few thousand users, this is a good fit without the complexity of Kubernetes.

Answer

Amazon EKS

Answer

AWS Lambda

Answer

Amazon EC2

Question 13

A company is migrating a critical application from on-premises to AWS. The application uses a shared file system for user uploads and logs. The company wants a highly available, durable, and low-latency solution. Which AWS storage service should the company use?

Accepted Answer

Amazon EFS. Amazon EFS is a fully managed, elastic NFS file system that can be mounted concurrently by multiple EC2 instances and containers across Availability Zones, providing high availability, durability (11 nines), and low-latency shared access. It is purpose-built for shared file workloads like user uploads and logs, and it scales automatically without provisioning. This matches the requirement for a highly available, durable, low-latency shared file system.

Answer

Amazon EBS

Answer

Amazon FSx for Windows File Server

Answer

Amazon S3

Question 14

A company is migrating an application that uses a commercial database to Amazon RDS. The database size is 500 GB. Which migration approach minimizes downtime?

Accepted Answer

Use AWS Database Migration Service (AWS DMS) with ongoing replication (change data capture).. AWS DMS with ongoing replication uses change data capture (CDC) to continuously apply changes from the source database to the target RDS instance after the initial full load. This keeps the target in sync until cutover, minimizing downtime to only the final switchover window. It is the standard AWS-recommended approach for minimal-downtime heterogeneous or homogeneous database migrations.

Answer

Use native database tools to export and import data.

Answer

Use AWS Snowball Edge to transfer the database files.

Answer

Copy database files to Amazon S3 and restore to RDS.

Question 15

A company is migrating a stateful application to AWS. The application runs on a single on-premises server and uses local storage for persistent data. The company wants to achieve high availability and scalability. Which migration approach should the company use?

Accepted Answer

Refactor the application to store state in Amazon ElastiCache or Amazon DynamoDB.. The application is stateful and needs high availability and scalability. Refactoring to store state in managed services like Amazon ElastiCache or DynamoDB decouples state from compute, allowing compute to scale and be replaced without data loss. Option A is wrong: while an ALB with sticky sessions distributes traffic, it ties sessions to specific instances, making scaling and failover complex and not fully HA. Option B is wrong: a single EC2 instance is a single point of failure and cannot scale. Option D is wrong: EBS snapshots are for backup/disaster recovery, not real-time HA or state persistence during scaling. Only option C properly addresses state management for HA and scalability.

Answer

Use multiple EC2 instances behind an Application Load Balancer with sticky sessions.

Answer

Lift and shift to a single Amazon EC2 instance with an EBS volume.

Answer

Use an EC2 Auto Scaling group with lifecycle hooks to persist state to EBS snapshots.