A company runs a web application that uses Amazon RDS for MySQL to store relational data. Data in the database does not change frequently. A solutions architect notices that during peak usage times…

Question

Options

• AIntegrate AWS WAF with the application.
• BCreate a read replica for the database. Redirect read traffic to the read replica.
• CCreate an Amazon ElastiCache (Memcached) cluster. Configure the application and the database
• DUse the Amazon S3 One Zone-Infrequent Access (S3 One Zone-IA) storage class to store the
• EMigrate the database to Amazon DynamoDB. Configure the application to use the DynamoDB

• A
  13% (6)
• B
  78% (36)
• D
  2% (1)
• E
  7% (3)

Explanation

To improve read performance for a MySQL-based RDS database under load, you can: Use Read Replicas: Amazon RDS supports MySQL read replicas, which help offload read operations from the primary database, improving performance during high traffic. Use ElastiCache (Memcached): Adding an in-memory cache layer using Amazon ElastiCache reduces the load on the RDS instance by serving frequent queries directly from memory, especially when data is not updated often. Option A (AWS WAF) is for web security, not database performance. Option D relates to storage optimization, not query latency. Option E would require re-architecting from relational to NoSQL, which is unnecessary and

No community discussion yet for this question.