Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

aws > DataBase > Flashcards

DataBase Flashcards

1
Q

Keyword “NFS” (or storage gateway) + no code changes + highly available + durability (posix compliant)

A

EFS

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

Storage which allow concurrent access ? (2)

A

S3 and EFS

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

Storage which allow strong consistency ? (3)

A

DynamoDB, EFS, RDS

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

Which storage provides strong Read-after-write consistency (most up-to-date data) ?

A

RDS

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

concurrent access + strong data consistency + file locking + Shared File System + Directories permission

A

EFS

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

What happens when RDS failure ?

A

RDS performs an automatic failover to the standby DB instance

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

Whith which type of DataBase IAM database authentication works ? (auth token not password) (3)

A

MariaDB, Mysql and Postgresql

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

how to enhance RDS performance ? (2)

A

Read replica + larger instance types

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

OLAP database + analytical queries involving complex calculations + data warehouse + columnar storage

A

Redshift

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

Which DB allows you to directly run SQL queries against exabytes of unstructured data in Amazon S3. No loading or transformation is required.

A

Redshift Spectrum

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

designed for globally distributed applications, allowing a single XXX database to span multiple AWS regions.
What is XXX ?

A

Aurora Global DB

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

What type of endpoint support DynamoDB and S3 ?

A

gateway endpoint (not interface)

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

built-in security + continuous backups + automated multi-Region replication + in-memory caching + Fast and predictable performance with consistent low latency + Possible to enable auto-scaling ?

A

DynamoDB

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

Fully managed + flexible schema + automatic scaling with no downtime + data in chunks

A

DynamoDB

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

Lowest latency data retrieval + highest scalability (50 ms latency + increasing exponentially)

A

DynamoDB

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

When to use snwomobile vs snowball ?

A

To migrate large datasets of 10PB or more in a single location, you should use Snowmobile (or snowball edge).
For datasets less than 10PB or distributed in multiple locations, you should use Snowball.

17
Q

Mulit AZ vs Read replica, which is async and which is sync ?

A

Multi AZ : sync and highly durable

Read replica : async and highly scalable

18
Q

Mulit AZ vs Read replica

AZ and region ?

A

multi AZ : always span two AZ in one region

read replica : can be within an AZ, cross AZ or cross region

19
Q

Mulit AZ vs Read replica, failover ?

A

Multi AZ : automatic failover to standby when a problem is detected
Read replica : can be manually promoted to a standalone db instance

20
Q

OLAP database

A

Redshift

aws (12 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions