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

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 215 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 215
Topic #: 1
[All AWS Certified Database - Specialty Questions]

A company is running a business-critical application on premises by using Microsoft SQL Server. A database specialist is planning to migrate the instance with several databases to the AWS Cloud. The database specialist will use SQL Server Standard edition hosted on Amazon EC2 Windows instances. The solution must provide high availability and must avoid a single point of failure in the SQL Server deployment architecture.
Which solution will meet these requirements?

  • A. Create Amazon RDS for SQL Server Multi-AZ DB instances. Use Amazon S3 as a shared storage option to host the databases.
  • B. Set up Always On Failover Cluster Instances as a single SQL Server instance. Use Multi-AZ Amazon FSx for Windows File Server as a shared storage option to host the databases.
  • C. Set up Always On availability groups to group one or more user databases that fail over together across multiple SQL Server instances. Use Multi-AZ Amazon FSx for Windows File Server as a shared storage option to host the databases.
  • D. Create an Application Load Balancer to distribute database traffic across multiple EC2 instances in multiple Availability Zones. Use Amazon S3 as a shared storage option to host the databases.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by mbar94 at Sept. 5, 2022, 6:44 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

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
JeanGat
Highly Voted 2 years, 8 months ago
Selected Answer: B
https://docs.aws.amazon.com/prescriptive-guidance/latest/migration-sql-server/ec2-fci.html An FCI is generally preferable over an Always on availability group when: You’re using SQL Server Standard edition instead of Enterprise edition.
upvoted 9 times
...
vkruger
Most Recent 2 years, 6 months ago
Selected Answer: B
Answer is B. Key word "SQL Server Standard edition"
upvoted 1 times
...
Sab
2 years, 6 months ago
B is right. C is incorrect because it is mentioned to use FSx for hosting databases.
upvoted 1 times
...
RBSK
2 years, 7 months ago
Selected Answer: B
B is right
upvoted 1 times
...
DBA_MJF
2 years, 7 months ago
C - https://aws.amazon.com/about-aws/whats-new/2021/02/amazon-rds-for-sql-server-now-supports-always-on-availability-groups-for-standard-edition/
upvoted 3 times
...
awsjjj
2 years, 7 months ago
Selected Answer: B
C requires dedicated storage for each instance B is correct
upvoted 1 times
...
Changwha
2 years, 8 months ago
Selected Answer: B
An FCI is generally preferable over an Always on availability group when you’re using SQL Server Standard edition instead of Enterprise edition.
upvoted 1 times
...
cloudsunriser
2 years, 8 months ago
Selected Answer: C
RDS is not in picture. FsX for shared storage on windows ec2 instances. C is correct.
upvoted 1 times
...
zoomac
2 years, 9 months ago
B: SQL Server Standard edition: FCI. For C you need SQL Server Enterprise Edition.
upvoted 4 times
RBSK
2 years, 7 months ago
Agree. SQL AAG needs Enterprise Edition
upvoted 3 times
Germaneli
1 year, 8 months ago
Or not? https://aws.amazon.com/about-aws/whats-new/2021/02/amazon-rds-for-sql-server-now-supports-always-on-availability-groups-for-standard-edition/
upvoted 1 times
...
...
...
mbar94
2 years, 9 months ago
Selected Answer: C
Agree with C.
upvoted 3 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