Exam AWS-SysOps All Questions

View all questions & answers for the AWS-SysOps exam

Exam AWS-SysOps topic 1 question 776 discussion

Exam question from Amazon's AWS-SysOps

Question #: 776
Topic #: 1

A company wants to increase the availability and durability of a critical business application. The application currently uses a MySQL database running on an
Amazon EC2 instance. The company wants to minimize application changes.
How should the company meet these requirements?

A. Shut down the EC2 instance. Enable multi-AZ replication within the EC2 instance, then restart the instance.
B. Launch a secondary EC2 instance running MySQL. Configure a cron job that backs up the database on the primary EC2 instance and copies it to the secondary instance every 30 minutes.
C. Migrate the database to an Amazon RDS Aurora DB instance and create a Read Replica in another Availability Zone.
D. Create an Amazon RDS Microsoft SQL DB instance and enable multi-AZ replication. Back up the existing data and import it into the new database.

Show Suggested Answer

Suggested Answer: D 🗳️
Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerMultiAZ.html

by nicat at May 8, 2020, 3:51 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

Submit Cancel

AWS_Noob

Highly Voted 2 years, 9 months ago

I'm taking a wild guess here C Even though the want to minimization application changes. They need durability and availability. And have not said anything about NOT changing the platform

upvoted 13 times

angelsrp

2 years, 9 months ago

Trust me, changing the code to use RDS in my opinion are "minimal changes"

upvoted 1 times

...

Golddust

2 years, 9 months ago

I agree with C and since it is compatible with MySQL you can very easily increase Availability and Durability through Aurora.

upvoted 1 times

...

neel376

2 years, 9 months ago

I think C is correct too. Also it is a business critical application which Aurora is good for. Also Aurora automatically has multi az feature built in and will replicate across 3 AZs

upvoted 2 times

...

albert_kuo

Most Recent 12 months ago

Selected Answer: C

Amazon RDS (Relational Database Service) provides managed database services, including the option to migrate the existing MySQL database to Amazon RDS Aurora. Aurora is a MySQL-compatible, highly available and durable database engine with automatic replication and failover capabilities.

upvoted 1 times

...

gulu73

1 year, 5 months ago

Selected Answer: C

Answer is C

upvoted 1 times

...

RicardoD

2 years, 8 months ago

Answer is C

upvoted 1 times

...

zos

2 years, 8 months ago

Answer is C just because you need to change 1 string and it is DB endpoint for app.

upvoted 1 times

...

abhishek_m_86

2 years, 8 months ago

C. Migrate the database to an Amazon RDS Aurora DB instance and create a Read Replica in another Availability Zone.

upvoted 2 times

Chirantan

2 years, 8 months ago

Microsoft SQL DB does not support RDS Aurora

upvoted 1 times

...

jackdryan

2 years, 8 months ago

I'll go with C

upvoted 1 times

...

weril

2 years, 8 months ago

it's C. Most elegant and easy way.

upvoted 1 times

...

A3A3

2 years, 8 months ago

A: doesn't work https://stackoverflow.com/questions/37905421/enable-multi-az-for-running-ec2-instance B: You can loose up to 30 mins of data and will require steps to bring the new server online, pointing to the old data. c: Only one that makes sense, even though it does change the DB. d: My SQL and MS Sql are totally different. Changes the App

upvoted 2 times

...

gilbertlelancelo

2 years, 8 months ago

Microsoft SQL Server differ from MySql, so if we use Microsoft, we also need use a Schema Conversion Tools which bring more changes. But with RDS Auroro MySQL compability we bring minimal change with ENDPOINTS only. Answer C.

upvoted 1 times

...

Ranginprithibi

2 years, 8 months ago

C looks to be best. Reason - Aurora has MySQL as a baseline offering.

upvoted 1 times

...

vramchn

2 years, 9 months ago

I guess the question or answer has typo. Both question and option D corresponds to MySQL or Microsoft. And if so, D is the choice.

upvoted 2 times

ImranR

2 years, 9 months ago

Both are different. So, I think C is correct...

upvoted 1 times

...

waterzhong

2 years, 9 months ago

For changing the DB of an application you just need to change the settings or a few lines of code. For me answer is C.

upvoted 1 times

...

teosinh

2 years, 9 months ago

C is the best chosen.

upvoted 1 times

...

khan11

2 years, 9 months ago

D...We need minimum conf changes mates... migrating it to Aurora is OK but hell lots of configuration changes and the DB is critical... Safest is D.

upvoted 1 times

...

Jimmy5

2 years, 9 months ago

The answer should be C. Check out this reference: https://aws.amazon.com/about-aws/whats-new/2017/01/easy-migration-from-rds-mysql-to-aurora/. It is easy to covert mysql database to Aurora and it fits the requirement "The company wants to minimize application changes."

upvoted 3 times

...

rewiga

2 years, 9 months ago

The answer should be C. While A seems like it would also work, read replicas are what provide high availability. A, should only be fault-tolerant. Aurora is fault-tolerant by design and adding a read replica increases availability.

upvoted 2 times

...

Load full discussion...