Analytics Services

Question 1

What is a data warehouse?

Answer 1

A data warehouse is a data storage solution that aggregates massive amounts of historical data from disparate sources

Question 2

What are the benefits of a data warehouse?

Answer 2

Data warehouses support querying, reporting, analytics, and business intelligence. They are not used for transaction processing.

Question 3

Whats is AWS data warehouse solution?

Answer 3

Amazon Redshift

Question 4

Amazon Redshift

Answer 4

Redshift is a scalable data warehouse solution. Handles exabyte-scale data.

Question 5

What is Redshift used for?

Answer 5

Data consolidation - When you need to consolidate multiple data sources for reporting

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

Question 6

What are AWS analytic Services?

Answer 6

Athena - helps query data
Glue - prepares data for analytics
Kinesis - analyze data and video streams
Elastic MapReduce (EMR)
Data Pipeline - helps move data
QuickSight - helps visualize data

Question 7

Athena

Answer 7

Athena is a query service for Amazon S3.

Question 8

Glue

Answer 8

Glue prepares your data for analytics.

Question 9

Kinesis

Answer 9

Kinesis allows you to analyze data and video streams in real time.

Question 10

Elastic MapReduce (EMR)

Answer 10

EMR helps you process large amounts of data.

Question 11

Data Pipeline

Answer 11

Data Pipeline helps you move data between compute

and storage services running either on AWS or on-premises.

Question 12

QuickSight

Answer 12

QuickSight helps you visualize your data.