Question: A company is using a SQL database to store movie data that is publicly accessible. The database runs on an Amazon RDS Single - AZ
A company is using a SQL database to store movie data that is publicly accessible. The database runs on an Amazon RDS SingleAZ DB instance A script runs queries at random intervals each day to record the number of new movies that have been added to the database. The script must report a final total during business hours The company's development team notices that the database performance is inadequate for development tasks when the script is running. A solutions architect must recommend a solution to resolve this issue. Which solution will meet this requirement with the LEAST operational overhead?
A Modify the DB instance to be a MultiAZ deployment
B Create a read replica of the database Configure the script to query only the read replica.
C Instruct the development team to manually export the entries in the database at the end of each day.
D Use Amazon ElastiCache to cache the common queries that the script runs against the database
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
