Database da real

A silicon valley based startup has a content management application with the web-tier running on EC2 instances and the database tier running on Amazon Aurora. Currently, the entire infrastructure is located in us-east-1 region. The startup has 90% of its customers in the US and Europe. The engineering team is getting reports of deteriorated application performance from customers in Europe with high application load time.

As a solutions architect, which of the following would you recommend addressing these performance issues? (Select two)

• Setup another fleet of EC2 instances for the web tier in the eu-west-1 region. Enable latency routing policy in Route 53

• Create Amazon Aurora read replicas in the eu-west-1 region

• Setup another fleet of EC2 instances for the web tier in the eu-west-1 region. Enable geolocation routing policy in Route 53

• Setup another fleet of EC2 instances for the web tier in the eu-west-1 region. Enable failover routing policy in Route 53

• Create Amazon Aurora Multi-AZ standby instance in the eu-west-1 region

A company is developing a healthcare application that cannot afford any downtime for database write operations. The company has hired you as an AWS Certified Solutions Architect Associate to build a solution using Amazon Aurora.

Which of the following options would you recommend?

• Set up an Aurora multi-master DB cluster

• Set up an Aurora serverless DB cluster

• Set up an Aurora provisioned DB cluster

• Set up an Aurora Global Database cluster

An e-commerce application uses an Amazon Aurora Multi-AZ deployment for its database. While analyzing the performance metrics, the engineering team has found that the database reads are causing high I/O and adding latency to the write requests against the database.

As an AWS Certified Solutions Architect Associate, what would you recommend to separate the read requests from the write requests?

• Set up a read replica and modify the application to use the appropriate endpoint

• Provision another Amazon Aurora database and link it to the primary database as a read replica

• Configure the application to read from the Multi-AZ standby instance

• Activate read-through caching on the Amazon Aurora database

An IT company has an Access Control Management (ACM) application that uses Amazon RDS for MySQL but is running into performance issues despite using Read Replicas. The company has hired you as a solutions architect to address these performance-related challenges without moving away from the underlying relational database schema. The company has branch offices across the world, and it needs the solution to work on a global scale.

Which of the following will you recommend as the MOST cost-effective and high-performance solution?

• Use Amazon Aurora Global Database to enable fast local reads with low latency in each region

• Use Amazon DynamoDB Global Tables to provide fast, local, read and write performance in each region

• Spin up a Redshift cluster in each AWS region. Migrate the existing data into Redshift clusters

• Spin up EC2 instances in each AWS region, install MySQL databases and migrate the existing data into these new databases

A company has recently launched a new mobile gaming application that the users are adopting rapidly. The company uses RDS MySQL as the database. The engineering team wants an urgent solution to this issue where the rapidly increasing workload might exceed the available database storage.

As a solutions architect, which of the following solutions would you recommend so that it requires minimum development and systems administration effort to address this requirement?

• Enable storage auto-scaling for RDS MySQL

• Migrate RDS MySQL to Aurora which offers storage auto-scaling

• Migrate RDS MySQL database to DynamoDB which automatically allocates storage space when required

• Create read replica for RDS MySQL