Module 8 - Section 3

Amazon Redshift

Redshift

a fast, fully managed data warehouse that makes it simple and cost-effective to analyze all your data by using standard SQL and your existing business intelligence (BI) tools

analytics

is important for businesses today, but building a data warehouse is complex and expensive

Redshift

is a fast and powerful, fully managed data warehouse that is simple and cost-effective to set up, use, and scale

Redshift

It enables you to run complex analytic queries against petabytes of structured data by using sophisticated query optimization, columnar storage on high-performance local disks, and massively parallel data processing

complex analytic queries

Redshift enables you to run ___ against petabytes of structured data by using sophisticated query optimization, columnar storage on high-performance local disks, and massively parallel data processing

leader node

The ___ manages communications with client programs and all communication with compute nodes. It parses and develops plans to carry out database operations—specifically, the series of steps that are needed to obtain results for complex queries

leader node

The ___ compiles code for individual elements of the plan and assigns the code to individual compute nodes

compute nodes

The leader node compiles code for individual elements of the plan and assigns the code to individual ___

compute nodes

The ___ run the compiled code and send intermediate results back to the leader node for final aggregation.

pay for what you use

Redshift’s pricing is ___

25 cents

In Redshift, you can get started for as little as ___ per hour

$1,000 dollars per terabyte per year

You can get started for as little as 25 cents per hour and, at scale, Amazon Redshift can deliver storage and processing for approximately ___ (with 3-Year Partial Upfront Reserved Instance pricing).

Spectrum

The Amazon Redshift ___ feature enables you to run queries against exabytes of data directly in Amazon S3.

scalability

__ is intrinsic in Amazon Redshift. Your cluster can be scaled up and down as your needs change with a few clicks in the console.

security

__ highest priority in AWS

built in

With Amazon Redshift, security is ___, and it is designed to provide strong encryption of your data both at rest and in transit

Amazon Redshift cluster

It is straightforward to automate most of the common administrative tasks to manage, monitor, and scale your ___—which enables you to focus on your data and your business.

Amazon Redshift is compatible with the tools that you already know and use. Amazon Redshift supports standard ___

Java Database Connectivity (JDBC), Open Database Connectivity (ODBC)

It also provides high-performance ___ and ___ connectors, which enable you to use the SQL clients and BI tools of your choice.

• Enterprise data warehouse

• big data

• software as a service

Amazon Redshift use cases:

Enterprise data warehouse (EDW)

Amazon Redshift use case:

Migrate at a pace that customers are comfortable with

Experiment without large upfront cost or commitment

Respond faster to business needs

agility

Many customers migrate their traditional enterprise data warehouses to Amazon Redshift with the primary goal of ___

Big data

Amazon Redshift use case:

Low price point for small customers

Managed service for ease of deployment and maintenance

Focus more on data and less on database management

Software as a service (SaaS)

Amazon Redshift use case:

Scale the data warehouse capacity as demand grows

Add analytic functionality to applications

Reduce hardware and software costs