Key points

• Redshift is optimized for OLAP rather than high-volume row-oriented transactions.
• Data layout, compression, concurrency, workload management, and source ingestion affect performance and cost.
• Use S3 as a complementary lake and choose serverless or provisioned warehouse capacity from workload behavior where supported.

Best-known use cases

• Run BI queries over large curated analytical datasets.
• Consolidate data for repeatable warehouse reporting.

What candidates often confuse it with

• Redshift is a warehouse; RDS/Aurora is an OLTP relational database.
• Redshift stores warehouse data; Athena queries S3 directly without a warehouse.

Key takeaway

Choose Redshift for sustained analytical warehouse workloads, not transactional application storage.

Related services

• Amazon S3
• Amazon Athena
• AWS Glue
• Amazon Quick

Relevant exam tasks

• D3.3
• D3.5
• D4.3

Learn more

• Amazon Redshift