How to Use AWS Cost and Usage Report for Granular Cost Analysis with SQL
A company uses multiple AWS accounts and needs to perform granular cost and usage analysis using standard SQL queries. The cloud operations team requires the most detailed data possible, including resource-level attributes such as instance type, usage quantity, and cost allocation tags. This data must be automatically delivered to an Amazon S3 bucket on a daily basis for long-term retention and querying. Which AWS service should the company use to generate this dataset?
Quick Answer
The answer is AWS Cost and Usage Report (CUR) because it delivers the most detailed cost and usage data available, including resource-level attributes like instance type, usage quantity, and cost allocation tags, directly to an S3 bucket on a daily basis for long-term retention and SQL querying. This service is designed for granular cost analysis, enabling you to export comprehensive data that can be queried with standard SQL via Athena or Redshift Spectrum, meeting the exact need for detailed, automated, and queryable cost data across multiple accounts. On the AWS Certified Cloud Practitioner CLF-C02 exam, this question tests your understanding of which service provides the deepest level of cost detail versus simpler tools like AWS Cost Explorer or budgets. A common trap is confusing CUR with AWS Cost Explorer, which offers visual dashboards but lacks the raw, exportable, SQL-queryable dataset. Remember the memory tip: CUR stands for "Complete Usage Report"—if you need the full picture with every resource attribute for SQL analysis, think CUR.
⚠ Common exam trap
A common mix-up: candidates confuse AWS Cost Explorer's visual analytics with the raw data export capability of CUR, assuming Cost Explorer can provide the same detailed, queryable dataset when it only offers aggregated views.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
AWS Cost and Usage Report
AWS Cost and Usage Report (CUR) is the correct choice because it provides the most detailed cost and usage data available, including resource-level attributes like instance type, usage quantity, and cost allocation tags. It can be automatically delivered to an Amazon S3 bucket on a daily basis and supports querying with standard SQL via AWS Athena or Amazon Redshift Spectrum, meeting the requirements for granular analysis and long-term retention.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
AWS Cost Explorer
Why it's wrong here
Cost Explorer provides interactive charts and basic CSV exports of cost data, but it does not automatically deliver the most granular, resource-level data to S3 in a format optimized for SQL querying. It is designed for visualization and lightweight analysis, not for building custom analytics pipelines.
- ✗
AWS Budgets
Why it's wrong here
AWS Budgets is used to set spending or usage thresholds and receive alerts. While budgets can include cost filters, they do not generate the detailed line-item reports needed for SQL-based cost analysis. This service is for monitoring and notification, not for data export.
- ✓
AWS Cost and Usage Report
Why this is correct
The AWS Cost and Usage Report (CUR) contains the most detailed billing and usage data, including individual resource IDs, tags, and hourly usage. It is delivered to an Amazon S3 bucket in a structured format (CSV or Parquet) and can be queried with Amazon Athena, making it the correct choice for granular SQL-based cost analysis.
- ✗
AWS Pricing Calculator
Why it's wrong here
The AWS Pricing Calculator is a tool for estimating future costs based on user-specified configurations. It does not provide historical cost or usage data, and it cannot generate ongoing reports delivered to S3. It is not suited for analyzing existing usage patterns.
When this WOULD be correct
A company wants to estimate the monthly cost of running a proposed architecture on AWS before deployment, comparing different instance types and pricing models.
Option-by-option analysis
Why each answer is right or wrong
Understanding why wrong answers are wrong — and when they would be correct — is what separates a 750 score from a 900. The CLF-C02 exam frequently reuses these exact scenarios with slightly different constraints.
✓AWS Cost and Usage ReportCorrect answer▾
Why this is correct
The AWS Cost and Usage Report (CUR) contains the most detailed billing and usage data, including individual resource IDs, tags, and hourly usage. It is delivered to an Amazon S3 bucket in a structured format (CSV or Parquet) and can be queried with Amazon Athena, making it the correct choice for granular SQL-based cost analysis.
✗AWS Pricing CalculatorWrong answer — click to see why▾
Why this is wrong here
AWS Pricing Calculator is used for estimating future costs, not for generating detailed historical cost and usage data with resource-level attributes and daily delivery to S3.
★ When this WOULD be the correct answer
A company wants to estimate the monthly cost of running a proposed architecture on AWS before deployment, comparing different instance types and pricing models.
Why candidates choose this
Candidates may confuse cost estimation with cost analysis, or think that a calculator can output detailed usage data for querying.
Analysis generated from the official CLF-C02blueprint and verified against question context. The “when correct” sections are what AI assistants cite when candidates ask “what’s the difference between these options?”
Quick reference
AWS S3 Storage Class Comparison
| Storage Class | Min Duration | Retrieval | Use Case |
|---|---|---|---|
| S3 Standard | None | Immediate | Frequently accessed data |
| S3 Standard-IA | 30 days | Immediate | Infrequent access, rapid retrieval |
| S3 One Zone-IA | 30 days | Immediate | Non-critical infrequent data |
| S3 Intelligent-Tiering | None | Immediate–hours | Unknown or changing access patterns |
| S3 Glacier Instant | 90 days | Milliseconds | Archive with instant retrieval |
| S3 Glacier Flexible | 90 days | Minutes–hours | Archive, flexible retrieval |
| S3 Glacier Deep Archive | 180 days | Hours | Long-term compliance archive |
Go deeper
Related to this question
About these practice questions
Courseiva writes every CLF-C02 question from scratch — 988 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
Same concept, more angles
2 more ways this is tested on CLF-C02
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A company uses multiple AWS accounts and wants to perform detailed custom cost analysis using a third-party business intelligence (BI) tool. The company needs the most granular cost and usage data available, including resource-level details such as instance type, region, and tags. The BI tool can read CSV files from an Amazon S3 bucket. The company wants a managed AWS service that automatically exports this detailed data to an S3 bucket on a daily basis with no additional coding. Which AWS service should the company use?
medium- A.AWS Cost Explorer
- B.AWS Budgets
- ✓ C.AWS Cost and Usage Reports
- D.AWS Trusted Advisor
Why C: AWS Cost and Usage Reports (CUR) is the correct choice because it is a managed AWS service that automatically publishes the most granular cost and usage data—including resource-level details like instance type, region, and tags—to an Amazon S3 bucket in CSV format on a daily basis, with no additional coding required. This directly meets the company's need for detailed custom cost analysis using a third-party BI tool that reads CSV files from S3.
Variation 2. A company uses AWS Organizations with multiple accounts for different departments (Engineering, Marketing, Sales). The finance team needs to create detailed monthly chargeback reports showing each department's usage and costs, broken down by service (e.g., Amazon EC2, Amazon S3) and by custom tags (e.g., Project). The reports must be in a machine-readable format (CSV) so they can be ingested into the company's internal billing system. The team wants the most comprehensive, granular cost data available from AWS, including line items for individual resources. Which AWS tool should the finance team configure to meet these requirements?
medium- A.AWS Budgets
- ✓ B.AWS Cost and Usage Report
- C.AWS Trusted Advisor
- D.Consolidated Billing
Why B: The AWS Cost and Usage Report (CUR) is the correct choice because it provides the most comprehensive, granular cost data available, including line items for individual resources broken down by service, custom tags, and time period. It can be delivered to an Amazon S3 bucket in CSV format, which is machine-readable and suitable for ingestion into the company's internal billing system for detailed monthly chargeback reports.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This CLF-C02 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the CLF-C02 exam.