Analytics Services Flashcards

1
Q

What is a data warehouse?

A

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

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

What are the advantages of data warehouse?

A

Data warehouses support querying, reporting, analytics, and business intelligence.

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

Data warehouse is used for transaction processing?

A

NO

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

What is Amazon Redshift?

A

Is a scalable data warehouse solution.

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

Does Amazon Redshift handles exabyte scale data?

A

YES

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

What is Athena?

A

Is a query service for Amazon S3.

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

Is Athena Serverles?

A

YES

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

How do you pay in Athena?

A

Pay per query.

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

What is Glue?

A

Prepares data for analytics.

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

Is Glue and ETL service?

A

YES

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

What is Kinesis?

A

Allows to analyze data and video streams in real time.

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

What formats does Kinesis support?

A

Video, audio, application logs, website, clickstreams and IoT.

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

What is Elastic MapReduce (EMR)?

A

Helps you to process large amounts of data.

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

What does EMR use to analyze data?

A

Hadoop.

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

What is data pipeline?

A

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

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