Free AWS-SOLUTIONS-ARCHITECT-PROFESSIONAL Exam Braindumps
AWS Certified Solutions Architect - Professional SAP-C02 Questions 273–280 (page: 36)

Updated On: 9-Apr-2026

A company is planning to migrate an Amazon RDS for Oracle database to an RDS for PostgreSQL DB instance in another AWS account. A solutions architect needs to design a migration strategy that will require no downtime and that will minimize the amount of time necessary to complete the migration. The migration strategy must replicate all existing data and any new data that is created during the migration. The target database must be identical to the source database at completion of the migration process.

All applications currently use an Amazon Route 53 CNAME record as their endpoint for communication with the RDS for Oracle DB instance. The RDS for Oracle DB instance is in a private subnet.

Which combination of steps should the solutions architect take to meet these requirements? (Choose three.)

  1. Create a new RDS for PostgreSQL DB instance in the target account. Use the AWS Schema Conversion Tool (AWS SCT) to migrate the database schema from the source database to the target database.
  2. Use the AWS Schema Conversion Tool (AWS SCT) to create a new RDS for PostgreSQL DB instance in the target account with the schema and initial data from the source database.
  3. Configure VPC peering between the VPCs in the two AWS accounts to provide connectivity to both DB instances from the target account. Configure the security groups that are attached to each DB instance to allow traffic on the database port from the VPC in the target account.
  4. Temporarily allow the source DB instance to be publicly accessible to provide connectivity from the VPC in the target account. Configure the security groups that are attached to each DB instance to allow traffic on the database port from the VPC in the target account.
  5. Use AWS Database Migration Service (AWS DMS) in the target account to perform a full load plus change data capture (CDC) migration from the source database to the target database. When the migration is complete, change the CNAME record to point to the target DB instance endpoint.
  6. Use AWS Database Migration Service (AWS DMS) in the target account to perform a change data capture (CDC) migration from the source database to the target database. When the migration is complete, change the CNAME record to point to the target DB instance endpoint.

Answer(s): A,C,E

Explanation:

A) Using the AWS Schema Conversion Tool (AWS SCT) is the best way to migrate the database schema from the Oracle DB instance to the PostgreSQL DB instance since the schema will need to be adapted to PostgreSQL.
C) Configuring VPC peering between the source and target accounts ensures network connectivity between the databases, allowing secure data transfer. The security groups also need to be configured to permit traffic on the database port between the two VPCs.
E) Using AWS Database Migration Service (AWS DMS) with a full load plus change data capture (CDC) migration ensures that the migration captures both the existing data and any new changes made during the migration process. This approach allows for near-zero downtime, and updating the Route 53 CNAME record after the migration ensures applications can seamlessly switch to the new database.
This combination of steps enables a smooth migration with no downtime and ensures that the target database remains identical to the source database at the completion of the process.



A company has implemented an ordering system using an event-driven architecture. During initial testing, the system stopped processing orders. Further log analysis revealed that one order message in an Amazon Simple Queue Service (Amazon SQS) standard queue was causing an error on the backend and blocking all subsequent order messages. The visibility timeout of the queue is set to 30 seconds, and the backend processing timeout is set to 10 seconds. A solutions architect needs to analyze faulty order messages and ensure that the system continues to process subsequent messages.

Which step should the solutions architect take to meet these requirements?

  1. Increase the backend processing timeout to 30 seconds to match the visibility timeout.
  2. Reduce the visibility timeout of the queue to automatically remove the faulty message.
  3. Configure a new SQS FIFO queue as a dead-letter queue to isolate the faulty messages.
  4. Configure a new SQS standard queue as a dead-letter queue to isolate the faulty messages.

Answer(s): D

Explanation:

D) Configuring a new SQS standard queue as a dead-letter queue isolates faulty messages, preventing them from blocking subsequent messages. The dead-letter queue will capture messages that cannot be processed successfully after a defined number of retries. This ensures that the system continues to process other orders while the faulty messages are analyzed and handled separately, meeting the requirements without causing a system halt.



A company has automated the nightly retraining of its machine learning models by using AWS Step Functions. The workflow consists of multiple steps that use AWS Lambda. Each step can fail for various reasons, and any failure causes a failure of the overall workflow.

A review reveals that the retraining has failed multiple nights in a row without the company noticing the failure. A solutions architect needs to improve the workflow so that notifications are sent for all types of failures in the retraining process.

Which combination of steps should the solutions architect take to meet these requirements? (Choose three.)

  1. Create an Amazon Simple Notification Service (Amazon SNS) topic with a subscription of type "Email" that targets the team's mailing list.
  2. Create a task named "Email" that forwards the input arguments to the SNS topic.
  3. Add a Catch field to all Task, Map, and Parallel states that have a statement of "ErrorEquals": [ "States.ALL" ] and "Next”: "Email".
  4. Add a new email address to Amazon Simple Email Service (Amazon SES). Verify the email address.
  5. Create a task named "Email" that forwards the input arguments to the SES email address.
  6. Add a Catch field to all Task, Map, and Parallel states that have a statement of "ErrorEquals": [ "States.Runtime" ] and "Next": "Email".

