Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

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
What are the characteristics of Dynamo DB?
SSD spread across three regions eventual consistent reads (default) strongly consistent reads
26
You need data written to a dynamo DB read back withi seconds. What option do you choose
strongly consistent reads
27
What is elasticache?
cloud in memory cache to improve performance of web application
28
What are the types of elasticache?
memcacheD redis
29
Describe redis
key values store master slave multi az
30
Describe memcached
widely adopted protocol object caching
31
What database services are available on AWS?
RDS-OLTP DynamoDB (NoSQL) RedShift (OLAP) Elasticache (in memory caching) DMS
32
What OLTP databases are available in RDS?
MS SQL Server MySQL PostgreSQL Oracle MariaDB Aurora
33
What cache services are available in RDS Elasticache?
Memcached Redis
34
What is Elasticache?
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
What are the types of backups supported on RDS?
Automated Backups and Database Snapshots
36
How does Automated Backups work?
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
What is Multi-AZ RDS?
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
What is the use case for Multi-AZ RDS
Multi-AZ is for disaster recovery. It is not used for improving performance. For performance improvement, Read Replicas are needed.
39
Can Multi-AZ be used to performance improvement?
No. Multi-AZ is for disaster recovery. It is not used for improving performance. For performance improvement, Read Replicas are needed.
40
What options do you have to improve DB performance
Read replicas and elasticache
41
What are the maximum number of read replicas?
5
42
How do read replicas improver performance?
EC2 instances can be confiured to use the relica copies and spread out the load
43
What is the DB service that provided OLAP?
Red shift
44
What is the use case for elasticache?
Speed up existing DB's by delivery frequestly access queries
45
What is the cost of RDS backups?
nothing. stored in S3
46
Characteristics of RDS snapshots?
Manual retained after RDS instance is deleted
47
When an RDS instance is restored will the end point be the same
No
48
In RDS multi-az you lose the primary. What happens
Endpoint auto fails over
49
What DBs provide read multi-az?
MySQL Postgres MariaDB Aurora
50
What DBs provide read read replicas??
Aurora MySQL
51
What is the use case for redshift?
data warehousing
52
What are the two types of redshift configurations?
single node multi node
53
What are the max number of compute nodes in a redshift multi node config?
128
54
Describe red shift security characteristics?
in transit SSL at rest 256Key mgmt or self mgmt w/ HSM or AWS key mgmt
55
What are the max number of aurora replicas?
15
56
Aurora scaling characteristics?
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
Aurora replica characteristics?
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