AWS Certified Solutions Architect Associate Training Notes 2021: Fast-track your exam success with the ultimate cheat sheet for the SAA-C02 exam by Neal Davis

Author:Neal Davis [Davis, Neal]
Language: eng
Format: mobi
Published: 2019-03-12T00:00:00+00:00

Enable Multi-AZ on the replication group to permit automatic failover if the primary nodes fails.

Schedule regular backups of your Redis cluster.

Amazon RedShift

General RedShift Concepts

Amazon Redshift is a fast, fully managed data warehouse that makes it simple and cost-effective to analyze all your data using standard SQL and existing Business Intelligence (BI) tools.

Clustered peta-byte scale data warehouse.

RedShift is a SQL based data warehouse used for analytics applications.

RedShift is an Online Analytics Processing (OLAP) type of DB.

RedShift is used for running complex analytic queries against petabytes of structured data, using sophisticated query optimization, columnar storage on high-performance local disks, and massively parallel query execution.

RedShift is ideal for processing large amounts of data for business intelligence.

Extremely cost-effective as compared to some other on-premises data warehouse platforms.

PostgreSQL compatible with JDBC and ODBC drivers available; compatible with most Business Intelligence tools out of the box.

Features parallel processing and columnar data stores which are optimized for complex queries.

Option to query directly from data files on S3 via RedShift Spectrum.

RedShift is 10x faster than a traditional SQL DB.

RedShift can store huge amounts of data but cannot ingest huge amounts of data in real time.

RedShift uses columnar data storage:

Data is stored sequentially in columns instead of rows.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.