Database - RDS, Dynamo, PostgreSQL, Aurora, MySQL, MariaDB, Elasticache Flashcards
RDS, Dynamo, PostgreSQL, Aurora, MySQL, MariaDB, Elasticache
What is a relational database?
a traditional database that is made up like a spreadsheet with tables, rows, and fields.
Name the database Types in AWS
SQL server Oracle MySQL Server PostgreSQL Aurora MariaDB
Describe how a non-relational database works
collection = table document = row key value pairs - fields
What is data warehousing?
It is used to pull in very large and complex data sets. Usutally used by management to do queries on data (such as current performance vs targets, etc.) It is used for business intelligence. Tools like Cognos, Jaspersoft, SQL Server Reporting Services, Oracle Hyperion, and SAP Netweaver.
What is OTLP?
Online Transaction Processing
What is OLAP?
Online Analytics Processing
How do OLAP and OTLP differ?
They differ in terms of queries you will run. OTLP example: 2120121 -pulls up a row of data such as NAME, Date, Address to deliver to, delivery status, etc. OLAP example: Pulls in large number of records. Net profit for EMEA and Pacific for the digital record product. Sum of radios sold in EMEA Sum of radios sold in pacific Unit cost of Radio in each region Sales price of each radio Sales price - unit cost
T or F data warehousing databases use the same type of architecture from a db perspective and infrastructure layer.
False data warehousing uses different type of architecture both from a DB perspective and infrastructure layer.
A web server that makes it easy to deploy, operate, and scale in memory cache in the cloud is called what?
Elasticache
T or F Elasticache improves the performance of web apps by allowing you to retrieve info from fast, managed, in-memory caches, instead of relying entirely on slower disk based databases.
True
Name the types of Elasticache:
Memcached and Redis
Name the two types of RDS backups for AWS:
Automated backups and DB snapshots
_____ allows you to recover your DB to any point in time within a retention period.
- Automated backups
- DB Snapshots
automated backups
These types of backups are done manually (user initiated)
- Automated backups
- snapshots
Snapshots
The retention period for autometed backups can be between _____ and ___ days.
- 1 and 5
- 1 and 35
- 1 and 100
- infinite
2) 1 and 35
Automated backups will take a full daily snapshot and will also store
____ logs during the day
transaction
T or F
When you do a recovery, AWS will first choose the most recent daily backup and then apply transaction logs relevant to that dayl. This allows you to do a point in time recovery down to a second, within the retention period.
True
T or F
Automated backups are disabled by default.
False
Automated backups are enabled by default
Where are automated backups stored?
S3
T or F
With automated backups, you get unlimited, free storage space in S3.
False.
You get free storage space = to the size of your DB.
T or F
Backups are taken every time a change is made to the DB.
false.
Backups are taken within a defined window.
T or F
During the backup window, storage IO may be suspended while your data is being backed up and you may experience elevated latency.
True
T or F
Snapshots are stored even after you delete the original RDS instance, unlike automated backups
True
T or F
Whenever you restore either an Automated backup or a manual snapshot, the restored version of the DB will be a new RDS instance with a new DNS endpoint.
True