Redshift

Question 1

What AWS service represents a fully managed, petabyte-scale data warehouse designed for analytical workloads and optimized for efficiently querying and analyzing large datasets?

Answer 1

Amazon Redshift

Question 2

What type of data processing system is optimized for performing high-speed, multidimensional analysis on large volumes of data, often from a data warehouse?

Answer 2

OLAP (Online Analytical Processing) - implemented by services like Amazon Redshift (column-based)

Question 3

What type of data processing system is designed to handle a large number of concurrent real-time transactions, such as online banking, e-commerce purchases, and order entry?

Answer 3

OLTP (Online Transaction Processing) - implemented by services like Amazon RDS (row-based, optimized for transactional workloads)

Question 4

What Amazon Redshift feature allows direct querying of data stored in Amazon S3?

Answer 4

Redshift Spectrum

Question 5

What Amazon Redshift feature allows direct querying of data from other databases?

Answer 5

Federated Query

Question 6

What AWS service does Amazon Redshift integrate with for data visualizations?

Answer 6

Amazon QuickSight

Question 7

What connection interfaces does Amazon Redshift support for SQL clients?

Answer 7

JDBC and ODBC (also supports PostgreSQL-compatible clients and the Redshift Data API)

Question 8

Is Amazon Redshift a serverless product?

Answer 8

No, it is a provisioned service

Question 9

Is Amazon Redshift highly available by design?

Answer 9

No, it runs within a VPC in a single Availability Zone

Question 10

What Amazon Redshift feature enables traffic routing based on VPC configuration, including security groups, ACLs, DNS, gateways, and VPC endpoints?

Answer 10

Enhanced VPC Routing

Question 11

What architecture does Amazon Redshift use for query processing and data storage?

Answer 11

Leader node / Compute nodes architecture:
- Leader node - used for query ingestion, planning, and aggregation
- Compute nodes - used to execute queries on data

Question 12

What types of backups does Amazon Redshift support?

Answer 12

• Automatic backups (automated snapshots): incremental, taken every ~8 hours, retention configurable 1–35 days
• Manual backups (manual snapshots): incremental, taken on demand and retained until deleted