AWS Certified Database – Specialty — Question 301

A software-as-a-service (SaaS) company is using an Amazon Aurora Serverless DB cluster for its production MySQL database. The DB cluster has general logs and slow query logs enabled. A database engineer must use the most operationally efficient solution with minimal resource utilization to retain the logs and facilitate interactive search and analysis.
Which solution meets these requirements?

Answer options

• A. Use an AWS Lambda function to ship database logs to an Amazon S3 bucket. Use Amazon Athena and Amazon QuickSight to search and analyze the logs.
• B. Download the logs from the DB cluster and store them in Amazon S3 by using manual scripts. Use Amazon Athena and Amazon QuickSight to search and analyze the logs.
• C. Use an AWS Lambda function to ship database logs to an Amazon S3 bucket. Use Amazon Elasticsearch Service (Amazon ES) and Kibana to search and analyze the logs.
• D. Use Amazon CloudWatch Logs Insights to search and analyze the logs when the logs are automatically uploaded by the DB cluster.

Correct answer: D

Explanation

Amazon Aurora Serverless can automatically publish database logs directly to Amazon CloudWatch Logs, eliminating the need for custom scripts or AWS Lambda functions. Once in CloudWatch, Amazon CloudWatch Logs Insights provides a highly efficient, built-in interactive query tool to search and analyze the log data with minimal operational effort. Other options require setting up and maintaining additional data pipelines (such as Lambda, S3, Athena, or Amazon ES), which increases resource utilization and operational complexity.