
Answer-first summary for fast verification
Answer: Use standard SQL queries in Amazon Athena to analyze the CloudFront logs in the S3 bucket. Visualize the results with Amazon QuickSight.
## Explanation **Correct Answer: B** **Why Option B is correct:** 1. **Amazon Athena** is a serverless interactive query service that allows you to analyze data in Amazon S3 using standard SQL. Since CloudFront logs are stored in S3, Athena is the perfect tool to query them without having to load the data into a database. 2. **Amazon QuickSight** is AWS's business intelligence service designed specifically for creating visualizations and dashboards. It integrates well with Athena and can directly visualize query results. 3. This combination provides a serverless, cost-effective solution for log analysis and visualization. **Why Option A is incorrect:** - AWS Glue is an ETL (Extract, Transform, Load) service, not a visualization tool. While it can prepare data for analysis, it's not designed for creating business intelligence dashboards and visualizations. **Why Options C and D are incorrect:** - Amazon DynamoDB is a NoSQL database service, not designed for querying log files stored in S3. DynamoDB requires data to be loaded into its tables, which would be inefficient for analyzing large log files. It doesn't natively support querying S3 data with SQL. **Key AWS Services:** - **Amazon Athena**: Serverless SQL query service for S3 data - **Amazon QuickSight**: Business intelligence and visualization service - **CloudFront Logs**: Stored in S3 in gzip compressed format - **Typical workflow**: CloudFront → S3 logs → Athena queries → QuickSight visualizations **Best Practice:** This is a common pattern for analyzing AWS service logs stored in S3, providing a scalable, serverless analytics solution.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A company is using Amazon CloudFront with its website. The company has enabled logging on the CloudFront distribution, and logs are saved in one of the company's Amazon S3 buckets. The company needs to perform advanced analyses on the logs and build visualizations.
What should a solutions architect do to meet these requirements?
A
Use standard SQL queries in Amazon Athena to analyze the CloudFront logs in the S3 bucket. Visualize the results with AWS Glue.
B
Use standard SQL queries in Amazon Athena to analyze the CloudFront logs in the S3 bucket. Visualize the results with Amazon QuickSight.
C
Use standard SQL queries in Amazon DynamoDB to analyze the CloudFront logs in the S3 bucket. Visualize the results with AWS Glue.
D
Use standard SQL queries in Amazon DynamoDB to analyze the CloudFront logs in the S3 bucket. Visualize the results with Amazon QuickSight.