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

Question 1

A company is migrating a legacy three-tier application to AWS. The application uses a self-managed Oracle database on an EC2 instance. The company wants to move to Amazon Aurora PostgreSQL with minimal downtime and no data loss. The database is 2 TB and experiences continuous write traffic. A solutions architect must recommend a migration strategy that keeps the source and target databases synchronized until cutover. Which combination of steps should the solutions architect take?

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

Accepted Answer

Use AWS Schema Conversion Tool (AWS SCT) to convert the schema, then use AWS Database Migration Service (AWS DMS) with change data capture (CDC) to replicate ongoing changes until cutover.. Heterogeneous migrations from Oracle to Aurora PostgreSQL require both schema conversion and data replication. AWS SCT handles the conversion of schema objects, stored procedures, and other code to PostgreSQL-compatible equivalents. AWS DMS then performs the initial data load and uses change data capture to apply ongoing changes from the Oracle source to the Aurora target. This combination keeps the target synchronized and allows a cutover with minimal downtime and no data loss, even under continuous write traffic.

Answer

Use native Oracle Data Pump to export the database to Amazon S3, then use AWS DMS to import the dump into Aurora PostgreSQL.

Answer

Use AWS Database Migration Service (AWS DMS) with full load only, then stop the application and run a final incremental load before cutover.

Answer

Use AWS Database Migration Service (AWS DMS) with ongoing replication, and use AWS Schema Conversion Tool (AWS SCT) only for assessment, not for schema conversion.

Question 2

A financial services company is migrating 45 on-premises physical servers to AWS. Many servers have underutilized resources and inconsistent tagging. The migration team must right-size instances and reduce costs. They need a service that collects server utilization and dependency data to form migration groups. Which AWS service should they use?

Accepted Answer

AWS Application Discovery Service. AWS Application Discovery Service is purpose-built to discover on-premises servers and collect utilization and dependency data. This information is essential for right-sizing instances and forming migration groups. The other services either perform replication, track migration progress, or migrate databases, but none provide the comprehensive discovery and assessment capabilities required for this migration planning phase.

Answer

AWS Application Migration Service (AWS MGN)

Answer

AWS Database Migration Service (AWS DMS)

Answer

AWS Migration Hub

Question 3

A company is migrating a legacy .NET Framework application to AWS. The application uses Windows authentication and relies on Active Directory for user authentication. The company wants to minimize code changes and maintain the same authentication mechanism. The application will run on Amazon EC2 instances in a VPC. Which solution should a solutions architect recommend?

Accepted Answer

Deploy the application on EC2 instances joined to an AWS Managed Microsoft AD directory, and configure the application to use Windows authentication against the directory.. AWS Managed Microsoft AD provides a managed Active Directory in AWS, enabling EC2 instances to be domain-joined and use Windows authentication. This requires no application code changes and maintains the existing authentication mechanism. It also reduces operational overhead compared to extending an on-premises domain.

Answer

Deploy the application on EC2 instances and configure a site-to-site VPN to the on-premises Active Directory, and join the instances to the on-premises domain.

Answer

Deploy the application on EC2 instances and use AWS IAM Identity Center (successor to AWS Single Sign-On) for authentication, modifying the application to use SAML.

Answer

Deploy the application on EC2 instances and use Amazon Cognito user pools for authentication, updating the application to use OpenID Connect.

Question 4

A healthcare company is migrating a legacy patient records system to AWS. The system uses an Oracle database with complex stored procedures and triggers. The company wants to move to Amazon Aurora PostgreSQL to reduce licensing costs. They need to convert the schema and code with minimal manual effort. Which AWS service should they use?

Accepted Answer

AWS Schema Conversion Tool (AWS SCT). AWS Schema Conversion Tool is specifically built to convert database schemas and procedural code from one engine to another. It automates the conversion of Oracle PL/SQL to PostgreSQL PL/pgSQL, significantly reducing manual effort. While AWS DMS handles data migration, it does not convert schema objects, so SCT is the correct choice for this scenario.

Answer

AWS Database Migration Service (AWS DMS)

Answer

AWS DataSync

Answer

AWS Application Migration Service (AWS MGN)

Question 5

A company is modernizing a legacy monolithic application by decomposing it into microservices. The application currently uses a single relational database. The company wants to migrate to a microservices architecture on AWS and needs to choose appropriate data storage strategies. The company requires that each microservice has its own database to ensure loose coupling and independent scaling. Which two strategies should the company use to achieve this? (Choose two.)

Accepted Answer

