Q73 — AWS DOP-C02 Ch.1
Question 73 of 100 | ← Chapter 1
A video-sharing company stores videos in Amazon S3. The company observes a sudden increase in video access requests but does not know which videos are most popular. The company needs to determine the general access patterns of video files, including the number of unique users accessing a specific file on a given date and the total number of requests for that file. How can the company meet these requirements with minimal effort?
- A. Enable S3 server access logging. Import the access logs into an Amazon Aurora database. Use Aurora SQL queries to analyze access patterns.
- B. Enable S3 server access logging. Use Amazon Athena to create an external table over the log files stored in S3. Use Athena SQL queries to analyze access patterns. ✓
- C. Invoke an AWS Lambda function for each S3 object access event. Configure the Lambda function to write file access information—such as user, S3 bucket, and object key—to an Amazon Aurora database. Use Aurora SQL queries to analyze access patterns.
- D. Log an Amazon CloudWatch Logs entry for each S3 object access event. Configure CloudWatch Logs streams to send file access information (e.g., user, S3 bucket, and object key) to an Amazon Kinesis Data Analytics for SQL application. Perform sliding-window analysis.
Correct Answer: B. Enable S3 server access logging. Use Amazon Athena to create an external table over the log files stored in S3. Use Athena SQL queries to analyze access patterns.
Explanation
This question tests knowledge of using AWS services to analyze S3 access logs. Amazon S3 server access logging records detailed information about each request—including object key, requester, and timestamp. Amazon Athena enables direct SQL querying of log files stored in S3 without requiring data loading or ETL. Option B creates an external table in Athena pointing to the log files, eliminating data migration overhead. Option A adds unnecessary steps by importing logs into Aurora; Options C and D introduce complex real-time architectures with higher operational overhead.