AWS Certified Solutions Architect – Associate (SAA-C03) — Question 267

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?

Answer options

• 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.

Correct answer: B

Explanation

Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL, which is perfect for querying CloudFront log files directly. Amazon QuickSight is a business intelligence service that integrates with Athena to build visualizations and dashboards. AWS Glue is an ETL tool rather than a visualization service, and Amazon DynamoDB is a NoSQL database that cannot directly query S3 log files using standard SQL.