DP-3001 Migrate SQL Server workload to Azure SQL
Module 1: Designing a SQL Server Migration Strategy
– Understanding data platform modernization
– Planning a data migration strategy
– Exploring available data migration technologies
Module 2: Assessing SQL Server Databases for Migration to Azure SQL
– Reviewing database compatibility for migration to Azure SQL
– Exploring assessment options for database migration
– Assessing a database using Azure Migration extension
– Assessing a database with Azure Migrate
– Assessing a database with Data Migration Assistant
Module 3: Deploying PaaS Solutions with Azure SQL
– Explaining PaaS options for deploying SQL Server in Azure
– Exploring single SQL database deployment
– Deploying SQL database elastic pool
– Understanding SQL database hyperscale
– Examining SQL managed instance
– Describing SQL Edge
Module 4: Configuring Database Authentication and Authorization
– Describing Active Directory and Microsoft Enterprise ID
– Explaining authentication and identities
– Describing Security Principals
– Describing database and object permissions
– Identifying authentication and authorization failures
Module 5: Migrating SQL Server Workloads to Azure SQL Database
– Selecting the right Azure SQL Database feature for migration
– Using Azure SQL migration extension for migration
– Exploring Data Migration Assistant for migration
– Migrating to Azure SQL Database using BACPAC
– Using an online method to migrate to Azure SQL Database
– Moving data to Azure SQL Database
Module 6: Performing Post-Migration Tasks on Azure SQL
– Migrating SQL logins and groups
– Implementing security measures to protect Azure SQL
– Implementing compliance controls for sensitive data
– Configuring high availability and disaster recovery
– Automating database tasks for scalability