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 566 discussion

A company has deployed a database in Amazon RDS for MySQL. Due to increased transactions, the database support team is reporting slow reads against the
DB instance and recommends adding a read replica.
Which combination of actions should a solutions architect take before implementing this change? (Choose two.)

  • A. Enable binlog replication on the RDS primary node.
  • B. Choose a failover priority for the source DB instance.
  • C. Allow long-running transactions to complete on the source DB instance.
  • D. Create a global table and specify the AWS Regions where the table will be available.
  • E. Enable automatic backups on the source instance by setting the backup retention period to a value other than 0.
Show Suggested Answer Hide Answer
Suggested Answer: CE 🗳️

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
kevinsnow
Highly Voted 3 years, 5 months ago
C,E "An active, long-running transaction can slow the process of creating the read replica. We recommend that you wait for long-running transactions to complete before creating a read replica. If you create multiple read replicas in parallel from the same source DB instance, Amazon RDS takes only one snapshot at the start of the first create action. When creating a read replica, there are a few things to consider. First, you must enable automatic backups on the source DB instance by setting the backup retention period to a value other than 0. This requirement also applies to a read replica that is the source DB instance for another read replica" https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html
upvoted 44 times
...
StacyY
Most Recent 1 year, 9 months ago
A and E, E backup is needed for creating read replica, A binlog is needed for the read replica to apply binlogs to keep syncup with the primary.
upvoted 1 times
...
BECAUSE
2 years ago
Selected Answer: CE
C and E are the correct answers
upvoted 1 times
...
awsas2022
2 years, 10 months ago
What is the correct answer ?
upvoted 1 times
...
marklovesaws143
2 years, 10 months ago
Selected Answer: CE
CECECECECECE
upvoted 1 times
...
slcheng
2 years, 11 months ago
Selected Answer: CE
vote CE
upvoted 2 times
...
etheng1970
2 years, 11 months ago
C and E. Not D, as it question is for RDS NOT DynamoDB
upvoted 1 times
...
The_Sun
3 years, 4 months ago
Selected Answer: CE
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html
upvoted 1 times
...
sayed
3 years, 4 months ago
C & E Before a MySQL DB instance can serve as a replication source, make sure to enable automatic backups on the source DB instance. To do this, set the backup retention period to a value other than 0. Preparing MySQL DB instances that use MyISAM https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_MySQL.Replication.ReadReplicas.html
upvoted 2 times
...
momedkri117
3 years, 4 months ago
Selected Answer: CE
C&E An active, long-running transaction can slow the process of creating the read replica. We recommend that you wait for long-running transactions to complete before creating a read replica. If you create multiple read replicas in parallel from the same source DB instance, Amazon RDS takes only one snapshot at the start of the first create action. When creating a read replica, there are a few things to consider. First, you must enable automatic backups on the source DB instance by setting the backup retention period to a value other than 0. This requirement also applies to a read replica that is the source DB instance for another read replica. To enable automatic backups on an RDS for MySQL version 5.6 and later read replica, first create the read replica, then modify the read replica to enable automatic backups. Link: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html
upvoted 4 times
...
Robert_B
3 years, 4 months ago
Selected Answer: CE
C- An active, long-running transaction can slow the process of creating the read replica. We recommend that you wait for long-running transactions to complete before creating a read replica. If you create multiple read replicas in parallel from the same source DB instance, Amazon RDS takes only one snapshot at the start of the first create action. E-When creating a read replica, there are a few things to consider. First, you must enable automatic backups on the source DB instance by setting the backup retention period to a value other than 0.
upvoted 4 times
...
jennyka76
3 years, 5 months ago
C-E https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_MySQL.Replication.ReadReplicas.html#USER_MySQL.Replication.ReadReplicas.Configuration
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 ...