Answer(s): A,B,C

Explanation:

A) Creating an Amazon Simple Notification Service (Amazon SNS) topic with an email subscription ensures that the team will receive notifications via email when a failure occurs.
B) Creating a task named "Email" that forwards input arguments to the SNS topic ensures that the correct information is passed to the notification system, allowing for relevant failure details to be communicated to the team.
C) Adding a Catch field to all Task, Map, and Parallel states with "ErrorEquals": [ "States.ALL" ] ensures that the workflow captures all types of errors (not just runtime errors), and the "Next" field ensures that the failure redirects to the "Email" task to trigger a notification.
This combination ensures that any type of failure in the workflow will result in an immediate notification to the team, allowing them to take corrective action promptly.



A company plans to deploy a new private intranet service on Amazon EC2 instances inside a VPC. An AWS Site-to-Site VPN connects the VPC to the company's on-premises network. The new service must communicate with existing on-premises services. The on-premises services are accessible through the use of hostnames that reside in the company.example DNS zone. This DNS zone is wholly hosted on premises and is available only on the company's private network.

A solutions architect must ensure that the new service can resolve hostnames on the company.example domain to integrate with existing services.

Which solution meets these requirements?

  1. Create an empty private zone in Amazon Route 53 for company.example. Add an additional NS record to the company's on-premises company.example zone that points to the authoritative name servers for the new private zone in Route 53.
  2. Turn on DNS hostnames for the VPC. Configure a new outbound endpoint with Amazon Route 53 Resolver. Create a Resolver rule to forward requests for company.example to the on-premises name servers.
  3. Turn on DNS hostnames for the VPConfigure a new inbound resolver endpoint with Amazon Route 53 Resolver. Configur&the on-premises DNS server to forward requests for company.example to the new resolver.
  4. Use AWS Systems Manager to configure a run document that will install a hosts file that contains any required hostnames. Use an Amazon EventBridge rule to run the document when an instance is entering the running state.

Answer(s): B

Explanation:

B) Enabling DNS hostnames for the VPC and configuring an outbound endpoint with Amazon Route 53 Resolver allows the EC2 instances in the VPC to forward DNS queries for the company.example domain to the on-premises DNS servers. By creating a Resolver rule to forward requests for this domain, the on-premises DNS servers will handle the resolution, ensuring that the new service can resolve hostnames from the company’s private network and integrate with existing services.



A company uses AWS CloudFormation to deploy applications within multiple VPCs that are all attached to a transit gateway. Each VPC that sends traffic to the public internet must send the traffic through a shared services VPC. Each subnet within a VPC uses the default VPC route table, and the traffic is routed to the transit gateway. The transit gateway uses its default route table for any VPC attachment.

A security audit reveals that an Amazon EC2 instance that is deployed within a VPC can communicate with an EC2 instance that is deployed in any of the company's other VPCs. A solutions architect needs to limit the traffic between the VPCs. Each VPC must be able to communicate only with a predefined, limited set of authorized VPCs.

What should the solutions architect do to meet these requirements?

  1. Update the network ACL of each subnet within a VPC to allow outbound traffic only to the authorized VPCs. Remove all deny rules except the default deny rule.
  2. Update all the security groups that are used within a VPC to deny outbound traffic to security groups that are used within the unauthorized VPCs.
  3. Create a dedicated transit gateway route table for each VPC attachment. Route traffic only to the authorized VPCs.
  4. Update the main route table of each VPC to route traffic only to the authorized VPCs through the transit gateway.

Answer(s): C

Explanation:

C) Creating a dedicated transit gateway route table for each VPC attachment and routing traffic only to authorized VPCs ensures that VPCs can communicate with each other only as per the predefined rules. By isolating the traffic flow at the transit gateway level, the solution restricts inter-VPC communication, allowing only authorized VPCs to exchange traffic, which meets the security requirements of limiting traffic between VPCs.



A company has a Windows-based desktop application that is packaged and deployed to the users' Windows machines. The company recently acquired another company that has employees who primarily use machines with a Linux operating system. The acquiring company has decided to migrate and rehost the Windows-based desktop application to AWS.

All employees must be authenticated before they use the application. The acquiring company uses Active Directory on premises but wants a simplified way to manage access to the application on AWS for all the employees.

