Leveraging Analytics Services Flashcards

1
Q

What is a data warehouse?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is Amazon Redshift?

A

Is an AWS warehouse solution

Handles a LOT of data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What are some real world use cases of Amazon Redshift?

A

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)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is Athena?

A

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

You pay per query and it is serverless.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What are some real world use cases of Athena?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is Glue?

A

Prepares your data for analytics.

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is Kinesis?

A

Real time streaming data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What are some real world use cases of Kinesis?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is Elastic MapReduce (EMR)?

A

Helps you process large amounts of data.

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is Data Pipeline?

A

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

Sends notification on failure

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is QuickSight?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly