Brainscape's Knowledge GenomeTM

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


See full index

AWS > Databases > Flashcards

Databases Flashcards

1
Q

What 6 relational databases are available with AWS RDS?

A

SQL server, PostregreSQL, Oracle, MariaDB, MySQL, Aurora

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

What does OLTP stand for?

A

Online transaction processing

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

What is OLTP?

A

OLTP is the processing of data from transactions in real time

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

What does OLAP stand for?

A

Online analytical processing

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

What is OLAP?

A

OLAP is the processing of complex queries to analyze historical data

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

What does Multi-AZ RDS do?

A

Creates an exact copy of production database in another AZ

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

What is a read replica?

A

a read-only copy of your database

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

Can read replicas be cross region?

A

Yes

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

Why don’t read replicas have its own DNS end point?

A

It does

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

Can read replicas be promoted to their own databases?

A

Yes

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

What specific setting is required for read replicas to be enabled?

A

Automatic backup

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

How many read replicas can you have per database?

A

5

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

What is Amazon Aurora?

A

a MySQL and PostgreSQL compatible relational database engine that combines the speed and agility of high end commercial databases with the simplicity and cost effectiveness of open source databases

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

How much space does Aurora start with?

A

10 GB

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

How many copies are of your data are guaranteed with Aurora? How is this composed?

A

6 copies. 2 copies in 3 AZ

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

Is the Aurora database self-healing?

A

Yes

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

In what platforms can you have replicas?

A

Aurora, MySQL, PostgreSQL

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

Are backups automated for Aurora?

A

Yes

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

How much do backups impact Aurora database performance?

A

Not at all

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

What is Aurora serverless?

A

An on-demand auto scaling configuration for the MySQL and PostgreSQL compatible editions of Aurora.

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

What are the benefits of Aurora Serverless DB Cluster?

A

An Aurora DB cluster automatically starts up, shuts down, and scales capacity up or down based on your applications needs

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

What are Aurora serverless use cases?

A

When you need a relatively simple, cost effective option for infrequent or unpredictable workloads

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

Can you share your Aurora snapshots with other accounts?

A

Yes

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

Are automated backups default for Aurora?

A

Yes

25
Q

What is DynamoDB?

A

A fast and flexible NoSQL database service

26
Q

What data models does DynamoDB support?

A

document and key-value data models

27
Q

Is DynamoDB fully managed?

A

Yes

28
Q

What are some examples where DynamoDB would be a great fit?

A

Mobile, web, gaming, ad-tech, IoT

28
Q

What is the latency for DynamoDB?

A

Single digit millisecond

29
Q

What storage service type does DynamoDB use?

A

SSD

30
Q

Where is DynamoDB spread across?

A

3 geographically distinct data centers

31
Q

Is strongly consistent reads or eventually consistent reads default?

A

eventually consistent

32
Q

What is DAX?

A

DynamoDB Accelerator is a fully managed, highly available, in-memeory cache service for DynamoDB

33
Q

By what factor does DAX improve DynamoDB?

A

10x

34
Q

How is pricing structured for DynamoDB?

A

Pay per request

35
Q

What is the encryption type at rest for DynamoDB?

A

KMS

36
Q

What does ACID stand for?

A

ATOMIC, Consistent, isolated, durable

37
Q

What does atomic in ACID mean?

A

All changes to data must be successful or no changes at all

38
Q

What offering makes DynamoDB ACID?

A

DynamoDB transactions

39
Q

What is DynamoDB Backups?

A

An on demand backup and restore service

40
Q

What does DynamoDB Global Tables give you?

A

Manger multi master multi regional replication

41
Q

What needs to be enabled for DynamoDB global tables?

A

DynamoDB streams

42
Q

What is MongoDB?

A

A document database that allows for scalability and flexibility with your data as well as robust querying and indexing features

43
Q

What is Amazon DocumentDB?

A

Allows you to run MongoDB on the AWS cloud. It’s a managed database service that scales with your workloads and safely and durably stores your database information

44
Q

What is the advantage of AmazonDB over MongoDB?

A

Get rid of operational overheads like cluster management software, configuring backups, monitoring workloads

45
Q

What is Cassandra?

A

A distributed database (ie it runs on many machines) that uses NoSQL

46
Q

When is Cassandra typically used?

A

For big data solutions

47
Q

What is Amazon keyspaces?

A

Amazons Apache Cassandra database service. Allows you to run Cassandra workloads on AWS.

48
Q

What is the advantage of AWS keyspaces over Cassandra?

A

It is fully managed database. No need to worry about managing servers, software patching, etc.

49
Q

Is Amazon keyspaces serverless?

A

Yes

50
Q

What is Amazons graph database service?

A

Neptune

51
Q

What is a ledger database?

A

It is a NoSQL database that is immutable, transparent, and has a cryptographically verifiable transaction log that is owned by one authority

52
Q

What is Amazon Quantum Ledger Database?

A

QLDB is a fully managed ledger database that provides a transparent immutable and cryptographically verifiable transition log

53
Q

What is Amazon timestream?

A

A fully managed database service for time series data

54
Q

Is RDS suitable for OLAP or OLTP?

A

OLTP

55
Q

What are read replicas meant to improve?

A

Scaling (improves read performance) not distasteful recovery

56
Q

What is DynamoDB PITR?

A

Point in time recovery protects against accidental writes or deletes. Can restore any point in the last 35 days

57
Q

What are the 4 ways you can scale an RDS in AWS?

A

Vertical scaling, scaling storage, creating read replicas, aurora serverless

58
Q

What is the big thing you should be wary of when scaling storage?

A

it cant’t be scaled back down

AWS (18 decks)

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