Which solution will rehost the application on AWS with the LEAST development effort?

  1. Set up and provision an Amazon Workspaces virtual desktop for every employee. Implement authentication by using Amazon Cognito identity pools. Instruct employees to run the application from their provisioned Workspaces virtual desktops.
  2. Create an Auto Scaling group of Windows-based Amazon EC2 instances. Join each EC2 instance to the company’s Active Directory domain. Implement authentication by using the Active Directory that is running on premises. Instruct employees to run the application by using a Windows remote desktop.
  3. Use an Amazon AppStream 2.0 image builder to create an image that includes the application and the required configurations. Provision an AppStream 2.0 On-Demand fleet with dynamic Fleet Auto Scaling policies for running the image. Implement authentication by using AppStream 2.0 user pools. Instruct the employees to access the application by starting browser-based AppStream 2.0 streaming sessions.
  4. Refactor and containerize the application to run as a web-based application. Run the application in Amazon Elastic Container Service (Amazon ECS) on AWS Fargate with step scaling policies. Implement authentication by using Amazon Cognito user pools. Instruct the employees to run the application from their browsers.

Answer(s): C

Explanation:

C) Using Amazon AppStream 2.0 provides a quick way to rehost the Windows desktop application without significant redevelopment efforts. AppStream 2.0 allows the application to run on AWS and stream to users via a browser. By leveraging AppStream 2.0 On-Demand fleet with auto-scaling, authentication via AppStream 2.0 user pools, and a browser-based streaming session, the company can easily provide access to both Windows and Linux users without requiring major changes to the existing application. This approach also simplifies authentication and access management, meeting the company’s requirements.



A company is collecting a large amount of data from a fleet of IoT devices. Data is stored as Optimized Row Columnar (ORC) files in the Hadoop Distributed File System (HDFS) on a persistent Amazon EMR cluster. The company's data analytics team queries the data by using SQL in Apache Presto deployed on the same EMR cluster. Queries scan large amounts of data, always run for less than 15 minutes, and run only between 5 PM and 10 PM.

The company is concerned about the high cost associated with the current solution. A solutions architect must propose the most cost-effective solution that will allow SQL data queries.

Which solution will meet these requirements?

  1. Store data in Amazon S3. Use Amazon Redshift Spectrum to query data.
  2. Store data in Amazon S3. Use the AWS Glue Data Catalog and Amazon Athena to query data.
  3. Store data in EMR File System (EMRFS). Use Presto in Amazon EMR to query data.
  4. Store data in Amazon Redshift. Use Amazon Redshift to query data.

Answer(s): B

Explanation:

B) Storing data in Amazon S3 and using the AWS Glue Data Catalog along with Amazon Athena is the most cost-effective solution. Amazon Athena allows for serverless querying of data stored in S3 using SQL, which is more cost-efficient compared to maintaining a persistent Amazon EMR cluster. Athena supports querying large datasets, such as the ORC files from the IoT devices, and since queries only run during a specific time window, Athena’s on-demand nature is ideal. This setup eliminates the need for a persistent EMR cluster, thus reducing costs.



A large company recently experienced an unexpected increase in Amazon RDS and Amazon DynamoDB costs. The company needs to increase visibility into details of AWS Billing and Cost Management. There are various accounts associated with AWS Organizations, including many development and production accounts. There is no consistent tagging strategy across the organization, but there are guidelines in place that require all infrastructure to be deployed using AWS CloudFormation with consistent tagging. Management requires cost center numbers and project ID numbers for all existing and future DynamoDB tables and RDS instances.

Which strategy should the solutions architect provide to meet these requirements?

  1. Use Tag Editor to tag existing resources. Create cost allocation tags to define the cost center and project ID and allow 24 hours for tags to propagate to existing resources.
  2. Use an AWS Config rule to alert the finance team of untagged resources. Create a centralized AWS Lambda based solution to tag untagged RDS databases and DynamoDB resources every hour using a cross-account role.
  3. Use Tag Editor to tag existing resources. Create cost allocation tags to define the cost center and project ID. Use SCPs to restrict resource creation that do not have the cost center and project ID on the resource.
  4. Create cost allocation tags to define the cost center and project ID and allow 24 hours for tags to propagate to existing resources. Update existing federated roles to restrict privileges to provision resources that do not include the cost center and project ID on the resource.

Answer(s): C

Explanation:

C) Using Tag Editor to tag existing resources and creating cost allocation tags for cost center and project ID ensures that all current resources are properly tagged. Implementing Service Control Policies (SCPs) to restrict the creation of new resources that do not include the required tags ensures compliance with the company’s guidelines moving forward. This strategy provides a way to apply consistent tagging across the organization, which aligns with the requirements for tagging all infrastructure deployed using AWS CloudFormation.



Viewing page 36 of 68
Viewing questions 281 - 288 out of 533 questions


Post your Comments and Discuss Amazon AWS-SOLUTIONS-ARCHITECT-PROFESSIONAL exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!