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

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C02 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

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

Submit Cancel

syu31svc

Highly Voted 3 years, 9 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

3 years 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, 8 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, 9 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, 8 months ago

No brainer, answer is C as for high read and write memory is better than CPU

upvoted 4 times

...

BECAUSE

Most Recent 2 years ago

Selected Answer: C

C is the answer

upvoted 1 times

...

queen101

2 years, 10 months ago

ccccccccccc

upvoted 1 times

...

etheng1970

3 years 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, 2 months ago

Selected Answer: C

has to be c

upvoted 1 times

...

Pryce94

3 years, 2 months 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, 2 months 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, 2 months ago

Press wrong, i mean I choose answer D. memory

upvoted 1 times

...

goblin123

3 years, 3 months 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, 5 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, 6 months ago

C looks right

upvoted 1 times

...

vandergun

3 years, 7 months ago

Selected Answer: C

c is right, confirmed

upvoted 1 times

...

aws_aspirant

3 years, 7 months ago

Selected Answer: C

CCCCCCCCCC

upvoted 1 times

...

xyzray

3 years, 7 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, 8 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, 8 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, 8 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...