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

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

An online learning company is migrating to the AWS Cloud. The company maintains its student records in a PostgreSQL database. The company needs a solution in which its data is available and online across multiple AWS Regions at all times.

Which solution will meet these requirements with the LEAST amount of operational overhead?

  • A. Migrate the PostgreSQL database to a PostgreSQL cluster on Amazon EC2 instances.
  • B. Migrate the PostgreSQL database to an Amazon RDS for PostgreSQL DB instance with the Multi-AZ feature turned on.
  • C. Migrate the PostgreSQL database to an Amazon RDS for PostgreSQL DB instance. Create a read replica in another Region.
  • D. Migrate the PostgreSQL database to an Amazon RDS for PostgreSQL DB instance. Set up DB snapshots to be copied to another Region.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

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
Steve_4542636
Highly Voted 1 year, 9 months ago
Selected Answer: C
Multi az is not the same as multi regional
upvoted 47 times
...
alexleely
Highly Voted 1 year, 11 months ago
Selected Answer: B
B: Amazon RDS Multi-AZ feature automatically creates a synchronous replica in another availability zone and failover to the replica in the event of an outage. This will provide high availability and data durability across multiple AWS regions which fit the requirements. Though C may sound good, it in fact requires manual management and monitoring of the replication process due to the fact that Amazon RDS read replicas are asynchronous, meaning there is a delay between the primary and read replica. Therefore, there will be a need to ensure that the read replica is constantly up-to-date and someone still has to fix any read replica errors during the replication process which may cause data inconsistency. Lastly, you still have to configure additional steps to make it fail over to the read replica.
upvoted 16 times
Rehan33
1 year, 10 months ago
I go with option B because: Multi-AZ is for high availiblity Read replicas are for low-latency in question they talk about available online
upvoted 4 times
awsgeek75
11 months, 1 week ago
They also ask for multiple regions which is not covered by Multi AZ
upvoted 3 times
...
...
Mahadeva
1 year, 11 months ago
But the question is clearly asking for Multiple Regions. Multi-AZ is not across Regions.
upvoted 22 times
alexleely
1 year, 11 months ago
You are right, Multi-AZ is only within one Region. C would be the right answer.
upvoted 15 times
smartegnine
1 year, 6 months ago
https://aws.amazon.com/rds/features/multi-az/ smartegnine 0 minutes ago Awaiting moderator approval Selected Answer: B In an Amazon RDS Multi-AZ deployment, Amazon RDS automatically creates a primary database (DB) instance and synchronously replicates the data to an instance in a different AZ.
upvoted 1 times
...
...
...
...
hasiet
Most Recent 3 weeks, 5 days ago
Selected Answer: C
C. Migrate the PostgreSQL database to an Amazon RDS for PostgreSQL DB instance. Create a read replica in another Region. This option provides cross-region availability with minimal operational overhead, as RDS manages the replication process for you.
upvoted 2 times
...
akshay243007
5 months ago
Selected Answer: C
Multi AZ is not supported in to diffrent region read Raplica is supported in to diffrent region So I am go with the option C
upvoted 2 times
...
Uzbekistan
9 months ago
Selected Answer: B
Option C involves setting up read replicas in another region, which provides cross-region availability but may introduce additional complexity in managing replication and monitoring. B. Migrate the PostgreSQL database to an Amazon RDS for PostgreSQL DB instance with Multi-AZ: High Availability: Amazon RDS Multi-AZ deployments provide high availability and failover support for DB instances. With Multi-AZ, Amazon RDS automatically provisions and maintains a synchronous standby replica in a different Availability Zone (AZ). In the event of a failure, Amazon RDS automatically fails over to the standby replica, ensuring data availability and minimal downtime. + Cross-Region Replication.
upvoted 1 times
...
pentium75
12 months ago
Selected Answer: C
A - Just no B - Multi-AZ is multiple AZs in same region, does not meet "Multiple AWS Regions" requirement C - Meets requirements D - Does not meet the "online ... at all times" requirement
upvoted 9 times
...
Ruffyit
1 year ago
Multi az is not the same as multi regional
upvoted 2 times
...
vijaykamal
1 year, 2 months ago
Selected Answer: B
Option C, while providing a read replica in another Region, adds complexity to the architecture and may introduce some additional operational overhead compared to Multi-AZ. Cross-Region replication involves setting up and managing replication between two separate RDS instances.
upvoted 1 times
pentium75
12 months ago
But data must be online "across multiple AWS regions"!
upvoted 2 times
...
...
TariqKipkemei
1 year, 3 months ago
Selected Answer: C
Migrate the PostgreSQL database to an Amazon RDS for PostgreSQL DB instance. Create a read replica in another Region
upvoted 3 times
...
Guru4Cloud
1 year, 3 months ago
Selected Answer: C
Multi-AZ is not the same as Multi-Regional
upvoted 4 times
...
Valder21
1 year, 3 months ago
can someone explain why not D
upvoted 3 times
pentium75
12 months ago
"Data must be online (!) across multiple AWS regions at all times (!)". Snapshots are not online.
upvoted 3 times
...
...
beginnercloud
1 year, 3 months ago
Selected Answer: C
key words "AWS Regions at all times" so C is correct
upvoted 2 times
...
fuzzycr
1 year, 5 months ago
Selected Answer: C
key words "AWS Regions at all times"
upvoted 2 times
...
cookieMr
1 year, 5 months ago
Selected Answer: C
By migrating the PostgreSQL database to an RDS for PostgreSQL DB instance and creating a read replica in another AWS Region, you can achieve data availability and online access across multiple Regions. This solution requires less operational overhead compared to managing a PostgreSQL cluster on EC2 instances (Option A) or setting up manual replication using snapshots (Option D). Additionally, Amazon RDS handles the underlying infrastructure and replication setup, reducing the operational complexity for the company. Option B, is a valid solution for achieving high availability within a single AWS Region. However, it does not meet the requirement of having the data available and online across multiple AWS Regions at all times, which is specified in the question. The Multi-AZ feature in RDS provides automatic failover within the same Region, but it does not replicate the data to multiple Regions.
upvoted 6 times
...
mal1903
1 year, 6 months ago
Selected Answer: B
C and D just specifiy another single region. This does not translate to multiple regions. B (Multi-AZ) means the solution will be highly available. The data will be available in multiple regions for both B and C but B is a better solution!
upvoted 1 times
Guru4Cloud
1 year, 3 months ago
its data is available and online across multiple AWS Regions at all times
upvoted 1 times
...
pentium75
12 months ago
"Another single region" plus the original region ARE of course "multiple regions", what else? While B "Multi-AZ" is two AZs in the same region.
upvoted 2 times
...
...
MrAWSAssociate
1 year, 6 months ago
Selected Answer: C
Answer B is not right, because "RDS Multi-AZ" always span at least two Availability Zones within a single region and the question requirment RDS DB should be available in multiple regions. Therefore, C is the most suitable answer for this question.
upvoted 3 times
MrAWSAssociate
1 year, 6 months ago
I would like to change my answer to "B". The question has some distractor words: "its data is available and online across multiple AWS Regions at all times". We agree that AWS is a could service available online around the world in 99 regions. So the option "B" is the most appropriate answer, since multi-AZ focuses on the avialability factor and it has the LEAST amount of operational overhead.
upvoted 1 times
...
...
abhishek2021
1 year, 6 months ago
Selected Answer: B
B & C both makes data available. However, B is less overhead. What I think, the question is asking for data availability across multiple regions not for a DR solution. So, RDS being accessible over public IP will do the trick for data being available across regions.
upvoted 1 times
Guru4Cloud
1 year, 3 months ago
Multi-AZ is not the same as Multi-Regional
upvoted 1 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