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

Exam AWS Certified Solutions Architect - Professional SAP-C02 All Questions

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

Exam AWS Certified Solutions Architect - Professional SAP-C02 topic 1 question 275 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Professional SAP-C02
Question #: 275
Topic #: 1
[All AWS Certified Solutions Architect - Professional SAP-C02 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 psyx21 at June 21, 2023, 11:30 a.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
SmileyCloud
Highly Voted 1 year, 4 months ago
Selected Answer: ACE
ace - correct b - AWS SCT can't create RDS d - never make anything publicly accessible even if temporary f - you need initial data, not just changes
upvoted 16 times
...
TonytheTiger
Most Recent 7 months, 2 weeks ago
Selected Answer: ACE
Option E - https://aws.amazon.com/blogs/database/migrating-oracle-databases-with-near-zero-downtime-using-aws-dms/ Option A - https://docs.aws.amazon.com/dms/latest/sbs/chap-oracle-postgresql.migration-process.database-schema-conversion.html
upvoted 2 times
...
duriselvan
10 months, 3 weeks ago
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. 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.
upvoted 1 times
...
shaaam80
11 months ago
Selected Answer: ACE
Answer - ACE Create target DB and use SCT for Schema conversion VPC peering and Open DB access ports via SGs AWS DMS to fully load + CDC
upvoted 1 times
...
career360guru
11 months, 2 weeks ago
Selected Answer: ACE
A, C, E right options
upvoted 1 times
...
joleneinthebackyard
1 year ago
Selected Answer: ACE
Choices are between A vs B, C vs D, E vs F. B: SCT cannot create RDS D: When you see making database publicly accessible, you don't need to read more F: only perform on changed data while E also do the full load
upvoted 1 times
...
ggrodskiy
1 year, 3 months ago
Correct ACE.
upvoted 1 times
...
NikkyDicky
1 year, 3 months ago
Selected Answer: ACE
ACE it
upvoted 1 times
...
SkyZeroZx
1 year, 4 months ago
Selected Answer: ACE
ACE are correct B is inorrect because SCT cannot create RDS instance
upvoted 1 times
...
Maria2023
1 year, 4 months ago
Selected Answer: ACE
https://docs.aws.amazon.com/dms/latest/sbs/chap-oracle-postgresql.migration-process.data-migration.html
upvoted 1 times
...
shree2023
1 year, 4 months ago
Selected Answer: ACE
ACE is correct
upvoted 1 times
...
gd1
1 year, 4 months ago
Selected Answer: ACE
A. Use SCT; C- Peering; E - DMS with full and change
upvoted 1 times
...
PhuocT
1 year, 4 months ago
A, C and E
upvoted 1 times
...
jubileu84
1 year, 4 months ago
Correct Answer is ACE
upvoted 1 times
...
bhanus
1 year, 4 months ago
Selected Answer: ACE
ACE are correct B is inorrect because SCT cannot create RDS instance
upvoted 3 times
...
MoussaNoussa
1 year, 4 months ago
Correct Answer is ACE
upvoted 3 times
...
psyx21
1 year, 4 months ago
Selected Answer: BEF
Correct Answer is BEF
upvoted 1 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