Task 2.5: Design a Solution to Meet Performance Objectives SAP-C02 Practice Questions (Page 5)

Questions 21–25

1. 21application · medium

   A media company runs a MySQL database on Amazon RDS for its content management system. The database stores metadata for millions of images. The application frequently queries the database for image metadata by a 'content_id' column, and the queries are taking over 2 seconds, which is above the 500 ms performance target. The database is a db.r5.large instance with 200 GB of General Purpose SSD (gp2) storage. What should a solutions architect do to meet the performance target?

   • AChange the storage type to Provisioned IOPS (io2) with 10,000 IOPS.
   • BIncrease the instance size to db.r5.2xlarge to provide more memory and CPU.
   • CAdd an index on the 'content_id' column.
   • DCreate a read replica and direct all read traffic to it.
   Reveal Solution Discussion Select an answer first
2. 22expert · hard

   A company runs a critical web application on Amazon EC2 instances in an Auto Scaling group. The application has a performance objective of maintaining p95 latency below 200 ms. The current scaling policy is a target tracking policy based on average CPU utilization, but the company is seeing latency spikes even when CPU utilization is below the target. The solutions architect needs to adjust the scaling policy to better meet the latency objective. What should the solutions architect do?

   • AUse a scheduled scaling policy to add instances during peak hours.
   • BIncrease the target value for CPU utilization to 80% so the group scales out sooner.
   • CChange the target tracking policy to use the ALB's TargetResponseTime metric instead of CPU utilization.
   • DUse a simple scaling policy that adds instances when p95 latency exceeds 200 ms.
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   Which type of performance test is used to determine the maximum load a system can handle before it fails?

   • ALoad testing
   • BSoak testing
   • CSpike testing
   • DStress testing
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   A company runs a web application on EC2 instances in a private subnet. The application needs to access an Amazon S3 bucket to store and retrieve user-uploaded files. The company wants to minimize latency and ensure that traffic between the application and S3 does not traverse the public internet. What should a solutions architect do?

   • AMove the EC2 instances to a public subnet and assign them public IP addresses.
   • BCreate a VPC endpoint for S3 and update the application to use the endpoint.
   • CUse a NAT gateway to route traffic from the private subnet to S3.
   • DUse AWS Global Accelerator to route traffic to S3.
   Reveal Solution Discussion Select an answer first
6. 25application · medium

   A company runs a production web application on Amazon EC2 instances in an Auto Scaling group. The application is critical to the business, and the company has a performance objective of maintaining an average CPU utilization below 70%. The solutions architect needs to set up monitoring and alerting to ensure the team is notified if the CPU utilization approaches the threshold. What should the solutions architect do?

   • ACreate a CloudWatch dashboard that displays CPU utilization and check it manually.
   • BUse AWS Config to monitor the CPU utilization of the EC2 instances.
   • CCreate a CloudWatch alarm that triggers when the average CPU utilization is greater than 70% for 5 consecutive periods of 1 minute.
   • DEnable detailed monitoring on the EC2 instances and use CloudWatch Logs to analyze CPU utilization.
   Reveal Solution Discussion Select an answer first