Answer-first summary for fast verification
Answer: Migrate to a Multi-AZ setup and supply data scientists with two extra read replicas.
The correct answer is C: 'Migrate to a Multi-AZ setup and supply data scientists with two extra read replicas.' This option provides a cost-effective and highly available solution by using read replicas for read-only access to the database. Read replicas can significantly offload the read traffic from the primary database and can be easily scaled. This approach ensures that the production database's performance will not be impacted by the complex queries from the data scientists.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can a company provide cost-effective, highly available near real-time read-only access to a production Amazon RDS for PostgreSQL database for data scientists, given the database is currently a Single-AZ configuration and the data scientists' complex queries won't impact the production performance?
A
Increase the capacity of the existing production database during a maintenance window to accommodate data scientists' needs.
B
Upgrade to a Multi-AZ deployment, granting data scientists access to the larger secondary standby instance.
C
Migrate to a Multi-AZ setup and supply data scientists with two extra read replicas.
D
Switch to a Multi-AZ cluster, offering data scientists access through two additional readable standby instances.
No comments yet.