DBS-C01 · Question #274
An ecommerce company runs an application on Amazon RDS for SQL Server 2017 Enterprise edition. Due to the increase in read volume, the company's application team is planning to offload the read…
The correct answer is A. Ensure that the automatic backups are turned on for the RDS DB instance C. Ensure the RDS DB instance is set to Multi-AZ. You must enable automatic backups on the source DB instance. To do so, you set the backup retention period to a value other than 0. The source DB instance must be a Multi-AZ deployment with Always On Availability Groups (AGs). Setting this type of deployment also enforces that…
Question
An ecommerce company runs an application on Amazon RDS for SQL Server 2017 Enterprise edition. Due to the increase in read volume, the company's application team is planning to offload the read transactions by adding a read replica to the RDS for SQL Server DB instance. What architectural conditions should a database specialist set? (Choose two.)
Options
- AEnsure that the automatic backups are turned on for the RDS DB instance
- BEnsure the backup retention value is set to 0 for the RDSDB instance
- CEnsure the RDS DB instance is set to Multi-AZ
- DEnsure the RDS DB instance is set to Single-AZ
- EEnsure the RDS DB instance is in a stopped state to turn on the read replica
How the community answered
(36 responses)- A83% (30)
- B11% (4)
- D3% (1)
- E3% (1)
Explanation
You must enable automatic backups on the source DB instance. To do so, you set the backup retention period to a value other than 0. The source DB instance must be a Multi-AZ deployment with Always On Availability Groups (AGs). Setting this type of deployment also enforces that automatic backups are enabled. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.ReadReplicas.html
Topics
Community Discussion
No community discussion yet for this question.