RDS (OLTP): Sql server, oracle, mysql, postgres, aurora, mariadb

With multi AZ: Amz will auto switch to another replica when the other one down

With Read Replicas

Data Warehousing

Used to pull very large and complex data sets, usually used by management to do queries on data

Use for business intelligence, tools like Cognos, Jaspersoft, ...

OLTP vs OLAP

Different in terms of the types of queries you will run

Online Transaction Processing (OLTP)