AWS Fundamentals: RDS + Aurora + Elasticache

Question 1

A company runs an e-commerce application on Amazon EC2 instances behind an Application Load Balancer. The instances run in an Amazon EC2 AutoScaling group accross multiple Availability Zones. The AutoScaling group scales based on CPU utilization metrics. The e-commerce application stores the transaction data in a MySQL 8.0 database that is hosted on a lrage EC2 instance. The database’s performance degrades quickly as application load increases. THe application handles more read requests than write transactions, The company wants a solution that will automatically scale the database to meet the demand of unpredicatbale read workloads while maintaining high availability. Which solution will meet these requirements?

Answer 1

Use Amazon Aurora with Multi-AZ deployment. Configure Aurora Scaling with Replica Replicas.

Question 2

A company maintains a searchable repository of items on its website. The data is stored in an Amazon RDS for MySQL database table that contains more than 10 million rows. The database has 2 TB of General Purpose SSD Storage. There are 10 millions of updates against this data every day through the company’s website. The company has noticed that** some insert operations are taking 10 seconds or longer. **The compnay has determined that the database storage performance is the problem. Which solution addresses this performance issue?

Answer 2

Change the storage type to a Provisioned IOPS SSD

Question 3

A company is using a SQL database to store movie data that is publicly accessible. The database runs on an Amazon RDS Single AZ-DB instance. A script runs queries at random intervals each day to record the number of new movies that have ben added to the databae. The script must report a final total during business hours. The company’s development team notices that the database performance is inadequate for development taks when the script is running. A solutions architect must recommend to resolve this issue. Which solution will meet this requirement with the LEAST operational overhead?

Answer 3

Create a read replica of the database. Configure the script to query only the read-replica

Question 4

An application allows users at a company’s headquarters to access product data. The Product data is stored in an Amazon RDS MySQL DB Instance. The operations team has isolated an application performance slowdown and wants to separate read-traffic from write traffic. A solutions architect needs to optimize the application’s performance quickly. What should the solutions architect recommend?

Answer 4

Create read replcas for the database. Configure the read replicas with the same compute and storage resources as the source database.