Task 3.3: Determine a Strategy to Improve Performance. SAP-C02 Practice Questions (Page 1)

Questions 1–5

1. 1expert · hard

   A company runs a data warehouse on Amazon Redshift. The company has noticed that query performance has degraded as the data has grown. The team has identified that the queries are performing full table scans. The team is considering using sort keys and distribution keys to improve performance. Which strategy will improve query performance?

   • AIncrease the number of nodes in the Redshift cluster to provide more compute capacity for the queries.
   • BUse a single distribution key on the largest table to ensure all data is distributed evenly across the cluster.
   • CEnable concurrency scaling on the Redshift cluster to handle more concurrent queries.
   • DDefine sort keys on columns that are frequently used in WHERE clauses and distribution keys on columns that are frequently used in JOINs.
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A company runs a customer-facing REST API on Amazon ECS with an Application Load Balancer. The API's response time has degraded from 200 ms to 900 ms over the past month. The team has verified that the database is not the bottleneck and that the application's CPU and memory utilization are consistently below 30%. The degradation correlates with a steady increase in the number of concurrent connections. What should the team do to identify the root cause of the performance degradation?

   • AIncrease the ECS task's ulimit and kernel parameter settings to allow more open file descriptors and connections per task.
   • BImmediately scale out the ECS service to add more tasks, assuming the increased connection count is overwhelming the current capacity.
   • CSwitch the ALB to a Network Load Balancer to improve raw throughput and reduce latency for the increasing number of connections.
   • DEnable detailed CloudWatch metrics for the ALB and the ECS tasks, and analyze connection counts, target response times, and request queue depth.
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   A solutions architect is investigating why an application's response time has degraded. Which activity is part of performance assessment?

   • AMigrating the application to a different AWS Region
   • BImplementing a caching layer to reduce database load
   • CImmediately increasing the instance size to improve response time
   • DReviewing CloudWatch metrics and logs to identify the component causing the slowdown
   Reveal Solution Discussion Select an answer first
5. 4expert · hard

   A company runs a critical application on AWS that requires high availability and low latency. The application is currently running in a single Availability Zone. The company is considering a multi-AZ deployment to improve availability, but is concerned about the impact on latency. The application's users are all located in the same city. What is the most important consideration when deciding whether to deploy in multiple Availability Zones?

   • AThe network latency between Availability Zones is typically low, but the application must be designed to handle the additional latency for cross-AZ traffic.
   • BThe application must be refactored to use a distributed database to support multi-AZ deployments, which is a major effort.
   • CThe application must be deployed in multiple Regions to achieve high availability, which is not possible with a single Region deployment.
   • DThe cost of deploying in multiple Availability Zones is significantly higher, and the performance benefit is minimal for users in the same city.
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   A solutions architect needs to improve the performance of a web application that experiences variable traffic. Which strategy is most appropriate?

   • ARefactor the application to use a different programming language
   • BAdd more indexes to the database
   • CMove the application to a different AWS Region
   • DImplement auto scaling to adjust capacity based on demand
   Reveal Solution Discussion Select an answer first