Use Amazon Aurora Serverless v2 for each microservice that requires a relational database, with separate clusters per service.. To achieve a database per microservice, each service should have its own dedicated database that matches its data model. Amazon DynamoDB is suitable for key-value and document workloads, while Amazon Aurora Serverless v2 works for relational workloads. Both allow independent scaling and isolation. Using a shared database or non-database services like S3 or ElastiCache does not meet the requirement for loose coupling and independent scaling.

Answer

Use Amazon S3 for all microservices to store structured data as JSON objects.

Answer

Use a single Amazon RDS for PostgreSQL instance with separate schemas for each microservice.

Answer

Use Amazon ElastiCache for Redis as the primary database for all microservices.

Question 6

A company is migrating a legacy three-tier application to AWS. The application uses a self-managed Oracle database on an EC2 instance. The company wants to move to Amazon Aurora PostgreSQL with minimal downtime and no data loss. The database is 2 TB and experiences continuous write traffic. A solutions architect must recommend a migration strategy that keeps the source and target databases synchronized until cutover. Which combination of steps should the solutions architect take?

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

Accepted Answer

Rehost the web tier and business logic tier on Amazon EC2 instances, and migrate the database to Amazon RDS for SQL Server with Multi-AZ.. Rehosting the application tiers on EC2 and migrating the database to RDS for SQL Server with Multi-AZ is the most suitable strategy. It preserves the existing application code and authentication mechanisms, while providing high availability and reducing operational overhead by leveraging a managed database service. This approach aligns with the rehost migration pattern and meets the requirements.

Answer

Repurchase a SaaS solution that provides similar functionality, and retire the legacy application.

Answer

Refactor the application into microservices running on Amazon ECS, and use Amazon DynamoDB for data storage.

Answer

Replatform the web tier to AWS Elastic Beanstalk, rehost the business logic tier on EC2, and migrate the database to Amazon Aurora MySQL.

Question 7

A media company is migrating a large on-premises video rendering workload to AWS. The workload runs on 100 physical servers and is highly parallelizable. The company wants to minimize infrastructure management and only pay for the compute capacity used. They also need to handle sudden spikes in demand. Which AWS service should they use?

Accepted Answer

AWS Batch. AWS Batch is designed for batch computing workloads, providing managed job scheduling and dynamic scaling. It supports both EC2 and Fargate compute environments and can leverage Spot Instances for cost savings. This allows the media company to run parallel rendering jobs without managing infrastructure, while paying only for the resources used, and it scales automatically to handle spikes in demand.

Answer

AWS Lambda

Answer

Amazon ECS with Fargate

Answer

Amazon EC2 with Spot Instances

Question 8

A company is migrating a containerized application to AWS. The application consists of multiple microservices that communicate over HTTP. The company wants to minimize operational overhead and automatically scale the services based on demand. Which AWS service should be used?

Accepted Answer

Amazon ECS with Fargate launch type. Amazon ECS with Fargate provides a serverless compute engine for containers, eliminating the need to manage servers. It supports auto scaling and integrates with load balancers for HTTP communication. This aligns with the goals of minimizing operational overhead and scaling based on demand.

Answer

Amazon EKS with self-managed worker nodes

Answer

Amazon EC2 instances with Docker installed and an Auto Scaling group

Answer

AWS Lambda functions for each microservice

Question 9

A company is migrating an on-premises Oracle database to Amazon Aurora PostgreSQL. The database is 10 TB and supports a critical application with a maximum allowable downtime of 30 minutes. The company wants to use AWS Database Migration Service (AWS DMS) with change data capture (CDC) to minimize downtime. After the initial full load, CDC is replicating ongoing changes. The company needs to perform the final cutover. Which sequence of steps should the company take to achieve the least downtime?

Accepted Answer

Stop the application, wait for CDC to catch up, stop the DMS task, and then redirect the application to Aurora.. The correct cutover process with AWS DMS and CDC involves stopping the application to prevent new writes, allowing CDC to replicate the remaining changes to Aurora, and then stopping the DMS task. This ensures data consistency. After that, the application can be redirected to Aurora. This sequence minimizes downtime while guaranteeing no data loss.

Answer

Stop the application, stop the DMS task, and then redirect the application to Aurora.

Answer

Stop the DMS task, stop the application, and then redirect the application to Aurora.

Answer

Keep the application running, stop the DMS task, and then redirect the application to Aurora.

Question 10

A company is migrating a high-volume transactional database from on-premises to Amazon Aurora PostgreSQL. The database uses sequences, triggers, and stored procedures. The company needs to minimize downtime during cutover and ensure data consistency. Which two actions should be taken to meet these requirements? (Choose two.)

Accepted Answer

