Which solution meets these requirements?
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.
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.
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.
Use Amazon CloudWatch Logs Insights to search and analyze the logs when the logs are automatically uploaded by the DB cluster.
Explanations:
While AWS Lambda can be used to ship logs to Amazon S3, Amazon Athena and QuickSight are better suited for querying structured data, not logs stored in S3. Athena is more efficient for structured queries, but QuickSight is not ideal for log analysis from S3.
Using manual scripts to download logs and store them in S3 increases operational overhead and is not as efficient as an automated solution like AWS Lambda. Athena and QuickSight can analyze structured data but are less suited for direct log analysis in S3.
Amazon Elasticsearch Service (ES) and Kibana can handle log analysis, but this option introduces additional complexity and overhead compared to simpler alternatives. Shipping logs to Amazon S3 and analyzing with Athena would be more efficient and cost-effective.
Amazon Aurora can automatically ship logs to CloudWatch Logs, and CloudWatch Logs Insights is specifically designed for efficient log searching and analysis, making this the most operationally efficient solution with minimal resource utilization.