Analytics Services

Question 1

What are the uses of a Data Warehouse?

Answer 1

Querying, reporting, analytics, business intelligence
Not for transaction processing

Question 2

What is Amazon Redshift?

Answer 2

AWS’s warehousing solution
Exa-bite scale

Question 3

When would you use Redshift?

Answer 3

Data consolidation from multiple data sources for reporting
Relational database that does not require real-time processing

Question 4

What is Analytics?

Answer 4

The act of querying or processing your data

Question 5

What is Athena?

Answer 5

A query service for Amazon S3
Pay per query
uses standard sql
considered serverless

Question 6

What is Glue?

Answer 6

An ETL service that prepares your data for analytics

Question 7

What is Kinesis

Answer 7

Allows you to analyze data and video streams in real time
Video, audio, app logs, clickstreams, IoT data

Question 8

What is EMR?

Answer 8

Elastic Map Reduce
process large amounts of data
uses Hadoop and other bid data frameworks like Apache Spark

Question 9

What is Data Pipeline?

Answer 9

Helps you move data between compute and storage services running either on AWS or on-prem
Move data at certain intervals, or based on conditions
Normally used to move data from S3 to Redshift

Question 10

What is QuickSight?

Answer 10

Helps you to visualize your data with interactive dashboards