Brainscape's Knowledge GenomeTM

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


See full index

AWS SAA > Databases > Flashcards

Databases Flashcards

1
Q

TRUE or FALSE: Patching or RDS OS and DB is Amazon’s responsibility

A

TRUE

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

Maximum RDS Storage Size

A

16TB

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

Is RDS serverless?

A

FALSE

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

My RDS is not attaching to my EC2 unit what might be the issue?

A

Make sure to add EC2 security group to rds security group

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

TRUE or FALSE: A restored RDS database has the same RDS endpoint

A

FALSE

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

Prerequisite for enabling Read Replica on RDS Database

A

Must have automatic backups turned on

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

TRUE or FALSE: You can have a RDS Read Replica in a different region

A

TRUE

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

What RDS are available (6)?

A

SQLServer
Oracle
MySQLServer
PostgreSQL
Aurora
MariaDB

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

What types of backups does RDS offer?

A

1) Automated Backups

2) DB Snapshot

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

What is the Retention Period of an RDS Automated Backup?

A

1-35 days

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

Describe an RDS Automated Backup

A

Takes a full daily snapshot and store logs throughout the day.

Recovery AWS chooses most recent daily backup and applies logs

Recovery is down to second w/ in retention period (Point int time recovery)

Default

Backups stored on s3 (free storage equal to size of DB)

Storage I/O may be suspended and may experience elevated latency during backup

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

Can you encrypt an RDS database?

A

Yes, encryption is done at rest using KMS.

But you cannot encrypt a currently existing DB

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

How to encrypt an existing DB?

A

Have to create a snapshot and encrypt that

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

What is Multi-AZ?

A

Host RDS in multiple availability zones for DISASTER RECOVERY.

Note this does nothing for performance.

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

What is Read Replica?

A

It is a way to scale out a DB load over multiple read replicas. Uses async replication from primary RDS to read replicas.

Use this on heavy read DB workloads.

Used for SCALING

Must have AUTO BACKUPS on in order to deploy read replica.

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

How many read replicas can you have?

A

5

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

Can you promote RR to become own DB?

A

Yes, but note this breaks replication

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

Which RDS Databases have RR capabilities?

A

MySQL
PostgreSQL
MariaDB
Aurora

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

How to collect all SQL statements that take a long time to execute?

A

Enable slow query log in RDS

20
Q

Default READ consistency of Dynamo DB

A

Eventually Consistent Reads

but can get strong consistent

21
Q

How to add Caching to DynamoDB to increase preformance

A

DAX

22
Q

of AZ for DynamoDB

A

At least 3

23
Q

What type of storage is DynamoDB stored on

A

SSD

24
Q

IF you need ACID all or nothing on DynamoDB

A

Transactions

25
Q

TRUE or FALSE DynamoDB On Demand Backup and Restore effects table preformance

A

FALSe

26
Q

TRUE or FALSE DynamoDB Point in time recovery is enabled by default

A

FALSE

27
Q

DynamoDB PITR max # of days to restore from

A

35 days

28
Q

DynamoDB PITR latest retore time

A

5 minutes

29
Q

TRUE or FALSE DynamoDB tables can be replicated across Regions

A

TRUE, DynamoDB Global Tables (based on DynamoDB streams)

30
Q

Benefits of DynamoDB global tables

A

Multi-region redundandy
Disaster Recovery
High Availability

31
Q

Want to move MongoDB to the Cloud

A

Use AWS Database Migration Service
Select AWS DocumentDB

32
Q

Database used for big database workloads distributed over many servers (NoSQL)

A

Cassandra

33
Q

What is AWS Keyspaces

A

Allows you to run your Cassandra DB in AWS
Serverless

34
Q

What AWS Service is used for Graph DB ?

A

Neptune

35
Q

AWS Service with NoSQL immutable database (Ledger database)

A

QLDB

36
Q

Uses for QLDB

A

Crypto
Bank Transactions
Shipping
Claims System
System of Record Application

37
Q

AWS Time Series Database

A

Amazon Timestream

38
Q

Examples of time series data

A

IoT
Analytics
Devops Applications

39
Q

Need a database that is relational and can store petabytes of data

A

Redshift

40
Q

Max size of Redshift database

A

16 PB of data

41
Q

Automatically on-demand scaling database which is a budget friendly service based on Aurora

A

Aurora Serverless

42
Q

ACU units are about how big?

A

Aurora Compute Units are approx

2 GiB memory , matching CPU, and netoworking

43
Q

Aurora allows for how many copies of data (data resilency)

A

6 copies of data across 3 AZ

44
Q

How to implement high availability on Aurora

A

Enable multi-AZ

45
Q

6 popular use cases for aurora serverless

A

Variable Workloads
Multi-Tenant Apps
New Apps
Dev & Test apps
Multi-Use Apps
Capacity planning

46
Q

How to manage capacity planning on Aurora Serverless databases?

A

Set Min and Max ACU you want to use

Then you are billed per second for what you actually use

AWS SAA (15 decks)

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