Let’s cover some more not so obvious points listed above.
Azure SQL DW is not a good fit for solutions that share the same data warehouse for multiple customers.
Though Azure SQL DW allows separate schemas, development cost and complexity for a single database with separate schemas for multiple customers is quite high, can be a security nightmare if compromised.
It is impossible to restore a single schema if something goes wrong for a particular customer.
Transaction processing systems, aka operational systems, or OLTP systems, can be categorized by real time transactions that perform atomic writes and reads .