Analytics - AWS Athena Flashcards

1
Q

Purpose

A

Query data in S3 using SQL

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

Alternative Name

A

Serverless

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

Use Case

A

analyze and process unstructured or structured data in S3 using ANSI SQL

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

Security

A

IAM, ACLs, S3 BP, SSE, KMS

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

Access

A

?

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

Availability

A

S3’s HA

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

Durability

A

S3’s durability

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

Scalability/Auto Scale

A

?

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

On-Prem Option

A

?

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

Storage Limitation

A

?

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

Retention

A

?

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

Caching

A

?

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

Monitoring

A

?

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

Backup/Restore

A

?

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

Execution Time

A

?

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

Maintenance

A

?

17
Q

Pricing

A

per query, amount of data scanned by the query; lower cost

18
Q

Billing

A

?

19
Q

Competition

A

Amazon EMR, Redshift