Storage Flashcards

1
Q

What service can use use to query S3 using SQL syntax

A

Athena

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

What analytics service allows you to process data streams in real time with SQL or Apache Flink without having to learn new programming languages or processing frameworks.

A

Kenesis data analytics

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

What analytics service provides Scalable and durable real-time data streaming service that can continuously capture gigabytes of data per second from hundreds of thousands of sources.

A

Kenesis Data Streams

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

What analytics service is best for ETL

A

Glue

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

What analytics service is best for analysing large datasets for monthly roll-ups

A

Redshift

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

How many DB Engines can be used with RDS

A
  1. SQLServer, Postgres, Oracle, MySql, MariaDB & Aurora
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

RDS Multi-AZ is best for DR or Performance Improvments?

A

DR

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

RDS Read Replicas are best for DR or Performance Improvments?

A

Performance Improvments for read heavy workloads.

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

What DB Engines can you use with Aurora?

A

Mysql & postgresql

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

Aurora stores replicas in how many AZ’s

A

3

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

What AWS DB is best for NoSQL DB’s

A

DynamoDB

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

How can DyanamoDB read performance be improved

A

DynamoDB Accelerator (DAX)

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

What service can you use if you need a MySQL Database but for very intermittent workloads

A

Aurora Serverless

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

Aurora is best for OLAP or OLTP transactions?

A

OLTP

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

What Service provides NoSQL DB with ACID?

A

DynamoDB Transactions

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

What AWS DB is best for MongoDB migrations

A

Document DB

17
Q

What service can be used for MongoDB migrations to DocumentDB

18
Q

What service is best for apache cassandra, big data, nosql

19
Q

AWS’s Graph DB is called…

20
Q

AWS’s Ledger DB is called

A

Quantum Ledger DB

21
Q

AWS DB for analysing timeseries data

A

Timestream

22
Q

S3 Max single file size

23
Q

What are the 3 “at-rest” encryption options for S3

A

SSE-S3, SSE-KMS & SSE-C

24
Q

How can you structure S3 buckets to improve performance

A

Spread across folders

25
How can you improve S3 upload performance
Multi part uploads
26
How can you improve S3 download performance
Byte Range Fetches
27
What AWS Services are event notification destinations for S3 buckets
SQS, Lambda, SNS
28
How can you improve the performance of DynamoDB during peak loads by dynamically adjusting provisioned throughput capacity on your behalf, in response to actual traffic patterns
DynamoDB Autoscaling