If an AWS billing dashboard shows a sudden spike in costs for 'S3' service in June, which query would best help identify the root cause?

medium📝 Predict Output Q5 of 15

AWS - Account and Billing

ASELECT usage_type, SUM(cost) FROM billing WHERE service = 'S3' AND month = '2024-06' GROUP BY usage_type ORDER BY SUM(cost) DESC;

BSELECT * FROM billing WHERE service = 'EC2' AND month = '2024-06';

CSELECT AVG(cost) FROM billing WHERE service = 'S3' AND month = '2024-05';

DSELECT COUNT(*) FROM billing WHERE service = 'S3';

Step-by-Step Solution

Solution:

Step 1: Identify query that breaks down S3 costs by usage type
SELECT usage_type, SUM(cost) FROM billing WHERE service = 'S3' AND month = '2024-06' GROUP BY usage_type ORDER BY SUM(cost) DESC; groups costs by usage type for June, showing detailed cost sources.
Step 2: Verify other options are less relevant
SELECT * FROM billing WHERE service = 'EC2' AND month = '2024-06'; is for EC2, C averages May costs, D counts records without cost detail.
Final Answer:
Query grouping S3 costs by usage type for June -> Option A
Quick Check:
Grouping by usage type reveals cost drivers [OK]

Quick Trick: Group costs by usage type to find cost spikes [OK]

Common Mistakes:

MISTAKES

Master "Account and Billing" in AWS

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More AWS Quizzes