A Company's Website Is Using an Amazon RDS MySQL Multi-AZ

question 206

Multiple Choice

A company's website is using an Amazon RDS MySQL Multi-AZ DB instance for its transactional data storage. There are other internal systems that query this DB instance to fetch data for internal batch processing. The RDS DB instance slows down significantly when the internal systems fetch data. This impacts the website's read and write performance, and the users experience slow response times. Which solution will improve the website's performance?

• A) Use an RDS PostgreSQL DB instance instead of a MySQL database.
• B) Use Amazon ElastiCache to cache the query responses for the website.
• C) Add an additional Availability Zone to the current RDS MySQL Multi-AZ DB instance.
• D) Add a read replica to the RDS DB instance and configure the internal systems to query the read replica.

---

Definitions:

Data Type

A classification identifying one of various types of data, such as integer, floating-point, or string, that determines the possible values for that type, the operations that can be done on it, and the way it is stored.

Margins Button

A feature in document editing software that allows users to adjust the space between the text and the edges of the page.

Print Preview Tab

A feature in software applications that allows users to see exactly how a document will look when printed, before actually printing it.

Format Property

A characteristic of an object in programming and software that dictates how it appears or behaves, such as size or color.