Analytics

Question 1

analytics

Answer 1

the act of querying or processing your data

Question 2

data warehouse

Answer 2

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

Question 3

uses of a data warehouse

Answer 3

querying, reporting, analytics and business intelligence

- not used for transaction processing

Question 4

Redshift

Answer 4

AWS’s data warehousing solution

• improves speed and efficiency when querying
• handles exabyte-scale data

Question 5

Use cases for Redshift

Answer 5

• to consolidate multiple databases for reporting

- when you want to run a relational database that doesn’t need to do transactions

Question 6

Athena

Answer 6

a query service for Amazon S3

• can analyze S3 data using SQL
• pay per query
• serverless

Question 7

Glue

Answer 7

data integration service that prepares your data for analytics

• ETL service
• prepares and loads data
• helps you better understand your data
• serverless

Question 8

ETL

Answer 8

Extract, Transform and Load

Question 9

data integration

Answer 9

the process of preparing and combining data for analytics, machine learning, and application development. It involves multiple tasks, such as discovering and extracting data from various sources; enriching, cleaning, normalizing, and combining data; and loading and organizing data in databases, data warehouses, and data lakes.

Question 10

Kinesis

Answer 10

allows you to analyze data and video streams in real time

- supports: audio, video, application logs, website clickstreams, IoT

Question 11

Use case for Kinesis

Answer 11

analyze logs in near real time for application monitoring or fraud detection

Question 12

EMR

Answer 12

Elastic Map Reduce

• helps you process large amounts of big data
• analyze data using Hadoop
• works with big data frameworks like Apache Spark

Question 13

Data Pipeline

Answer 13

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

• moves data at specific intervals or based on conditions
• sends notifications of success or failure

Question 14

use case for Data Pipeline

Answer 14

to move data from S3 to Redshift