Question #1660
A company needs to generate monthly compliance reports detailing AWS costs across all accounts in their organization. The solution must be scalable and cost-effective, using the AWS Organizations management account to aggregate data. Which approach is BEST?
Enable Cost and Usage Reports in the management account. Deliver reports to Amazon S3. Use Amazon Redshift for analysis.
Enable Cost and Usage Reports in the management account. Deliver reports to Amazon S3. Use Amazon Athena for analysis.
Enable Cost and Usage Reports in each member account. Deliver reports to Amazon S3. Use AWS Glue for analysis.
Enable Cost and Usage Reports in the management account. Deliver reports to Amazon Kinesis Data Firehose. Use Amazon EMR for analysis.
Explanation
Answer B is correct because:
1. Cost and Usage Reports (CUR) in the management account: AWS Organizations allows the management account to aggregate cost data from all member accounts, eliminating the need to enable CUR in each account (making Option C inefficient).
2. Amazon S3 for storage: S3 is scalable, durable, and cost-effective for storing large datasets like monthly reports.
3. Amazon Athena for analysis: Athena is serverless, uses standard SQL, and charges per query, making it ideal for ad-hoc, cost-effective analysis of data in S3. Options A (Redshift) and D (EMR) involve managed clusters, which are more expensive for periodic reporting. Option D's use of Kinesis Data Firehose is unnecessary for batch monthly data. Option C's AWS Glue adds ETL complexity when Athena suffices.
Key Points:
- Use CUR in the management account for organization-wide cost aggregation.
- Athena is serverless and cost-effective for querying S3 data.
- Avoid over-engineering with streaming (Firehose) or clusters (Redshift/EMR) for batch reporting.
Answer
The correct answer is: B