CloudGuild · Blog · Cheat sheets · Lessons · Certifications

Cost-Efficient ETL with AWS: Exam Question Breakdown

Explore a common exam question on cost-efficient ETL processes using AWS. Learn the right answer and why others don't work.

A lot of candidates trip over cost optimization questions in the AWS Certified Solutions Architect - Associate exam. Understanding the nuances of ETL processes and their associated costs is crucial. Let’s dissect a question that tests your knowledge in this area.

The question

A company is looking to improve the cost efficiency of their ETL processes on AWS. They currently use AWS Glue but are concerned about the costs associated with Glue jobs. What is an alternative approach they could consider for cost savings?

A. Switch to using AWS Lambda for ETL processes
B. Use Amazon EMR with Spot Instances
C. Implement a scheduling system for AWS Glue jobs to reduce frequency
D. Combine AWS Glue with Amazon Redshift for more efficiency

Think before you scroll

Before making your selection, assess the cost structures of each option. Consider how each alternative impacts ETL efficiency and cost. This will help you identify the most economical solution.

The answer

The correct option is B. Use Amazon EMR with Spot Instances. This method can drastically cut costs by utilizing lower-priced, transient capacity compared to the fixed pricing of AWS Glue jobs.

Why the other options lose

A. Switch to using AWS Lambda for ETL processes: While Lambda can be cost-effective, it has execution limits. It may not handle large ETL workloads effectively due to its constraints on execution duration and memory, making it a less viable option for heavy data processing.

C. Implement a scheduling system for AWS Glue jobs to reduce frequency: This approach can help manage costs but does not fundamentally reduce the costs associated with AWS Glue. Scheduling may limit job runs, but it won't address the per-process charges that Glue incurs.

D. Combine AWS Glue with Amazon Redshift for more efficiency: This option may improve data handling and processing but does not directly tackle cost efficiency. Redshift introduces its own pricing model, which could potentially increase overall expenses rather than decrease them.

The concept behind it

Understanding the pricing models of AWS services is essential. AWS Glue charges per data processed, while Amazon EMR with Spot Instances allows you to take advantage of lower costs for transient compute resources. This principle can apply to various scenarios, emphasizing the need to explore cost-effective alternatives depending on the workload.

Exam trap to remember

Always assess the pricing model of AWS services when considering cost efficiency. The cheapest option isn't always the best; focus on scalability and capabilities as well.

Take the free SAA-C03 mock exam

Take a free mock exam →