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

A

AWS DMS

18
Q

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

A

Keyspaces

19
Q

AWS’s Graph DB is called…

A

Neptune

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

A

5TB

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
Q

How can you improve S3 upload performance

A

Multi part uploads

26
Q

How can you improve S3 download performance

A

Byte Range Fetches

27
Q

What AWS Services are event notification destinations for S3 buckets

A

SQS, Lambda, SNS

28
Q

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

A

DynamoDB Autoscaling