Use the AWS Schema Conversion Tool (AWS SCT) to convert the database schema and stored procedures.. AWS DMS with CDC provides ongoing replication to keep the target in sync with minimal downtime, while AWS SCT converts the schema and procedural code to Aurora PostgreSQL. Together, they address both data consistency and code compatibility for a heterogeneous migration. The other options either cause downtime, are technically infeasible, or do not handle schema conversion.

Answer

Take a full database backup and restore it to Aurora PostgreSQL using native tools.

Answer

Use AWS Snowball Edge to transfer the database files to Amazon S3 and then load them into Aurora.

Answer

Configure Aurora PostgreSQL as a read replica of the on-premises database.

Question 11

A retail company is migrating its on-premises data center to AWS. They have many applications with complex interdependencies. The company wants to group servers into migration waves based on network dependencies to minimize disruption. Which AWS tool should they use to discover these dependencies?

Accepted Answer

AWS Application Discovery Service. AWS Application Discovery Service is the tool designed to discover on-premises servers and their network dependencies. It collects data that can be used to group servers into migration waves, ensuring that interdependent applications are migrated together. This minimizes disruption and aligns with the company's goal.

Answer

AWS Trusted Advisor

Answer

AWS Migration Hub

Answer

AWS Systems Manager

Question 12

A company is migrating its on-premises data warehouse to AWS. The data warehouse contains 50 TB of data and is used for complex analytical queries. The company wants a fully managed, petabyte-scale solution that can handle the queries efficiently. Which AWS service should be used?

Accepted Answer

Amazon Redshift. Amazon Redshift is a fully managed, petabyte-scale data warehouse service that uses columnar storage and massively parallel processing to handle complex analytical queries efficiently. It is designed for exactly this use case, making it the correct choice for migrating an on-premises data warehouse.

Answer

Amazon RDS for PostgreSQL

Answer

Amazon S3 with Amazon Athena

Answer

Amazon DynamoDB

Question 13

A company is migrating a legacy .NET application to AWS. The application uses Windows authentication and COM+ components. The company wants to move to a modern architecture with minimal changes to the application code. The application must run on AWS and integrate with Active Directory for authentication. Which solution should the company use?

Accepted Answer

Migrate the application to Amazon EC2 for Windows Server instances joined to an AWS Managed Microsoft AD domain, and use COM+ components on the instances.. For a legacy .NET application using Windows authentication and COM+ components, the most straightforward migration path is to rehost it on Amazon EC2 for Windows Server instances. Joining these instances to AWS Managed Microsoft AD provides seamless Active Directory integration. This approach requires minimal code changes and preserves the existing architecture, making it the best fit for the company's requirements.

Answer

Migrate the application to AWS Lambda with a custom runtime that emulates COM+ components, and use Amazon Cognito for authentication.

Answer

Refactor the application to use .NET Core and run it on Amazon ECS with Windows containers, using AWS IAM for authentication.

Answer

Migrate the application to Amazon RDS for SQL Server and use AWS Directory Service for authentication, keeping the application on-premises.

Question 14

A company is migrating a legacy on-premises application to AWS. The application uses a monolithic architecture and a self-managed MySQL database. The company wants to reduce operational overhead and improve scalability with minimal application changes. A solutions architect needs to recommend a migration path for the database. Which AWS service should the solutions architect use?

Accepted Answer

Amazon RDS for MySQL. Amazon RDS for MySQL provides a managed MySQL-compatible database that minimizes operational tasks such as patching, backups, and replication. Because the application already uses MySQL, the migration can be as simple as using AWS Database Migration Service to replicate the data and then updating the application's connection string. This meets the goals of reducing operational overhead and improving scalability without requiring application rewrites. Other services either use different data models or are optimized for analytics rather than transactions.

Answer

Amazon Aurora MySQL-Compatible Edition

Answer

Amazon DynamoDB

Answer

Amazon Redshift

Question 15

A company is migrating a containerized application from on-premises Kubernetes to Amazon EKS. The application uses persistent volumes for shared configuration files that must be accessible by multiple pods across different Availability Zones. The company wants a fully managed storage solution that supports ReadWriteMany (RWX) access. Which storage option should be used?

Accepted Answer

Amazon EFS with the EFS CSI driver.. Amazon EFS with the EFS CSI driver is the correct choice because it is a fully managed, scalable file system that supports ReadWriteMany access and can be mounted by multiple pods across Availability Zones. It integrates natively with Amazon EKS, enabling dynamic provisioning and shared storage. The other options either do not support RWX, are not designed for Linux containers, or lack POSIX compliance.

Answer

Amazon S3 mounted using the Mountpoint for Amazon S3 CSI driver.

Answer

Amazon FSx for Windows File Server with the FSx CSI driver.

Answer

Amazon EBS with the EBS CSI driver.