ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Solutions Architect - Professional All Questions

View all questions & answers for the AWS Certified Solutions Architect - Professional exam
Go to Exam

Exam AWS Certified Solutions Architect - Professional topic 1 question 976 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Professional
Question #: 976
Topic #: 1
[All AWS Certified Solutions Architect - Professional Questions]

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

  • A. 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.
  • B. 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.
  • C. 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.
  • D. 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.
  • E. 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.
  • F. 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.
Show Suggested Answer Hide Answer
Suggested Answer: ACE 🗳️
by syaldram at Jan. 9, 2023, 3:30 p.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
rsn
1 year, 9 months ago
Selected Answer: BCF
I feel it is BCF. SCT is efficient for large datasets. It just does not support CDC. For CDC, we can use DMS.
upvoted 1 times
vn_thanhtung
1 year, 9 months ago
The migration strategy must replicate all existing data and any new data that is created during the migration, With F only migrate change data => F Wrong
upvoted 1 times
...
vn_thanhtung
1 year, 9 months ago
"Use the AWS Schema Conversion Tool (AWS SCT) to create a new RDS for PostgreSQL DB instance" => This is crazy, You should prepare better before the exam
upvoted 1 times
...
...
Sudeepshiv
1 year, 11 months ago
Selected Answer: ACE
Ace are right
upvoted 1 times
...
zozza2023
2 years, 3 months ago
Selected Answer: ACE
ACE for me
upvoted 2 times
...
ggrodskiy
2 years, 4 months ago
Correct ACE for me
upvoted 3 times
ggrodskiy
2 years, 4 months ago
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Task.CDC.html
upvoted 1 times
...
...
syaldram
2 years, 4 months ago
Selected Answer: ACE
I like ACE
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago