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

Exam AWS Certified Solutions Architect - Associate SAA-C02 All Questions

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

Exam AWS Certified Solutions Architect - Associate SAA-C02 topic 1 question 307 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Associate SAA-C02
Question #: 307
Topic #: 1
[All AWS Certified Solutions Architect - Associate SAA-C02 Questions]

A company is moving its on-premises Oracle database to Amazon Aurora PostgreSQL. The database has several applications that write to the same tables. The applications need to be migrated one by one with a month in between each migration Management has expressed concerns that the database has a high number of reads and writes. The data must be kept in sync across both databases throughout tie migration.
What should a solutions architect recommend?

  • A. Use AWS DataSync for the initial migration. Use AWS Database Migration Service (AWS DMS) to create a change data capture (CDC) replication task and a table mapping to select all cables.
  • B. Use AWS DataSync for the initial migration. Use AWS Database Migration Service (AWS DMS) to create a full load plus change data capture (CDC) replication task and a table mapping to select all tables.
  • C. Use the AWS Schema Conversion Tool with AWS DataBase Migration Service (AWS DMS) using a memory optimized replication instance. Create a full load plus change data capture (CDC) replication task and a table mapping to select all tables.
  • D. Use the AWS Schema Conversion Tool with AWS Database Migration Service (AWS DMS) using a compute optimized replication instance. Create a full load plus change data capture (CDC) replication task and a table mapping to select the largest tables.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by dmscountera at March 12, 2021, 2:13 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
syu31svc
Highly Voted 3 years, 7 months ago
"Oracle database to Amazon Aurora PostgreSQL" -> Use Schema Conversion Tool so A and B are out "data must be kept in sync" -> C over D as it has "change data capture (CDC) replication task and a table mapping to select all tables"
upvoted 45 times
future77
2 years, 10 months ago
A,B out since they are not provising SCT which will help migrating Oracle to PostgreSQL. C will win D, since it does the migration for all. Memory optimized or compute optimized will be a secondary concern which is only for distraction. C. select all tables vs D. select the largest tables
upvoted 4 times
...
noahsark
3 years, 6 months ago
To improve the performance when migrating a large table, you can break the migration into more than one task. To break the migration into multiple tasks using row filtering, use a key or a partition key. For example, if you have an integer primary key ID from 1 to 8,000,000, you can create eight tasks using row filtering to migrate 1 million records each. To apply row filtering in the console, open the console, choose Tasks, and create a new task. In the Table mappings section, add a value for Selection Rule. You can then add a column filter with either a less than or equal to, greater than or equal to, equal to, or range condition (between two values). For more information about column filtering, see Specifying table selection and transformations rules from the console. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_BestPractices.html
upvoted 5 times
...
...
bogudan
Highly Voted 3 years, 7 months ago
Between memory (answer C) and compute (answer D) i prefer the memory because i found this : "As you can see, we have three important memory buffers in this architecture for CDC in AWS DMS. If any of these buffers experience memory pressure, the migration can have performance issues that can potentially cause failures." Link: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReplicationInstance.Types.html So my answer will be -> C
upvoted 22 times
crazyaboutazure
3 years, 6 months ago
No brainer, answer is C as for high read and write memory is better than CPU
upvoted 4 times
...
...
BECAUSE
Most Recent 1 year, 11 months ago
Selected Answer: C
C is the answer
upvoted 1 times
...
queen101
2 years, 8 months ago
ccccccccccc
upvoted 1 times
...
etheng1970
2 years, 10 months ago
Selected Answer: C
you need SCT. so A an B is out. Once you had done the migration, the delta is to update for ALL tables not Large Table. So D is out. Answer => C
upvoted 1 times
...
sb555555
3 years ago
Selected Answer: C
has to be c
upvoted 1 times
...
Pryce94
3 years ago
AWS Schema Conversion Tool (SCT) • Convert your Database’s Schema from one engine to another • Example OLTP: (SQL Server or Oracle) to MySQL, PostgreSQL, Aurora • Example OLAP: (Teradata or Oracle) to Amazon Redshift
upvoted 2 times
...
timcheuk
3 years, 1 month ago
Selected Answer: C
memory > computer during data migration. Second reason, the migration designed very detail which target on large table only and less impact on production.
upvoted 1 times
timcheuk
3 years, 1 month ago
Press wrong, i mean I choose answer D. memory
upvoted 1 times
...
...
goblin123
3 years, 1 month ago
Selected Answer: C
Both R5 and C5 instance type can handle this task, but C5 is more suitable for heterogenous migrations, however since we need to migrate all tables, not just large ones, then we're left with choice C.
upvoted 1 times
...
tin2022
3 years, 3 months ago
Answer is D . When migrating from Oracle to PostgreSQL. C4 instances can be a good choice for these situations.
upvoted 1 times
...
jj22222
3 years, 4 months ago
C looks right
upvoted 1 times
...
vandergun
3 years, 5 months ago
Selected Answer: C
c is right, confirmed
upvoted 1 times
...
aws_aspirant
3 years, 5 months ago
Selected Answer: C
CCCCCCCCCC
upvoted 1 times
...
xyzray
3 years, 5 months ago
Selected Answer: C
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReplicationInstance.Types.html R5 instances are the next generation of memory optimized instance types for Amazon EC2. R5 instances are well-suited for memory-intensive applications such as high performance databases, distributed web scale in-memory caches, midsize in-memory databases, real time big data analytics, and other enterprise applications. Ongoing migrations or replications of high-throughput transaction systems using AWS DMS can also consume large amounts of CPU and memory.
upvoted 1 times
...
amshivraj
3 years, 6 months ago
Answer : D The C5 instance classes optimized for compute-intensive workloads and deliver cost-effective high performance at a low price per compute ratio. They achieve significantly higher network performance. Elastic Network Adapter (ENA) provides C5 instances with up to 25 Gbps of network bandwidth and up to 14 Gbps of dedicated bandwidth to Amazon EBS. AWS DMS can be CPU-intensive, especially when performing heterogeneous migrations and replications such as migrating from Oracle to PostgreSQL. C5 instances can be a good choice for these situations. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_BestPractices.html
upvoted 3 times
...
humanwings
3 years, 6 months ago
Listen to me. Answer is D First，lets talk about instance memory-optimized is for high-throughput transaction systems. Compute-optimized instance is the one for heterogeneous migrations and replications such as migrating from Oracle to PostgreSQL. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReplicationInstance.Types.html Another, What is table mapping? It is for filtering and Transformation. A table mapping to select the largest tables means to break the large migration into more than one task. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_BestPractices.html#CHAP_BestPractices.LargeTables
upvoted 4 times
...
jkwek
3 years, 6 months ago
Answer is D. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReplicationInstance.Types.html#CHAP_ReplicationInstance.Types.Deciding Answer C is not correct because memory intensive instance is forhigh performance databases, distributed web scale in-memory caches, midsize in-memory databases, real time big data analytics, and other enterprise applications.
upvoted 4 times
...
Load full discussion...
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