exam questions

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
[All AWS-SysOps Questions]

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 Hide Answer
Suggested Answer: D 🗳️
Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerMultiAZ.html

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
AWS_Noob
Highly Voted 2 years, 7 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, 6 months ago
Trust me, changing the code to use RDS in my opinion are "minimal changes"
upvoted 1 times
...
Golddust
2 years, 7 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, 7 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 9 months, 3 weeks 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, 2 months ago
Selected Answer: C
Answer is C
upvoted 1 times
...
RicardoD
2 years, 6 months ago
Answer is C
upvoted 1 times
...
zos
2 years, 6 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, 6 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, 6 months ago
Microsoft SQL DB does not support RDS Aurora
upvoted 1 times
...
...
jackdryan
2 years, 6 months ago
I'll go with C
upvoted 1 times
...
weril
2 years, 6 months ago
it's C. Most elegant and easy way.
upvoted 1 times
...
A3A3
2 years, 6 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, 6 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, 6 months ago
C looks to be best. Reason - Aurora has MySQL as a baseline offering.
upvoted 1 times
...
vramchn
2 years, 6 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, 6 months ago
Both are different. So, I think C is correct...
upvoted 1 times
...
...
waterzhong
2 years, 6 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, 6 months ago
C is the best chosen.
upvoted 1 times
...
khan11
2 years, 6 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, 6 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, 6 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
...
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago