DP-3001MSMicrosoftMS-DP-3001A<ul> <li>Experience with SQL Server databases.</li><li>Knowledge of SQL Server editions and versions.</li><li>Basic knowledge of security concepts like identities and permissions.</li><li>Experience using the Azure portal to create resources and set permissions.</li></ul><h4>Design a SQL Server migration strategy</h4><ul> <li>Introduction</li><li>Examine data platform modernization</li><li>Plan a data migration</li><li>Explore the available data migration technologies</li><li>Exercise: Compare on-premises Azure costs</li><li>Module assessment</li><li>Summary</li></ul> <h4>Assess SQL Server databases for migration to Azure SQL</h4><ul> <li>Introduction</li><li>Review database for compatibility</li><li>Explore assessment options for database migration</li><li>Assess SQL Server with Azure Arc</li><li>Assess a database with Azure Migrate</li><li>Exercise: Identify compatibility issues</li><li>Module assessment</li><li>Summary</li></ul> <h4>Deploy IaaS solutions with Azure SQL</h4><ul> <li>Introduction</li><li>Explain IaaS options to deploy SQL Server in Azure</li><li>Understand hybrid scenarios</li><li>Explore performance and security</li><li>Explain high availability and disaster recovery options</li><li>Exercise: Provision a SQL Server on an Azure Virtual Machine</li><li>Module assessment</li><li>Summary</li></ul> <h4>Deploy PaaS solutions with Azure SQL</h4><ul> <li>Introduction</li><li>Explain PaaS options for deploying SQL Server in Azure</li><li>Explore single SQL database</li><li>Deploy SQL database elastic pool</li><li>Understand SQL database hyperscale</li><li>Examine SQL managed instance</li><li>Exercise: Deploy an Azure SQL Database</li><li>Module assessment</li><li>Summary</li></ul> <h4>Migrate SQL Server workloads to Azure Virtual Machine</h4><ul> <li>Introduction</li><li>Review migrations strategies and tools</li><li>Understand distributed availability group for migration</li><li>Migrate databases using native backup and restore</li><li>Compare additional migration methods</li><li>Exercise: Migrate SQL Server databases to SQL Server on Azure Virtual Machine</li><li>Module assessment</li><li>Summary</li></ul> <h4>Migrate SQL Server workloads to Azure SQL Database</h4><ul> <li>Introduction</li><li>Choose the right Azure SQL Database feature</li><li>Use Azure Database Migration Service to migrate to Azure SQL Database</li><li>Migrate to Azure SQL Database using BACPAC</li><li>Use an online method to migrate to Azure SQL Database</li><li>Move data to Azure SQL Database</li><li>Exercise - Migrate a SQL Server database to Azure SQL Database</li><li>Module assessment</li><li>Summary</li></ul> <h4>Migrate SQL Server workloads to Azure SQL Managed Instance</h4><ul> <li>Introduction</li><li>Evaluate migration scenarios</li><li>Migrate using Azure Arc</li><li>Use Log Replay Service (LRS) to migrate</li><li>Migrate using Managed Instance link</li><li>Move data to SQL Managed Instance</li><li>Exercise - Migrate a SQL Server database to Azure SQL Managed Instance</li><li>Module assessment</li><li>Summary</li></ul> <h4>Perform post-migration tasks on Azure SQL</h4><ul> <li>Introduction</li><li>Migrate SQL logins and groups</li><li>Implement security to protect Azure SQL</li><li>Implement compliance controls for sensitive data</li><li>Monitor database performance</li><li>Configure high availability and disaster recovery</li><li>Automate database tasks for scalability</li><li>Exercise: Configure geo-replication for Azure SQL Database</li><li>Module assessment</li><li>Summary</li></ul>- Experience with SQL Server databases. - Knowledge of SQL Server editions and versions. - Basic knowledge of security concepts like identities and permissions. - Experience using the Azure portal to create resources and set permissions.Design a SQL Server migration strategy - Introduction - Examine data platform modernization - Plan a data migration - Explore the available data migration technologies - Exercise: Compare on-premises Azure costs - Module assessment - Summary Assess SQL Server databases for migration to Azure SQL - Introduction - Review database for compatibility - Explore assessment options for database migration - Assess SQL Server with Azure Arc - Assess a database with Azure Migrate - Exercise: Identify compatibility issues - Module assessment - Summary Deploy IaaS solutions with Azure SQL - Introduction - Explain IaaS options to deploy SQL Server in Azure - Understand hybrid scenarios - Explore performance and security - Explain high availability and disaster recovery options - Exercise: Provision a SQL Server on an Azure Virtual Machine - Module assessment - Summary Deploy PaaS solutions with Azure SQL - Introduction - Explain PaaS options for deploying SQL Server in Azure - Explore single SQL database - Deploy SQL database elastic pool - Understand SQL database hyperscale - Examine SQL managed instance - Exercise: Deploy an Azure SQL Database - Module assessment - Summary Migrate SQL Server workloads to Azure Virtual Machine - Introduction - Review migrations strategies and tools - Understand distributed availability group for migration - Migrate databases using native backup and restore - Compare additional migration methods - Exercise: Migrate SQL Server databases to SQL Server on Azure Virtual Machine - Module assessment - Summary Migrate SQL Server workloads to Azure SQL Database - Introduction - Choose the right Azure SQL Database feature - Use Azure Database Migration Service to migrate to Azure SQL Database - Migrate to Azure SQL Database using BACPAC - Use an online method to migrate to Azure SQL Database - Move data to Azure SQL Database - Exercise - Migrate a SQL Server database to Azure SQL Database - Module assessment - Summary Migrate SQL Server workloads to Azure SQL Managed Instance - Introduction - Evaluate migration scenarios - Migrate using Azure Arc - Use Log Replay Service (LRS) to migrate - Migrate using Managed Instance link - Move data to SQL Managed Instance - Exercise - Migrate a SQL Server database to Azure SQL Managed Instance - Module assessment - Summary Perform post-migration tasks on Azure SQL - Introduction - Migrate SQL logins and groups - Implement security to protect Azure SQL - Implement compliance controls for sensitive data - Monitor database performance - Configure high availability and disaster recovery - Automate database tasks for scalability - Exercise: Configure geo-replication for Azure SQL Database - Module assessment - Summary1 jour490.00690.00690.00690.00645.00675.00675.00940.001200.00420.00690.00950.00