Database

Question 1

Database 101

Exam Tips

Let’s Create Our First RDS Instance - Demo Exam Tips

Answer 1

==> Relational database: for OLTP

MSSQL
MYSQL
Oracle DB
Postgres SQL
Maria DB
AWS Aurora

==> Non-relational DB
Dynamo DB provided by AWS

==> RDS has 2 key features

       * Multi AZ: for disaster recovery
       * Read replicas : for performance 

==> What is data warehousing?

Used for business intelligence. tools like cognos, jasper soft, oracle Hyperion, SQL server reporting services, SAP business warehouse.

used to pull very large and complex datasets. Used by management do to queries on the data.

==> OLTP Online Transaction processing
Example: we can find specific order, it will pull up a row of data
==> OLAP Online Analytical processing
Example: Net profit of EMEA and pacific for the digital radio product
pulls in large number of records, query on large set of data

==> Amazon redshift is amazon data warehousing product. this is used OLAP

==> Elastic cache:

    Elastic cache is a webservice that makes it easy to deploy, operate and scale in-memory cache in the cloud. the  service improves the performance of web application by allowing application to retrieve information from fast, managed, in-memory caches, instead of relying entirely on slower disk databases

Elastic cache supports 2 open source in-memory caching engines.
==> Memcached
==> Redis

Question 2

Dynamo DB

Answer 2

dsada

Question 3

Advanced Dynamo DB

Answer 3

sadsa

Question 4

Reshift

Answer 4

ads

Question 5

Aurora

Answer 5

asd

Question 6

Elastic cache

Answer 6

asd

Question 7

Database migration service

Answer 7

adf

Question 8

caching strategies on aws

Answer 8

afas

Question 9

EMR overview

Answer 9

asd

Question 10

RDS: Backups, Multi-AZ, and Read Replicas

Answer 10

sad