PART 4: DATABASE SERVICES

4.1 Azure SQL Database

Overview

Fully managed SQL Server database (PaaS).

Deployment Options

Option	Description	Use Case
Single Database	Dedicated DB	Single app
Elastic Pool	Shared resources	Multi-tenant SaaS
Managed Instance	Near full SQL compatibility	Lift-and-shift

Service Tiers

Tier	Use Case
General Purpose	Most workloads
Business Critical	High performance
Hyperscale	Very large DBs

Key Features

• Automatic backups (PITR)
• Geo-replication
• Failover groups
• TDE encryption
• Row-level security
• Auditing

4.2 Azure SQL Managed Instance

Overview

Near-100% SQL Server compatibility for migrations.

• SQL Agent
• Cross-database queries
• VNet integration

4.3 Azure Database for PostgreSQL

Overview

Managed PostgreSQL with Flexible Server.

• Zone-redundant HA
• Read replicas
• Connection pooling (PgBouncer)

4.4 Azure Database for MySQL

Managed MySQL with similar features to PostgreSQL.

4.5 Azure Cosmos DB

Overview

Globally distributed NoSQL database.

APIs

API	Use Case
NoSQL	Document DB
MongoDB	Mongo migration
Cassandra	Cassandra workloads
Gremlin	Graph DB

Consistency Levels

Level	Description
Strong	Latest data always
Session	Read-your-own-writes
Eventual	Lowest latency

Key Features

• Global distribution
• Partition key
• RU-based pricing
• Change feed
• TTL

4.6 Azure Cache for Redis

Overview

In-memory cache for fast access.

Tiers

Tier	Use Case
Basic	Dev/test
Standard	Production
Premium	Enterprise

Use Cases

• Caching
• Session storage
• Real-time analytics

4.7 Azure Synapse Analytics

Overview

Unified analytics platform.

• Dedicated SQL Pool
• Serverless SQL Pool
• Spark
• Data pipelines

4.8 Azure Databricks

Overview

Spark-based analytics platform with Delta Lake.

• Notebooks
• Auto-scaling clusters
• Delta Lake (ACID)
• MLflow

4.9 Azure Data Explorer (Kusto)

Fast analytics for logs and telemetry using KQL.