thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Cloud Computing · Foundational

Amazon Redshift

AWS fully managed, petabyte-scale columnar data warehouse for analytics using SQL.

Definition

Redshift uses massively parallel processing and columnar storage to run complex analytic queries over large datasets. It offers provisioned RA3 clusters with managed storage and Redshift Serverless, can query S3 data lakes with Redshift Spectrum, and supports data sharing across clusters and accounts.

Example

A BI team loads daily sales data into Redshift and visualizes it with Amazon QuickSight.

Exam tip

Redshift is for OLAP/analytics; RDS and Aurora are for OLTP transactions.

Related terms