Topic 1 Question 590
A company migrated a MySQL database from the company's on-premises data center to an Amazon RDS for MySQL DB instance. The company sized the RDS DB instance to meet the company's average daily workload. Once a month, the database performs slowly when the company runs queries for a report. The company wants to have the ability to run reports and maintain the performance of the daily workloads.
Which solution will meet these requirements?
Create a read replica of the database. Direct the queries to the read replica.
Create a backup of the database. Restore the backup to another DB instance. Direct the queries to the new database.
Export the data to Amazon S3. Use Amazon Athena to query the S3 bucket.
Resize the DB instance to accommodate the additional workload.
ユーザの投票
コメント(4)
- 正解だと思う選択肢: A
Create a read replica of the database. Direct the queries to the read replica.
👍 2Guru4Cloud2023/09/14 - 正解だと思う選択肢: A
Clearly the right choice, with a read replica all the queries needed for a report are done in the replica, leaving the primary on best perfomance for write
👍 1TiagueteVital2023/09/02 - 正解だと思う選択肢: A
This is the most cost-effective solution because it does not require any additional AWS services. A read replica is a copy of a database that is synchronized with the primary database. You can direct the queries for the report to the read replica, which will not affect the performance of the daily workloads
👍 1Eminenza222023/09/04
シャッフルモード