AWS DB Flashcards Preview

Aws for work > AWS DB > Flashcards

Flashcards in AWS DB Deck (12)
Loading flashcards...
1
Q

How many relational databases?

A

6

2
Q

List all the relational DBs?

A
  • SQL Server
  • Oracle
  • MySQL Server
  • postgresSQL
  • Aurora
  • MariaDB
3
Q

What is NoSQL DB?

A

DynamoDB

4
Q

What is best for OLAR?

A

Redshift

5
Q

None Relational DB Are:

A

Collection = table
Document = Row
Key Value Pairs = Fields

6
Q

OLTP (online Transaction Processing) VS OLAP (online Analytics Processing)

A
  • OLAP require Data Warehousing both from database and infrastructure later
  • Redshift is Amazon’s Data Warehousing
7
Q

What is ElasticCache?

A

Web service that makes it easy to deploy, operate, and scale an in-memory cache in the cloud. improves the performance of your web applications by allowing you to retrieve information
from fast manage in memory caches instead of relying entirely on slower dis based databases.
2 open-source in-memory caching engines: Memcached and Redis

8
Q

what are the 2 open-souerce in-memory caching engines

A

Memcached

Redis

9
Q

RDS- Back Ups

What are the two different RDS Backups?

A
  • automated backups

- database Snapshots

10
Q

Automated back ups

A
  • Any point in time in retention period (1 to 35 days)
  • full day snapshots and transaction logs throughout the day.
  • When you do recovery , AWS takes the latest backup and apply the transition logs relevant to that day.
  • Point in time recovery down to the second within the retention period
  • Automated Backups are enabled by default
  • data is stored in S3 and free storage equal to the size of your database
  • during backup window (that is defined) storage I/O may be suspended while your data is being backed up and you may experience elevated latency
11
Q

Database Snapshots

A
  • manual (user initiated)

- they are stored even after the original RDA instance (unlike automated backups)

12
Q

Restoring backups

A

Restored version of the database will be new RDS instance with a new DNS endpoint