nerdexam
Amazon

SAP-C02 · Question #646

A company built an ecommerce website on AWS using a three-tier web architecture. The application is Java-based and composed of an Amazon CloudFront distribution, an Apache web server layer of Amazon…

The correct answer is A. Configure the Aurora MySQL DB cluster to publish slow query and error logs to Amazon B. Implement the AWS X-Ray SDK to trace incoming HTTP requests on the EC2 instances and D. Install and configure an Amazon CloudWatch Logs agent on the EC2 instances to send the. To improve application performance visibility during peak traffic, configure Aurora MySQL to publish slow query and error logs to CloudWatch Logs, install CloudWatch Logs agents on EC2 instances for web server logs, and implement AWS X-Ray for end-to-end request tracing.

Submitted by ricky.ec· Mar 6, 2026Continuous Improvement for Existing Solutions

Question

A company built an ecommerce website on AWS using a three-tier web architecture. The application is Java-based and composed of an Amazon CloudFront distribution, an Apache web server layer of Amazon EC2 instances in an Auto Scaling group, and a backend Amazon Aurora MySQL database. Last month, during a promotional sales event, users reported errors and timeouts while adding items to their shopping carts. The operations team recovered the logs created by the web servers and reviewed Aurora DB cluster performance metrics. Some of the web servers were terminated before logs could be collected and the Aurora metrics were not sufficient for query performance analysis. Which combination of steps must the solutions architect take to improve application performance visibility during peak traffic events? (Choose three.)

Options

  • AConfigure the Aurora MySQL DB cluster to publish slow query and error logs to Amazon
  • BImplement the AWS X-Ray SDK to trace incoming HTTP requests on the EC2 instances and
  • CConfigure the Aurora MySQL DB cluster to stream slow query and error logs to Amazon Kinesis.
  • DInstall and configure an Amazon CloudWatch Logs agent on the EC2 instances to send the
  • EEnable and configure AWS CloudTrail to collect and analyze application activity from Amazon
  • FEnable Aurora MySQL DB cluster performance benchmarking and publish the stream to AWS X-

How the community answered

(31 responses)
  • A
    45% (14)
  • C
    32% (10)
  • E
    6% (2)
  • F
    16% (5)

Why each option

To improve application performance visibility during peak traffic, configure Aurora MySQL to publish slow query and error logs to CloudWatch Logs, install CloudWatch Logs agents on EC2 instances for web server logs, and implement AWS X-Ray for end-to-end request tracing.

AConfigure the Aurora MySQL DB cluster to publish slow query and error logs to AmazonCorrect

Configuring the Aurora MySQL DB cluster to publish slow query and error logs to Amazon CloudWatch Logs provides persistent storage and detailed insights into database query performance, allowing for analysis to identify bottlenecks and address the insufficient Aurora metrics.

BImplement the AWS X-Ray SDK to trace incoming HTTP requests on the EC2 instances andCorrect

Implementing the AWS X-Ray SDK across the application stack (EC2 instances, Aurora) enables end-to-end request tracing, which visualizes the flow of requests and identifies performance bottlenecks or errors across various services, greatly improving overall application visibility.

CConfigure the Aurora MySQL DB cluster to stream slow query and error logs to Amazon Kinesis.

While Kinesis Data Streams can ingest logs, Amazon CloudWatch Logs is the more appropriate and common service for persistent storage, analysis, and management of database logs for performance tuning, with built-in features for log insights.

DInstall and configure an Amazon CloudWatch Logs agent on the EC2 instances to send theCorrect

Installing and configuring an Amazon CloudWatch Logs agent on the EC2 instances ensures that web server logs are continuously sent to CloudWatch Logs, preventing log loss even if instances are terminated during peak traffic and allowing for centralized analysis.

EEnable and configure AWS CloudTrail to collect and analyze application activity from Amazon

AWS CloudTrail records API calls and management events for auditing and governance, but it does not collect application-level logs or provide the detailed performance metrics and tracing needed for application performance visibility during peak traffic.

FEnable Aurora MySQL DB cluster performance benchmarking and publish the stream to AWS X-

Aurora MySQL does not have a native 'performance benchmarking' feature that streams directly to AWS X-Ray; Performance Insights is the relevant monitoring tool for Aurora, while X-Ray focuses on application-level tracing.

Concept tested: AWS Observability, CloudWatch Logs, AWS X-Ray, Aurora logging

Source: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Replication.html, https://docs.aws.amazon.com/xray/latest/devguide/aws-xray.html, https://docs.aws.amazon.com/AmazonCloudWatch/latest/monitoring/Install-CloudWatch-Agent.html

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full SAP-C02 Practice