AWS Certified Solutions Architect Associate SAA-C03 Practice Question
A company stores several petabytes of sales data in AWS. Business analysts must run frequent, complex SQL queries (for example, joins, aggregations, and time-window analytics) and receive results in seconds while minimizing cost. Which AWS managed service provides the best price-performance fit for this large-scale, columnar analytics workload?
Amazon Redshift is purpose-built for data warehousing and analytics. Its columnar storage format and massively parallel processing (MPP) architecture make complex queries on large data sets faster and cheaper than row-store OLTP engines such as Amazon Aurora or Amazon RDS for MySQL. DynamoDB is a NoSQL key-value store and is not optimized for ad-hoc SQL analytics. Therefore, Amazon Redshift is the most cost-effective choice for this scenario.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is the difference between OLTP and OLAP?
Open an interactive chat with Bash
What is columnar data storage and why is it important?
Open an interactive chat with Bash
What is MPP architecture and how does it benefit Redshift?