Exam AWS Certified Database - Specialty topic 1 question 75 discussion

A. B dropped due to snapshot is slower (full disk dump) than clone (copy-on-write) C dropped due to no write on Aurora Replicas D dropped due to there’s no option for cloning in the console.

Answer is A The question does not mention variable workload, so I see no need for Serverless (D)

Choose between A and D. To have Aurora Serverless we need to convert RDS Aurora MySQL to Aurora Serverless MySQL. We can do it 3 ways: - Snapshot restore - Logical backup and restore - A new serverless reader (for Amazon Aurora PostgreSQL-Compatible Edition versions 13.6 and later). Add a serverless reader, force a failover. This promotes the reader instance to a writer instance. https://repost.aws/knowledge-center/aurora-migrate-provisioned-serverless We are asked for "the fastest" solution, so, answer A.

D https://aws.amazon.com/about-aws/whats-new/2021/06/amazon-aurora-serverless-v1-supports-fast-database-cloning/ Aurora Serverless supports fast database cloning. You only pay for additional storage if you make data changes in the cloned DB cluster. In question it mentioned "Testing results in minimal changes to the test data" so there will be a minimal cost for dev env databases. Most cost-effective.

A. it is possible to create an Aurora Cluster with a replica and then use it to create an Aurora Serverless cluster. Then use the Serverless cluster as the source to clone 12 DEV DB. Not choosing D is because D -- we can not choose Serverless as master primary DB because severless is for infrequently use

A is fasted but B is most cost effective D is wrong due to it is not recommend to use serverless db for production.

D Serverless is fastest and clone is supported

Go for D as Aurora Serverless support clonning since June 2021 https://aws.amazon.com/about-aws/whats-new/2021/06/amazon-aurora-serverless-v1-supports-fast-database-cloning/

I chose A over D because I don't believe serverless will be cheaper necessarily.

aurora server less now supports cloning since june 2021. Question is abount cost effective. i am leanng towards D

Going to go with A. Aurora Serverless is a good fit for applications that are not expected to serve traffic on a regular basis, such as development or test environments. So in this case, moving the master to serverless seems kind of backwards.

A. D It s not correct. Why move to serverless?

x A. Run the master in Amazon Aurora MySQL. Create 12 clones in VPC_TEST, and script the clones to be deleted and re-created nightly. (right answer before June 2021 as option D's serverless did not allow clone earlier) x B. snapshot slow x C. Replica not for testing D. Run the master in Amazon Aurora MySQL using Aurora Serverless. Create 12 clones in VPC_TEST, and script the clones to be deleted and re-created nightly. (right answer after 6/2021, serverless v1 supports cloning to same account) https://aws.amazon.com/about-aws/whats-new/2021/06/amazon-aurora-serverless-v1-supports-fast-database-cloning/ https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Managing.Clone.html

A. Although the question does not mention any info about the production database. I am not convinced to move the production to Aurora Serverless, with these limitations in place: Aurora Serverless v1 doesn't support the following features: Aurora global databases Aurora multi-master clusters Aurora Replicas AWS Identity and Access Management (IAM) database authentication Backtracking in Aurora Database activity streams Performance Insights

The best answer will be D after Jun. 21, 2021. According to https://aws.amazon.com/about-aws/whats-new/2021/06/amazon-aurora-serverless-v1-supports-fast-database-cloning/, after Jun. 21, 2021, Amazon Aurora allows you to create clones between Aurora Serverless v1 and provisioned Aurora DB clusters to enable quick sharing of data, i.e., you can create Aurora Serverless v1 clones from Aurora provisioned DB clusters, and you can also create provisioned clones from Aurora Serverless v1 DB clusters.

I got this Question in exam.

Answer: A