Task 3.3: Determine High-Performing Database Solutions SAA-C03 Practice Questions (Page 5)

Questions 21–25

1. 21application · medium

   A social media analytics platform stores user posts in an Amazon RDS for PostgreSQL database. The application frequently queries the 50 most recent posts for each user's feed. These queries are identical for many users and the result set changes only when a new post is published. The database currently handles the load, but the team expects a 10x increase in read traffic next month. What should a solutions architect do to minimize database load while keeping the application code changes minimal?

   • AIncrease the RDS instance class and enable Multi-AZ deployment to handle the additional read traffic.
   • BCreate an Amazon ElastiCache for Redis cluster and cache the feed results with a key based on user ID, invalidating the cache entry when a new post is published for that user.
   • CEnable Performance Insights on the RDS instance and use the recommendations to add more indexes to the posts table.
   • DMigrate the database to Amazon DynamoDB and store the feed data as a single item per user.
   Reveal Solution Discussion Select an answer first
2. 22expert · hard

   A company runs a global e-commerce application on Amazon Aurora MySQL in the us-east-1 Region. The application has users in North America and Europe. The team wants to improve read latency for European users and provide disaster recovery in case of a Regional failure. The recovery point objective (RPO) is 15 minutes, and the recovery time objective (RTO) is 30 minutes. What should a solutions architect do?

   • ACreate a cross-Region read replica in eu-west-1 and configure the European users to read from the replica. For disaster recovery, promote the replica to a standalone instance.
   • BEnable Multi-AZ on the Aurora cluster and use the standby for read traffic.
   • CUse Amazon ElastiCache for Redis in eu-west-1 and cache the read data for European users.
   • DCreate an Aurora Replica in a different Availability Zone in us-east-1 and configure the European users to read from it.
   Reveal Solution Discussion Select an answer first
4. 23expert · hard

   A company is designing a new application that will store user profiles and their associated settings. The data is accessed frequently and must be highly available. The team expects the workload to be write-intensive, with occasional reads. The data model is simple and does not require complex queries. The company wants a fully managed, serverless solution that can scale automatically. Which database service should a solutions architect choose?

   • AAmazon Aurora Serverless v2
   • BAmazon DynamoDB
   • CAmazon ElastiCache for Redis
   • DAmazon RDS for MySQL
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   A company runs a web application on AWS that uses Amazon RDS for PostgreSQL. The application is deployed on Amazon EC2 instances and uses a connection pool. The team has noticed that during peak hours, the database CPU utilization is high and the application experiences increased latency. The database is a db.r5.large instance with 1000 Provisioned IOPS. The application's connection pool is set to a maximum of 50 connections. What should a solutions architect do to reduce the database CPU load?

   • AIncrease the maximum connection pool size to 200 to allow more concurrent requests.
   • BDeploy an Amazon RDS Proxy between the application and the database and configure the application to use it.
   • CReduce the Provisioned IOPS to 500 to free up resources for the CPU.
   • DMigrate the database to a db.r5.xlarge instance to provide more CPU capacity.
   Reveal Solution Discussion Select an answer first
6. 25foundation · medium

   A team is designing a read-heavy application that queries a relational database. The application frequently retrieves the same set of product details, which change only a few times per day. The team wants to reduce the load on the database and improve response times for these repeated queries. Which approach best meets these requirements?

   • AAdd a cache layer, such as Amazon ElastiCache, and store the product details in the cache with a short TTL so the application reads from the cache first.
   • BUse Amazon S3 to store the product details and have the application query S3 directly for every request.
   • CIncrease the provisioned IOPS on the database to handle the repeated queries faster without changing the application architecture.
   • DCreate additional read replicas and distribute the read traffic across all replicas, including the primary database.
   Reveal Solution Discussion Select an answer first