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

Answer is B. https://aws.amazon.com/dynamodb/ Amazon DynamoDB is a key-value and document database that delivers single-digit millisecond performance at any scale. It's a fully managed, multi-region, multi-active, durable database with built-in security, backup and restore, and in-memory caching for internet-scale applications. DynamoDB can handle more than 10 trillion requests per day and can support peaks of more than 20 million requests per second.

Clients only access one record at a time. willing to change database systems Answer is B then

in the real world I will not migrate mysql to no-sql database, but for the example and the wording of the question, I choose B.

B with dynamo DB

It's B

Amazon will sell its system (DynamoDB)

Agreed with B

As an architect, i look at you having a MySQL DB, there is no way i am going to suggest moving to Dynamo, you have to convert from SQL to NoSQL, not going to take that risk, ok with moving RDS, so definitely A

The question is asking about migrating MySQL database to AWS, but also telling you "Willing to change database systems" normally the answer should be RDS since a relational to relational but according to this link https://aws.amazon.com/blogs/big-data/near-zero-downtime-migration-from-mysql-to-dynamodb/ you can migrate relational to non-relational so "Clients only access one record at a time."

B Dynamo bec: almost never modified. Clients get access to a maximum of one record at a time open to experimenting with new database

Answer B: DynamoDB Key to answer lies in last part of the question and sorts the confusion between RDS and DynamoDB "provide nearly limitless future scalability?" RDS : you have to scale yourself as and when needed and manually DynamoDB: automatically scales Many companies consider migrating from relational databases like MySQL to Amazon DynamoDB, a fully managed, fast, highly scalable, and flexible NoSQL database service. For example, DynamoDB can increase or decrease capacity based on traffic, in accordance with business needs. The total cost of servicing can be optimized more easily than for the typical media-based RDBMS. https://aws.amazon.com/blogs/big-data/near-zero-downtime-migration-from-mysql-to-dynamodb/

B Customer is open to change, and dynamo is better for scalability

It is B, for sure.

The answer is B because "The user want to move to AWS and is open to experimenting with new database systems." so we don't need to migrate

Why it is mentioned that "The user want to move to AWS and is open to experimenting with new database systems" ... Correct is B

'A user owns a MySQL database' is.. AAAAAA

Mysql -> RDS