Azure DB's Flashcards
Azure SQL DB (7)
Cloud hosted managed PaaS SQL Server DB
Relational DB Mnt system
Application backed in online transaction processing paradigm (OLTP)
Reading from and writing to often
Vertically scaled
Geo replication (replicas around the world using Azure is easy)
Threat analytics (Azure scans DB and access patterns)
Azure Synapse Analytics (6)
Formerly Azure SQL Data Warehouse
Relational
Online Application Processing
Massive horizontal scale (no need to setup cluster)
Data warehousing (already defined =just platform for analysis)
Big data analytics (integration between big ones apache and data bricks)
Cosmos DB (3)
Globally distributed multimodel non-relational DB
noSQL (non-relational / no schema)
Azure DB MIgration Service
Azure Migrate
One stop shop for any kind of migration into Azure
Online or offline DB migration at scale (several DB migrations at once from on-prem or cloud)
First class support for sql server, AWS, mySQL, Oracle, MongoDB PostgreSQL