Right Data Offering for a Relational Workload- High level understanding

Identify the Right Data Offering for a Relational Workload- High level understanding 

Azure SQL server

1. Needs to perform high speed online transaction processing (OLTP) operations

2. Highly normalized with enforced schemas

3. Requires high integrity and strong consistency

Azure SQL server (single database)

• Up to date relational database service, however not fully compatible with on-premises

Azure SQL server (managed instance)

• Most of PaaS benefits and high compatibility, lift and shift on-prem databases

Azure SQL server(virtual machines)

• Allows OS level access, install specific version of SQL server on VM

Azure Synapse Analytics (Azure DW)

1. Enterprise data analytcis system workload

2. MPP architecture

3. Provides set of tools to organize and analyse enterprise data

Azure Cosmos DB

1. Targeted for non -relational data stores

Azure blob storage/Azure Data lake

1. Store binary data - images/videos

PostgreSQL, MySQL, MariaDB 

1. Deploy existing on-prem databases to Azure