QUESTION: 273

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.)

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.
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.
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.
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.
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.
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.

Reveal Solution Next Question

QUESTION: 274

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?

Increase the backend processing timeout to 30 seconds to match the visibility timeout.
Reduce the visibility timeout of the queue to automatically remove the faulty message.
Configure a new SQS FIFO queue as a dead-letter queue to isolate the faulty messages.
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.

Reveal Solution Next Question

QUESTION: 275

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.)

Create an Amazon Simple Notification Service (Amazon SNS) topic with a subscription of type "Email" that targets the team's mailing list.
Create a task named "Email" that forwards the input arguments to the SNS topic.
Add a Catch field to all Task, Map, and Parallel states that have a statement of "ErrorEquals": [ "States.ALL" ] and "Next”: "Email".
Add a new email address to Amazon Simple Email Service (Amazon SES). Verify the email address.
Create a task named "Email" that forwards the input arguments to the SES email address.
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.

Reveal Solution Next Question

QUESTION: 276

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?

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.
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.
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.
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.

Reveal Solution Next Question

Free SAP-C01 Exam Braindumps (page: 69)

QUESTION: 273

Explanation:

QUESTION: 274

Explanation:

QUESTION: 275

Explanation:

QUESTION: 276

Explanation: