Topic 1 Question 536
A company wants to provide data scientists with near real-time read-only access to the company's production Amazon RDS for PostgreSQL database. The database is currently configured as a Single-AZ database. The data scientists use complex queries that will not affect the production database. The company needs a solution that is highly available.
Which solution will meet these requirements MOST cost-effectively?
Scale the existing production database in a maintenance window to provide enough power for the data scientists.
Change the setup from a Single-AZ to a Multi-AZ instance deployment with a larger secondary standby instance. Provide the data scientists access to the secondary instance.
Change the setup from a Single-AZ to a Multi-AZ instance deployment. Provide two additional read replicas for the data scientists.
Change the setup from a Single-AZ to a Multi-AZ cluster deployment with two readable standby instances. Provide read endpoints to the data scientists.
ユーザの投票
コメント(17)
- 正解だと思う選択肢: D
Highly Available = Multi-AZ Cluster Read-only + Near Real time = readable standby. Read replicas are async whereas readable standby is synchronous. https://stackoverflow.com/questions/70663036/differences-b-w-aws-read-replica-and-the-standby-instances
👍 14NASHDBA2023/07/08 It's either C or D. To be honest, I find the newest questions to be ridiculously hard (roughly 500+). I agree with @alexandercamachop that Multi Az in Instance mode is cheaper than Cluster. However, with Cluster we have reader endpoint available to use out-of-box, so there is no need to provide read-replicas, which also has its own costs. The ridiculous part is that I'm pretty sure even the AWS support would have troubles to answer which configuration is MOST cost-effective.
👍 10maver1442023/06/12- 正解だと思う選択肢: C
C. The question says highly available therefor Multi Az deployment. Also mentions cost consideration. database instance is cheaper then cluster (D). Also read replicas is a must since the queries are complex and can slow down the database (question has not complex queries but is a mistake must have been complex queries)
👍 4alexandercamachop2023/06/07
シャッフルモード