Amazon Analytics

Question 1

Amazon Athena

Answer 1

o Allows you to run SQL queries on S3

o Interactive query service that allows
you to analyze and query data located
in S3

o Completely server-less, nothing to
provision

o No need to setup complex
extract/transform/load processes

o Used to analyze log data stored in S3

o Can be used for the following:
• Query log files in S3
• Generate business reports in S3
• Analyze cost and usage reports
• Run queries on click stream data

Question 2

Amazon CloudSearch

Answer 2

a service that makes it simple and cost effective to setup, manage, and scale a search solution for your website or application

Question 3

Amazon Elastic Map Reduce (EMR)

Answer 3

• Used to process large amounts of data
• Helps you analyze and process vast
  amounts of data by distributing the
  computational work across a cluster of
  virtual servers running in the AWS Cloud
• The cluster is managed using an open-
  source framework called Hadoop.
• Amazon EMR lets you focus on crunching
  or analyzing your data without having to
  worry about time-consuming setup,
  management, and tuning of Hadoop clusters
  or the compute capacity they rely on.

Question 4

Amazon Redshift

Answer 4

 Cloud data warehousing/online
analytics processing —> process of
collecting, storing, and organizing
data lakes to provide analytics for
better decision making

 Invented to help with online analytics
processing away from your production
database

 Used for business intelligence (tools like
Cognos, SQL Server, Oracle Hyperion)

 Used to pull in very large and complex
datasets

 Use different type of architecture both
from a database perspective and
infrastructure layer

Question 5

Amazon Elasticsearch Service

Answer 5

TBD

Question 6

Amazon Kinesis

Answer 6

Kinesis easily collects, processes, and analyzes real time streaming data for dashboard application