Choosing databases, migration paths and analytics services

AZ-305 · Design data storage solutions · Updated

Decide between Azure SQL Database, Managed Instance, SQL on VMs and Cosmos DB, plan migrations, and pick Fabric, Synapse, Databricks or Data Factory.

This lesson is part of full AZ-305 access

The first 2 AZ-305 lessons are free. Full access opens every lesson with its practice questions, and the exam-style AZ-305 question bank.

In this lesson
  • Relational options
  • Resilience for SQL
  • Protecting data
  • Cosmos DB
  • Migration tools
  • Analytics
  • Exam traps
  • Practice questions

Get full access Try the free practice exam Log in

AZ-305 course outline

All 8 lessons · Course overview
  1. Governance with Policy, RBAC and management groupsDesign identity, governance and monitoring solutions Free
  2. Designing authentication and application identityDesign identity, governance and monitoring solutions Free
  3. Designing monitoring with Azure MonitorDesign identity, governance and monitoring solutions Full access
  4. Choosing storage services, redundancy and protectionDesign data storage solutions Full access
  5. Choosing databases, migration paths and analytics servicesDesign data storage solutions Full access
  6. Designing backup, high availability and disaster recoveryDesign business continuity solutions Full access
  7. Choosing load balancing and network connectivityDesign infrastructure solutions Full access
  8. Choosing compute, containers and integration servicesDesign infrastructure solutions Full access