A Company Is Running a Website on Amazon EC2 Instances

question 7

Multiple Choice

A company is running a website on Amazon EC2 instances deployed in multiple Availability Zones (AZs) . The site performs a high number of repetitive reads and writes each second on an Amazon RDS for MySQL Multi-AZ DB instance with General Purpose SSD (gp2) storage. After comprehensive testing and analysis, a database specialist discovers that there is high read latency and high CPU utilization on the DB instance. Which approach should the database specialist to take to resolve this issue without changing the application?

• A) Implementing sharding to distribute the load to multiple RDS for MySQL databases.
• B) Use the same RDS for MySQL instance class with Provisioned IOPS (PIOPS) storage.
• C) Add an RDS for MySQL read replica.
• D) Modify the RDS for MySQL database class to a bigger size and implement Provisioned IOPS (PIOPS).

---

Definitions:

Unconditional Positive Regard

A concept in client-centered therapy proposing absolute acceptance and support of a person regardless of what they say or do.

Factor Analysis

A statistical method used to identify underlying variables, or factors, that explain the pattern of correlations among observed variables.

Personality Trait

Relatively stable and enduring patterns of thought, feeling, and behavior that characterize an individual's responses across a variety of situations.

Growth-Promoting Climate

An environment characterized by support, understanding, and encouragement, fostering personal development and growth.