What should the solutions architect recommend?
Export the data to Amazon DynamoDB and have the business analysts run their queries.
Load the data into Amazon ElastiCache and have the business analysts run their queries.
Create a read replica of the primary database and have the business analysts run their queries.
Copy the data into an Amazon Redshift cluster and have the business analysts run their queries.
Explanations:
Exporting data to Amazon DynamoDB would involve significant changes to the data model and application logic. It is not optimized for complex SQL queries that the business analysts might require, and could introduce additional complexity in managing data consistency and availability.
While loading data into Amazon ElastiCache can improve performance for read-heavy workloads, it is typically used for caching rather than as a primary source for SQL queries. This option may not support the necessary complex querying capabilities and would require changes to how the business analysts access data.
Creating a read replica of the primary database allows the business analysts to run their read-only queries without impacting the performance of the primary database. This approach maintains SQL capabilities, minimizes changes to the existing application, and allows for improved scalability for read operations.
Copying data into an Amazon Redshift cluster is suitable for analytical queries but would require significant changes to the data handling process, including ETL processes for data loading and possibly altering how business analysts interact with the data. It may not be optimal for real-time query performance compared to a read replica.
I value that the answer is:
Create a read replica of the primary database and have the business analysts run their queries.