SAP-C02 Question 641
Select 3Your company runs a social media analytics platform that stores user interaction data. The platform uses Amazon DynamoDB for storing structured metadata, Amazon OpenSearch Service for enabling full-text search, and an Amazon RDS PostgreSQL database for complex reporting and analytics. Recently, the reporting team has observed significant performance degradation in analytical queries on the RDS database. Upon investigation, you find that the database is experiencing high read IOPS due to frequent queries on historical data. How can you improve the performance of the analytical queries cost-effectively?
- A
Use Amazon ElastiCache to cache frequently accessed query results.
- B
Enable DynamoDB Streams to replicate data into Amazon OpenSearch Service for analytical queries.
- C
Implement an Amazon RDS Read Replica and direct analytical queries to the replica.
- D
Migrate historical data to Amazon S3 and use Amazon Athena for analytical queries.
- E
Upgrade the RDS instance to a larger instance type with more CPU and memory.
Show answer and explanation
Correct answers: A, C, D
Explanation
To address the performance issues on the RDS database, you can use multiple strategies. ElastiCache reduces read IOPS by caching frequently accessed query results, while an RDS Read Replica offloads read operations, improving performance. Additionally, migrating historical data to Amazon S3 and querying it using Amazon Athena is a cost-effective approach for analytical workloads. Simply upgrading the RDS instance is a costly solution and does not resolve the underlying issue, and DynamoDB Streams is not relevant for this scenario.
- A. Correct.
Using Amazon ElastiCache can help reduce the read IOPS on the RDS database by caching frequently accessed query results and serving them from the cache instead of querying the database repeatedly.
- B. Incorrect.
DynamoDB Streams is used for capturing and processing item-level changes in a table. Replicating data into Amazon OpenSearch Service is not suitable for complex analytical queries that require relational data.
- C. Correct.
Implementing an RDS Read Replica reduces the read burden on the primary database by offloading read workloads to replicas, improving performance for analytical queries.
- D. Correct.
Migrating historical data to S3 and using Amazon Athena for queries is a cost-effective solution for handling large datasets and reducing the load on the RDS database.
- E. Incorrect.
Upgrading the RDS instance may temporarily improve performance but can be expensive and does not address the core issue of high read IOPS caused by analytical queries on historical data.