ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

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

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C02 exam
Go to Exam

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

Exam question from Amazon's AWS Certified Solutions Architect - Associate SAA-C02
Question #: 403
Topic #: 1
[All AWS Certified Solutions Architect - Associate SAA-C02 Questions]

A company is preparing to migrate its on-premises application to AWS. The application consists of application servers and a Microsoft SQL Server database The database cannot be migrated to a different engine because SQL Server features are used in the application's NET code. The company wants to attain the greatest availability possible while minimizing operational and management overhead.
What should a solutions architect do to accomplish this?

  • A. Install SQL Server on Amazon EC2 in a Multi-AZ deployment.
  • B. Migrate the data to Amazon RDS for SQL Server in a Multi-AZ deployment.
  • C. Deploy the database on Amazon RDS for SQL Server with Multi-AZ Replicas.
  • D. Migrate the data to Amazon RDS for SQL Server in a cross-Region Multi-AZ deployment.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by dmscountera at March 11, 2021, 7:11 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

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
Submit Cancel
Alileva
Highly Voted 3 years, 7 months ago
Answer is B and not D because: Microsoft SQL Server Multi-AZ deployment notes and recommendations The following are some restrictions when working with Multi-AZ deployments for Microsoft SQL Server DB instances: Cross-Region Multi-AZ isn't supported. You can't configure the secondary DB instance to accept database read activity. Multi-AZ with Always On Availability Groups (AGs) supports in-memory optimization. Multi-AZ with Always On Availability Groups (AGs) doesn't support Kerberos authentication for the availability group listener. This is because the listener has no Service Principal Name (SPN). You can't rename a database on a SQL Server DB instance that is in a SQL Server Multi-AZ deployment. If you need to rename a database on such an instance, first turn off Multi-AZ for the DB instance, then rename the database. Finally, turn Multi-AZ back on for the DB instance. You can only restore Multi-AZ DB instances that are backed up using the full recovery model.
upvoted 73 times
...
syu31svc
Highly Voted 3 years, 7 months ago
"database cannot be migrated to a different engine" -> Amazon RDS for SQL Server so A is wrong No such thing as "cross-Region Multi-AZ deployment" so D is wrong "migrate" so C is wrong (deploy) Answer is B
upvoted 16 times
...
ahaz
Most Recent 2 years, 10 months ago
Selected Answer: B
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerMultiAZ.html
upvoted 3 times
...
queen101
2 years, 10 months ago
BBBBBBBBBBBBBBBBBB
upvoted 1 times
...
Alfene
2 years, 10 months ago
B is correct
upvoted 1 times
...
marklovesaws143
2 years, 10 months ago
Selected Answer: B
BBBBBBBBBBBBBBBB
upvoted 1 times
...
slcheng
2 years, 11 months ago
Selected Answer: B
Make Availability
upvoted 1 times
...
musty212
2 years, 11 months ago
Selected Answer: B
it also says the cost effective.
upvoted 1 times
...
SimoneP
3 years, 4 months ago
Selected Answer: B
ANS B. it' migrate not deploy, so C is wrong
upvoted 1 times
...
gargaditya
3 years, 6 months ago
A is not best way of doing database when we have AWS managed RDS. D is out because RDS does not support multi region(Aurora has this in form of GLobal Aurora). Multi AZ can have its nodes configured as read replicas(it is possible)--but only for MySQL and MariaDB (https://aws.amazon.com/about-aws/whats-new/2018/01/amazon-rds-read-replicas-now-support-multi-az-deployments/) Would choose B over C.
upvoted 1 times
gargaditya
3 years, 6 months ago
Quick listing of features with Aurora/RDS in table format: https://1drv.ms/x/s!Al2WmWQmp2xZtmVg-9uLU1O6Rhdl
upvoted 2 times
...
rein_chau
2 years, 8 months ago
At this time (2022), SQL Server supports Multi-AZ read replicas. We exclude C because it's "Deploy", not "Migrate". https://aws.amazon.com/blogs/database/using-in-region-read-replicas-in-amazon-rds-for-sql-server/
upvoted 1 times
...
...
vvsandipvv
3 years, 7 months ago
D because what if whole region is under nuclear warfare!! . . . . . just kidding its B
upvoted 6 times
...
Balki
3 years, 7 months ago
Answer C I was trying to gain some attention. I would go with answer B too :) This is one of those questions where we dont have any other answers.
upvoted 1 times
...
KittuCheeku
3 years, 7 months ago
I would go for option B
upvoted 3 times
...
Sallywhite
3 years, 7 months ago
B is right
upvoted 3 times
...
waqas
3 years, 7 months ago
Yes Its B.
upvoted 2 times
...
dmscountera
3 years, 8 months ago
B. Migrate the data to Amazon RDS for SQL Server in a Multi-AZ deployment.
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