Brainscape's Knowledge GenomeTM

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


See full index

2019 - AWS CSAA > Database on AWS > Flashcards

Database on AWS Flashcards

1
Q

What are the RDS DB options?

A

SQL

MySQL

PostgesSQL

Oracle

Aurora

MariaDB

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

What is the best DB option for online analytics

A

Red Shift

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

You need an RDS database, but do not want to manage the OS. What can you use?

A

Any RDS, it runs on VMs but you cannot RDP or SSH to them

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

Is RDS serverless?

A

No, except for aurora

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

What are the RDS backup options?

A

Automated and snapshots

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

You need to improve your RDS DB performance. What can you do?

A

Use read replicas

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

What are the characteristics of read replicas?

A

Can be multi-az, increases performance, must have backups turned on, can be in different regions, Can be aurora or MySQL and can promote RR to master

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

You promoted a read replica to master, what will break?

A

replication

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

What is the use case to use multi-az RR?

A

DR

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

How can you force a multi-az failover?

A

Reboot one of the instances

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

What DB’s provide encryption?

A

MySQL,

Oracle,

SQL Server,

Postgres,

MariaDB

Aurora.

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

What encryption service does RDS use?

A

AWS Key mgmt Service (KMS)

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

What are the characteristics of DynamoDB?

A

SSD Spread across thre geographically distinct data centers Eventual consistent reads (default) Strongly consistent

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

What is the use case for red shift?

A

business intelligence

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

Is multi-az available for red shift?

A

No

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

What is the maximum retention for red shift backups?

A

35 days

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

How many copies does red shift maintain of your data?

A

three. Original and replica on compute and an S3 backup

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

What DR options are available for red shift?

A

asynchronously replicate snapshots to S3 in another region

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

How many copies of your data are maintained in Aurora?

A

6 copies. 2 copies in each AZ with a minimum of 3 az’s

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

What are the RDS DB types?

A

SQL

MySQL

Postgres

Aurora

Oracle

Maria DB

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

What is the use case for RDS?

A

Online transaction processing

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

What is the use case for redshift?

A

data warehousing

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

What are the four DB services?

A

RDS

DynaomoDB

Redshift

Elasticache

24
Q

What are the types of elasticache?

A

memcahced

redis

25
Q

What are the characteristics of Dynamo DB?

A

SSD

spread across three regions

eventual consistent reads (default)

strongly consistent reads

26
Q

You need data written to a dynamo DB read back withi seconds. What option do you choose

A

strongly consistent reads

27
Q

What is elasticache?

A

cloud in memory cache to improve performance of web application

28
Q

What are the types of elasticache?

A

memcacheD

redis

29
Q

Describe redis

A

key values store

master slave

multi az

30
Q

Describe memcached

A

widely adopted protocol object caching

31
Q

What database services are available on AWS?

A

RDS-OLTP DynamoDB (NoSQL) RedShift (OLAP) Elasticache (in memory caching) DMS

32
Q

What OLTP databases are available in RDS?

A

MS SQL Server

MySQL

PostgreSQL

Oracle

MariaDB

Aurora

33
Q

What cache services are available in RDS Elasticache?

A

Memcached Redis

34
Q

What is Elasticache?

A

Amazon ElastiCache is a web service that makes it easy to deploy, operate, and scale an in-memory data store or cache in the cloud.

35
Q

What are the types of backups supported on RDS?

A

Automated Backups and Database Snapshots

36
Q

How does Automated Backups work?

A

Automated Backups allow you to recover your DB to any point in time within a “retention period”. Retention Period can be between 1 and 35 days. Automated Backups will take a full daily snapshot and will also store the transaction logs throughout the day.

37
Q

What is Multi-AZ RDS?

A

Multi-AZ allows to have an exact copy of your production database in another AZ. In the event of planned DB maintenance, BD instance failure, or an Availability Zone failure, Amazon RDS will automatically failover to the standby.

38
Q

What is the use case for Multi-AZ RDS

A

Multi-AZ is for disaster recovery. It is not used for improving performance. For performance improvement, Read Replicas are needed.

39
Q

Can Multi-AZ be used to performance improvement?

A

No. Multi-AZ is for disaster recovery. It is not used for improving performance. For performance improvement, Read Replicas are needed.

40
Q

What options do you have to improve DB performance

A

Read replicas and elasticache

41
Q

What are the maximum number of read replicas?

42
Q

How do read replicas improver performance?

A

EC2 instances can be confiured to use the relica copies and spread out the load

43
Q

What is the DB service that provided OLAP?

44
Q

What is the use case for elasticache?

A

Speed up existing DB’s by delivery frequestly access queries

45
Q

What is the cost of RDS backups?

A

nothing. stored in S3

46
Q

Characteristics of RDS snapshots?

A

Manual

retained after RDS instance is deleted

47
Q

When an RDS instance is restored will the end point be the same

48
Q

In RDS multi-az you lose the primary. What happens

A

Endpoint auto fails over

49
Q

What DBs provide read multi-az?

A

MySQL

Postgres

MariaDB

Aurora

50
Q

What DBs provide read read replicas??

A

Aurora

MySQL

51
Q

What is the use case for redshift?

A

data warehousing

52
Q

What are the two types of redshift configurations?

A

single node

multi node

53
Q

What are the max number of compute nodes in a redshift multi node config?

54
Q

Describe red shift security characteristics?

A

in transit SSL at rest

256Key mgmt or self mgmt w/ HSM or AWS key mgmt

55
Q

What are the max number of aurora replicas?

56
Q

Aurora scaling characteristics?

A

10 GB to 64TB up to 32 vCPUs and 244 GB or mem

2 copies of DB in each AZ w/ min of 3 AZs

Transparently handle loss of up to two copies

Self healing

57
Q

Aurora replica characteristics?

A

Aurora Replicas 15 (auto-failover)MySQL replicas 5

2019 - AWS CSAA (9 decks)

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