Leveraging Analytics Services

Question 1

What is a data warehouse?

Answer 1

Is a data storage solution that aggregates massive amounts of data from disparate sources.

Benefits supports querying, reporting, analytics, and business intelligence.

Not good for transactional systems

Question 2

What is Amazon Redshift?

Answer 2

Is an AWS warehouse solution

Handles a LOT of data

Question 3

What are some real world use cases of Amazon Redshift?

Answer 3

When you want to consolidate multiple data sources for reporting

When you want to run a database that doesn’t require real-time transaction processing (insert, update, and delete)

Question 4

What is Athena?

Answer 4

A query service that allows you to analyze data in S3 using standard SQL.

You pay per query and it is serverless.

Question 5

What are some real world use cases of Athena?

Answer 5

Helps you query historical data sorted in S3 as if they were relational data using standard SQL

Question 6

What is Glue?

Answer 6

Prepares your data for analytics.

It is an ETL (extract, transfer, load) service that generates ETL code.

Question 7

What is Kinesis?

Answer 7

Real time streaming data.

Question 8

What are some real world use cases of Kinesis?

Answer 8

Helps you analyze logs in near real time for applications monitoring or fraud detection

Question 9

What is Elastic MapReduce (EMR)?

Answer 9

Helps you process large amounts of data.

Analyze data using Hadoop and work with other frameworks like Apache Spark

Question 10

What is Data Pipeline?

Answer 10

Helps you move data between compute and storage services running either on AWS or on-premises.

Sends notification on failure

Question 11

What is QuickSight?

Answer 11

Helps you to visualize your data. Build interactive dashboards that you can embed into your applications.