SAA-C03 · Question #686
A company is using a SQL database to store movie data that is publicly accessible. The database runs on an Amazon RDS Single-AZ DB instance. A script runs queries at random intervals each day to recor
Sign in or unlock SAA-C03 to reveal the answer and full explanation for question #686. The question stem and answer options stay visible for context.
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 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?
Options
- AModify the DB instance to be a Multi-AZ deployment
- BCreate a read replica of the database. Configure the script to query only the read replica.
- CInstruct the development team to manually export the entries in the database at the end of each
- DUse Amazon ElastiCache to cache the common queries that the script runs against the database
Unlock SAA-C03 to see the answer
You've previewed enough free SAA-C03 questions. Unlock SAA-C03 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.