Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

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

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

Exam AWS Certified Solutions Architect - Associate SAA-C03 topic 1 question 539 discussion

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

A company wants to use the AWS Cloud to improve its on-premises disaster recovery (DR) configuration. The company's core production business application uses Microsoft SQL Server Standard, which runs on a virtual machine (VM). The application has a recovery point objective (RPO) of 30 seconds or fewer and a recovery time objective (RTO) of 60 minutes. The DR solution needs to minimize costs wherever possible.

Which solution will meet these requirements?

  • A. Configure a multi-site active/active setup between the on-premises server and AWS by using Microsoft SQL Server Enterprise with Always On availability groups.
  • B. Configure a warm standby Amazon RDS for SQL Server database on AWS. Configure AWS Database Migration Service (AWS DMS) to use change data capture (CDC).
  • C. Use AWS Elastic Disaster Recovery configured to replicate disk changes to AWS as a pilot light.
  • D. Use third-party backup software to capture backups every night. Store a secondary set of backups in Amazon S3.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Bill1000 at June 6, 2023, 6:25 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 (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
1Alpha1
Highly Voted 9 months, 3 weeks ago
Selected Answer: B
Backup & Restore (RPO in hours, RTO in 24 hours or less) Pilot Light (RPO in minutes, RTO in hours) Warm Standby (RPO in seconds, RTO in minutes) *** Right Answer *** Active-Active (RPO is none or possibly seconds, RTO in seconds)
upvoted 7 times
1Alpha1
9 months, 3 weeks ago
https://disaster-recovery.workshop.aws/en/intro/disaster-recovery.html#:~:text=Pilot%20Light%20(RPO%20in%20minutes,that%20includes%20that%20critical%20core.
upvoted 3 times
...
...
pentium75
Highly Voted 10 months, 3 weeks ago
Selected Answer: C
Not A - too expensive and not using AWS services Not B - "RDS for SQL Server" does not support everything that "SQL Server Standard which runs on a VM" does; CDC supports even less (https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html). Also it would be more expensive than C. Not D - "Every night" would not meet the RPO requirement
upvoted 6 times
awsgeek75
10 months, 2 weeks ago
Thanks I was confused between B and C. This makes perfect sense!
upvoted 1 times
...
...
example_
Most Recent 3 months, 3 weeks ago
Selected Answer: B
Pilot light (RPO in minutes, RTO in tens of minutes) Warm standby (RPO in seconds, RTO in minutes) https://docs.aws.amazon.com/wellarchitected/latest/reliability-pillar/rel_planning_for_recovery_disaster_recovery.html
upvoted 1 times
MrAliMohsan
3 months ago
When cost is a concern, and you wish to achieve a similar RPO and RTO objectives as defined in the warm standby strategy, you could consider cloud native solutions, like AWS Elastic Disaster Recovery, that take the pilot light approach and offer improved RPO and RTO targets.
upvoted 1 times
...
...
abhiarns
7 months, 1 week ago
Selected Answer: C
AWS DRS(AWS Elastic Disaster Recovery) enables RPOs of seconds and RTOs of minutes.
upvoted 1 times
...
osmk
9 months ago
Selected Answer: B
https://docs.aws.amazon.com/whitepapers/latest/disaster-recovery-workloads-on-aws/disaster-recovery-options-in-the-cloud.html#warm-standby
upvoted 2 times
...
awsgeek75
10 months ago
Selected Answer: C
A: Not possible B: With RDS it means your failover will launch a different database engine. This is wrong in general D: No comments C: It is a disk based replication so it will be similar DB server and this is the product managed by AWS for the DR of on-prem setups. https://aws.amazon.com/blogs/modernizing-with-aws/how-to-set-up-disaster-recovery-for-sql-server-always-on-availability-groups-using-aws-elastic-disaster-recovery/
upvoted 1 times
...
1rob
11 months, 3 weeks ago
Selected Answer: C
AWS Elastic Disaster Recovery If you are considering the pilot light or warm standby strategy for disaster recovery, AWS Elastic Disaster Recovery could provide an alternative approach with improved benefits. Elastic Disaster Recovery can offer an RPO and RTO target similar to warm standby, but maintain the low-cost approach of pilot light From <https://docs.aws.amazon.com/wellarchitected/latest/reliability-pillar/rel_planning_for_recovery_disaster_recovery.html>
upvoted 3 times
...
potomac
1 year ago
Selected Answer: B
With the pilot light approach, you replicate your data from one environment to another and provision a copy of your core workload infrastructure, not the fully functional copy of your production environment in a recovery environment.
upvoted 1 times
saymolet
11 months, 2 weeks ago
https://aws.amazon.com/blogs/architecture/disaster-recovery-dr-architecture-on-aws-part-iii-pilot-light-and-warm-standby/
upvoted 2 times
...
pentium75
10 months, 3 weeks ago
We have no idea if they are using SQL Server features that require OS customization etc., so we can't assume that the app would run on RDS for SQL Server at all. We need a replica of the VM that SQL Server is currently running on, thus C.
upvoted 1 times
...
...
thanhnv142
1 year ago
C: Pilot light - In pilot light, databases are always on, thus minimize RPO (can satisfy the 30s requirement) - Only apps are turn off. But it can satisfy the 60 minutes requirement - Warm standby, of cource, can satisfy all the RPO and RTO requirements, but it is more expensive than pilot light
upvoted 3 times
...
richguo
1 year, 2 months ago
Selected Answer: C
B(warm standby) is doable, but C (pilot light) is most cost effectively. https://aws.amazon.com/tw/blogs/architecture/disaster-recovery-dr-architecture-on-aws-part-iii-pilot-light-and-warm-standby/
upvoted 2 times
...
LazyTs
1 year, 2 months ago
Selected Answer: B
The company wants to improve... so needs something guaranteed to be better than 60 mins RTO
upvoted 1 times
...
Guru4Cloud
1 year, 3 months ago
Selected Answer: B
Configure a warm standby Amazon RDS for SQL Server database on AWS. Configure AWS Database Migration Service (AWS DMS) to use change data capture (CDC).
upvoted 2 times
Eminenza22
1 year, 3 months ago
Warm standby is costlier than Pilot Light
upvoted 2 times
...
...
PantryRaid
1 year, 3 months ago
Selected Answer: C
AWS DRS enables RPOs of seconds and RTOs of minutes. Pilot light is also cheaper than warm standby. https://aws.amazon.com/disaster-recovery/
upvoted 3 times
...
BlueAIBird
1 year, 3 months ago
C is correct. Since it is not only your core elements that are running all the time, warm standby is usually more costly than pilot light. Warm standby is another example of active/passive failover configuration. Servers can be left running in a minimum number of EC2 instances on the smallest sizes possible. Ref: https://tutorialsdojo.com/backup-and-restore-vs-pilot-light-vs-warm-standby-vs-multi-site/#:~:text=Since%20it%20is%20not%20only,on%20the%20smallest%20sizes%20possible.
upvoted 1 times
...
hozy_
1 year, 4 months ago
Selected Answer: C
https://aws.amazon.com/ko/blogs/architecture/disaster-recovery-dr-architecture-on-aws-part-iii-pilot-light-and-warm-standby/ It says Pilot Light costs less than Warm Standby.
upvoted 1 times
...
narddrer
1 year, 4 months ago
Selected Answer: B
https://stepstocloud.com/change-data-capture/?expand_article=1
upvoted 1 times
darekw
1 year, 2 months ago
Based on this link Change Data Capture (CDC) in AWS is a mechanism for tracking changes to data in DynamoDB tables. And the question refers to Microsoft SQL Server Standard
upvoted 1 times
darekw
1 year, 2 months ago
ok, it's also fror SQL servers: SQL Server Change Data Capture (CDC) is a feature that enables you to capture insert, update, and delete activity on a SQL Server table,
upvoted 1 times
pentium75
10 months, 3 weeks ago
Yeah, but still it doesn't make sense here, it does not support various SQL Server features.
upvoted 1 times
...
...
...
...
Zox42
1 year, 4 months ago
Selected Answer: C
Answer C. RPO is in seconds and RTO 5-20 min; pilot light costs less than warm standby (and of course less than active-active). https://docs.aws.amazon.com/drs/latest/userguide/failback-overview.html#recovery-objectives
upvoted 1 times
...
Load full discussion...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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