1/46
A set of question-and-answer flashcards covering key concepts, architecture, features, tuning, advantages, and comparisons related to Amazon Redshift as presented in the lecture.
What core type of system is Amazon Redshift classified as, OLTP or OLAP?
It is an OLAP (Online Analytical Processing) system.
Which two architectural pillars primarily drive Redshift’s analytical performance?
Massively Parallel Processing (MPP) and a columnar storage engine.
In what year did Amazon Redshift become generally available?
February 15, 2013.
Redshift’s original code base was derived from which open-source database version?
PostgreSQL 8.0.2.
In Redshift’s shared-nothing MPP design, what resources does each node have exclusively?
Its own CPU, memory, and attached storage.
What is the single entry point for client connections in a provisioned Redshift cluster?
The Leader Node.
Name the three main Redshift compute-node families offered by AWS.
RA3, DC2 (Dense Compute), and DS2 (Dense Storage).
Which node family separates compute from storage and uses Redshift Managed Storage (RMS)?
RA3 nodes.
Within a compute node, what smaller parallel units further subdivide resources?
Slices.
Why does columnar storage reduce I/O for analytical queries?
Because only the required columns’ blocks are read instead of entire rows.
How large, by default, is a disk block in Redshift’s columnar format?
1 MB.
What twofold benefit does data compression provide in Redshift?
Reduced storage cost and less data movement during query execution.
Which COPY-time feature lets Redshift choose optimal compression encodings automatically?
Automatic Compression.
Name Redshift’s purpose-built high-performance compression algorithm for numeric/date data.
AZ64.
What Redshift table property determines where rows are stored across node slices?
Distribution style (DISTSTYLE).
Which DISTSTYLE replicates an entire small dimension table on every node?
DISTSTYLE ALL.
Which DISTSTYLE is best for large fact tables joined on a high-cardinality key?
DISTSTYLE KEY (using a DISTKEY).
What construct allows Redshift to skip disk blocks quickly based on min/max values?
Zone maps created via sort keys.
Compare Compound vs. Interleaved sort keys in one sentence.
Compound favors a left-to-right column prefix pattern, whereas Interleaved gives equal weight to each listed column for unpredictable filters.
Which two SQL commands are essential for Redshift table maintenance?
VACUUM and ANALYZE.
What does the VACUUM command do (two key functions)?
Reclaims space from deleted rows and resort data according to the sort key.
What happens if you omit regular ANALYZE after large data loads?
The optimizer has stale statistics, leading to poor query plans and slow performance.
Name the Redshift feature that lets you query data in S3 without loading it first.
Redshift Spectrum.
In Spectrum, where are the heavy scan and filter operations executed?
On a separate fleet of Redshift Spectrum servers, not on the main cluster.
Which feature temporarily adds transient clusters to handle query surges?
Concurrency Scaling.
How are Concurrency Scaling charges offset for most customers?
Clusters earn free Concurrency Scaling credits (1 hour per day, up to 30 hours).
What capability lets one Redshift cluster share live data with another without copying?
Data Sharing (producer/consumer clusters).
Redshift Serverless bills compute usage in which unit?
Redshift Processing Units (RPUs) per second.
State one primary benefit of Redshift Serverless for teams with variable workloads.
Automatic scale up and scale down to zero, eliminating capacity planning and idle cost.
Which AWS service integrates with Redshift ML to train models from SQL?
Amazon SageMaker.
Give one example use case for Redshift powering BI dashboards.
Real-time gaming metrics analysis (e.g., Zynga monitoring player engagement).
Why is Redshift unsuitable as a primary OLTP database?
It is optimized for large, read-heavy analytical queries, not high-frequency row-level transactions.
Against which two cloud data warehouses is Redshift most often compared?
Snowflake and Google BigQuery.
What architectural shift did RA3 nodes introduce compared with older DS2/DC2 nodes?
Decoupling of compute and storage via Redshift Managed Storage in S3.
Name one advantage Snowflake offers that differs from classic provisioned Redshift.
Fully independent scaling of compute “virtual warehouses” without manual tuning.
What BigQuery pricing model charges per analyzed terabyte?
On-demand (per-TB processed) pricing.
List two major advantages frequently cited for Amazon Redshift.
High performance on large analytic workloads and tight integration with the AWS ecosystem.
List two common disadvantages or challenges of Amazon Redshift.
Requires expertise for distribution/sort key tuning and manual maintenance tasks like VACUUM.
What Redshift feature caches results to serve identical repeated queries instantly?
The Leader Node’s result cache.
Why can data skew hurt performance in Redshift?
Uneven data distribution causes some slices to work harder, reducing parallel efficiency.
Which Redshift command is primarily used for high-speed bulk data loading from S3?
COPY.
Does Redshift enforce primary-key or unique constraints at runtime?
No; they are informational only and must be enforced during ETL externally.
In a lake-house architecture, what role does Amazon S3 normally play alongside Redshift?
It acts as the central data lake storing raw or cold data queried via Spectrum.
When would DISTSTYLE EVEN generally be your safest choice?
For tables without obvious join keys or that seldom participate in large joins.
What maintenance drawback comes with Interleaved sort keys?
Higher overhead for data loading and VACUUM operations.
Why are DC2 nodes recommended for datasets under ~500 GB?
They offer fast local SSDs optimized for maximum query speed on smaller data volumes.
Which Redshift security feature allows encryption of data at rest?
AWS Key Management Service (KMS) integration for encrypted clusters.