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

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Amazon Discussions

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: D 🗳️
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 5 months 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
5 months 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 6 months 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 5 times
awsgeek75
5 months, 3 weeks ago
Thanks I was confused between B and C. This makes perfect sense!
upvoted 1 times
...
...
abhiarns
Most Recent 2 months, 3 weeks ago
Selected Answer: C
AWS DRS(AWS Elastic Disaster Recovery) enables RPOs of seconds and RTOs of minutes.
upvoted 1 times
...
osmk
4 months, 2 weeks 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
5 months, 2 weeks 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
7 months, 1 week 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 2 times
...
potomac
8 months 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
6 months, 4 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
6 months 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
8 months, 2 weeks 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
9 months, 3 weeks 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
10 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
10 months, 2 weeks 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
10 months, 2 weeks ago
Warm standby is costlier than Pilot Light
upvoted 2 times
...
...
PantryRaid
10 months, 3 weeks 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
11 months, 1 week 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_
11 months, 3 weeks 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
12 months ago
Selected Answer: B
https://stepstocloud.com/change-data-capture/?expand_article=1
upvoted 1 times
darekw
10 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
10 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
6 months ago
Yeah, but still it doesn't make sense here, it does not support various SQL Server features.
upvoted 1 times
...
...
...
...
Zox42
12 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
...
haoAWS
1 year ago
Selected Answer: B
The answer should be B. ACD cannot make the RPO for only 30 seconds.
upvoted 1 times
haoAWS
1 year ago
Sorry for mistake, A can also make RPO very low, but A is more expensive than B.
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
ex Want to SAVE BIG on Certification Exam Prep?
close
ex Unlock All Exams with ExamTopics Pro 75% Off
  • arrow Choose From 1000+ Exams
  • arrow Access to 10 Exams per Month
  • arrow PDF Format Available
  • arrow Inline Discussions
  • arrow No Captcha/Robot Checks
Limited Time Offer
Ends in

Claim Offer Now
286 people claimed it in the last 6 hours