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 require significant changes to the existing application and data model, making it less ideal for minimal changes.
Loading data into Amazon ElastiCache is not suitable for running SQL queries as it is primarily an in-memory data store optimized for caching, not querying.
Creating a read replica allows the primary database to offload read queries, thus improving performance without major changes to the application.
Copying data into an Amazon Redshift cluster is not ideal for read-only SQL queries from business analysts, as it requires significant changes and is better suited for analytics workloads.
I figure that the answer is:
Create a read replica of the primary database and have the business analysts run their queries.
From my point of view, the answer is:
Create a read replica of the primary database and have the business analysts run their queries.