RDS Performance Quiz

What you'll be asked

1. Which AWS RDS feature is most effective for offloading read-heavy database workloads from the primary database instance?
2. You notice your RDS instance is experiencing high CPU utilization. Which tool would best help you identify specific long-running or resource-intensive SQL queries?
3. An RDS database is performing slowly due to high disk I/O latency. Which action is the most direct way to improve I/O performance without changing the database engine?
4. Your application uses many short-lived connections to the RDS database, leading to high overhead on the database for connection management. What is the recommended solution to optimize this?
5. A database instance shows high 'Freeable Memory' but high 'Swap Usage'. What does this indicate and how should you address it?

Answers and explanations come after you submit.