AWS Certified Solutions Architect – Associate (SAA-C02) — Question 155

A company receives structured and semi-structured data from various sources once every day. A solutions architect needs to design a solution that leverages big data processing frameworks. The data should be accessible using SQL queries and business intelligence tools.
What should the solutions architect recommend to build the MOST high-performing solution?

Answer options

• A. Use AWS Glue to process data and Amazon S3 to store data.
• B. Use Amazon EMR to process data and Amazon Redshift to store data.
• C. Use Amazon EC2 to process data and Amazon Elastic Block Store (Amazon EBS) to store data.
• D. Use Amazon Kinesis Data Analytics to process data and Amazon Elastic File System (Amazon EFS) to store data.

Correct answer: B

Explanation

The correct choice is B because Amazon EMR is designed for big data processing, and Amazon Redshift is optimized for complex SQL queries and analytics, providing high performance for business intelligence tasks. Option A, while using AWS Glue and S3, does not directly support SQL querying at the same performance level as Redshift. Option C lacks a specialized data warehouse solution, and option D is not ideal for SQL access at scale.