An Ecommerce Company Has Noticed Performance Degradation of Its Amazon

question 266

Multiple Choice

An ecommerce company has noticed performance degradation of its Amazon RDS based web application. The performance degradation is attributed to an increase in the number of read-only SQL queries triggered by business analysts. A solution architect needs to solve the problem with minimal changes to the existing web application. What should the solution architect recommend?

• A) Export the data to Amazon DynamoDB and have the business analysts run their queries.
• B) Load the data into Amazon ElastiCache and have the business analysts run their queries.
• C) Create a read replica of the primary database and have the business analysts run their queries.
• D) Copy the data into an Amazon Redshift cluster and have the business analysts run their queries.

---

Definitions:

Net Income

The total profit of a company after all revenues, costs, and expenses have been deducted, often referred to as the bottom line.

Sales

The transactions involving the exchange of goods or services for money, constituting the primary revenue source for most businesses.

Variable Manufacturing Costs

Costs that vary directly with the level of production output, such as raw materials and direct labor costs.

Fixed Manufacturing Costs

Overheads or expenses that do not change with the level of production, such as rent and salaries.