Data and Analytics - Redshift

Question 1

What type of processing is Redshift used for?

Answer 1

OLAP (Online Analytical Processing) for analytics and data warehousing.

Question 2

How is Redshift different from a transactional database?

Answer 2

Redshift stores data in columns instead of rows, enabling faster analytics and aggregations.

Question 3

What are the methods to ingest data into Redshift?

Answer 3

Kinesis Data Firehose: Streams data via S3 and issues a copy command.
S3 Copy Command: Manually copy data from S3 to Redshift using IAM roles.
JDBC Driver: Insert data from applications or EC2 instances.

Question 4

How does Redshift compare to Athena?

Answer 4

Redshift: Faster queries, joins, and aggregations; requires a cluster.
Athena: Serverless; queries data directly from S3.