1  OLTP vs. OLAP

2 OLAP vs OLTP

Why do you need both, what’s the difference, differences between rowstore, columnstore and row groups.

Why generally neither architecture be relevant to you because you are doing table scans anyway lol. OLAP as an engine optimised for fact table data, OLTP for transactional data.