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

Exam AWS Certified Solutions Architect - Associate SAA-C02 topic 1 question 502 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
patriktre
Highly Voted 3 years, 7 months ago
answer is C. https://aws.amazon.com/blogs/aws/cross-region-read-replicas-for-amazon-rds-for-mysql/ ...Scale Out Globally – If your application has a user base that is spread out all over the planet, you can use Cross Region Read Replicas to serve read queries from an AWS region that is close to the user...
upvoted 27 times
patriktre
3 years, 7 months ago
link for postgesql: https://aws.amazon.com/blogs/database/best-practices-for-amazon-rds-for-postgresql-cross-region-read-replicas/
upvoted 4 times
...
...
Jamati
Highly Voted 3 years, 6 months ago
Answer is C Key word here is "multiple regions"
upvoted 6 times
...
BECAUSE
Most Recent 1 year, 11 months ago
Selected Answer: C
C is the answer
upvoted 1 times
...
Samuel03
2 years, 2 months ago
Selected Answer: C
Should be C
upvoted 1 times
...
sk_sk
2 years, 7 months ago
Selected Answer: C
multiregion
upvoted 1 times
...
jw1806
2 years, 7 months ago
Selected Answer: B
answer is B, Create a read replica in ANOTHER Region won't solve the requirement with multiple regions.
upvoted 1 times
...
rude7
2 years, 8 months ago
Selected Answer: C
Multi-Az is only for disaster recovery and does not allow active-active configuration where users can read from all times as the question suggests. In order to satisfy this then read replicas need to be utilized. https://www.whizlabs.com/blog/aws-rds-multi-az-read-replica/
upvoted 2 times
...
reve666
2 years, 10 months ago
Selected Answer: C
answer is C
upvoted 1 times
...
SmartDude
3 years, 2 months ago
Selected Answer: B
"Always Accessible & Multiple Region" = Multi AZ.
upvoted 2 times
Ivanyan
3 years, 2 months ago
Multi-AZ is not equal to Multiple Region...
upvoted 6 times
th3cookie
2 years, 9 months ago
Why are people who don't have practitioner exam knowledge, commenting on associate exam like this?
upvoted 1 times
...
...
allanm
2 years, 9 months ago
Are you forgetting the difference between multi-AZ and multi-region? lol
upvoted 2 times
...
...
tin2022
3 years, 3 months ago
C . With Amazon RDS, you can create a MariaDB, MySQL, Oracle, or PostgreSQL read replica in a different AWS Region from the source DB instance. Creating a cross-Region read replica isn't supported for SQL Server on Amazon RDS.
upvoted 2 times
...
Rickywsiek
3 years, 4 months ago
Selected Answer: C
Multi region so its C
upvoted 2 times
...
BlassArun
3 years, 4 months ago
Ans is B
upvoted 1 times
...
yottabyte
3 years, 6 months ago
B is the answer. Multi-AZ is for high availability. Question says it has to be online at all times. if the primary RDS in one AZ goes down, then only read replicas will be there and you can't write data anywhere until a read replica instance is made the Primary / Master.
upvoted 3 times
msama
3 years, 5 months ago
...accessible across several AWS regions. B is wrong.
upvoted 5 times
...
eBooKz
3 years ago
If the primary/master goes down, a secondary is promoted. I stick with C.
upvoted 1 times
...
...
mrkid3085
3 years, 6 months ago
Read replicas is not create stanby node. Multi-AZ support read replicas and create stanby node. I choose B.
upvoted 3 times
Jonfernz
3 years, 6 months ago
the question is looking for a solution for multi-region reads. your answer is wrong, bud.
upvoted 4 times
...
...
gentos
3 years, 7 months ago
B.. multi az and least amount of effort
upvoted 2 times
MarianoD
3 years, 6 months ago
MULTIPLE REGIONS dUDE. READ HERE: https://aws.amazon.com/blogs/database/best-practices-for-amazon-rds-for-postgresql-cross-region-read-replicas/
upvoted 1 times
...
Jonfernz
3 years, 6 months ago
Scenario clearly states "The company needs a solution in which its data is available and online across multiple AWS Regions at all times". ---- Data must be available acrss multiple REGIONS ---> Create read replicas in another region. C!
upvoted 3 times
...
...
mo1311990
3 years, 7 months ago
C option
upvoted 2 times
...
ABC1503
3 years, 7 months ago
with option D - "data is available and online" will not be fulfilled. Hence 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago