HOTSPOT (Drag and Drop is not supported)You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1.You plan to perform an online migration of DB1 to an Azure SQL managed instance by using the Azure Database Migration Service.You need to create a backup of DB1 that is accessible to the Azure Database Migration Service.What should you run for the backup and where should you store the backup? To answer, select the appropriate options in the answer area.Note: Each correct selection is worth one point.Hot Area:
Answer(s): A
Box 1: ..with CHECKSUM optionAzure Database Migration Service does not initiate any backups, and instead uses existing backups, which you may already have as part of your disaster recovery plan, for the migration. Be sure that you take backups using the WITH CHECKSUM option.Box 2: An SMB shareFor online migrations from SQL Server to SQL Managed Instance using Azure Database Migration Service, you must provide the full database backup and subsequent log backups in the SMB network share that the service can use to migrate your databases.
https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online
HOTSPOT (Drag and Drop is not supported)You have an Azure subscription.You plan to deploy an Azure SQL database by using an Azure Resource Manager template.How should you complete the template? To answer, select the appropriate options in the answer area.Note: Each correct selection is worth one point.Hot Area:
Box 1: "Microsoft.Sql/servers"Example:"resources": [{"type": "Microsoft.Sql/servers","apiVersion": "2021-08-01-preview","name": "[parameters('serverName')]","location": "[parameters('location')]","properties": {"administratorLogin": "[parameters('administratorLogin')]", "administratorLoginPassword": "[parameters('administratorLoginPassword')]" }},{"type": "Microsoft.Sql/servers/databases","apiVersion": "2021-08-01-preview","name": "[format('{0}/{1}', parameters('serverName'), parameters('sqlDBName'))]", "location": "[parameters('location')]","sku": {"name": "Standard","tier": "Standard"},"dependsOn": ["[resourceId('Microsoft.Sql/servers', parameters('serverName'))]" ]}Box 2: "dependsOn": [
https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-arm-template-quickstart
You have an on-premises Microsoft SQL Server 2019 server that hosts a database named DB1.You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1 and a virtual network named VNET1. SQLMI1 resides on VNET1. The on-premises network connects to VNET1 by using an ExpressRoute connection.You plan to migrate DB1 to SQLMI1 by using Azure Database Migration Service.You need to configure VNET1 to support the migration.What should you do?
Answer(s): D
You have an on-premises Microsoft SQL server that uses the FileTables and Filestream features.You plan to migrate to Azure SQL.Which service should you use?
Answer(s): B
SQL Server VM alternative.Your business might have requirements that make SQL Server on Azure Virtual Machines a more suitable target than Azure SQL Database.If one of the following conditions applies to your business, consider moving to a SQL Server virtual machine (VM) instead:* You have strict dependency on features that are still not supported, such as FileStream/FileTable, PolyBase, and cross-instance transactions.* Etc.
https://docs.microsoft.com/en-us/azure/azure-sql/migration-guides/database/sql-server-to-sql-database- overview
You need to migrate an on-premises Microsoft SQL Server database to an Azure SQL Database. The solution must minimize downtime.What should you do?
Answer(s): C
Use Transactional Replication.When you can't afford to remove your SQL Server database from production while the migration is occurring, you can use SQL Server transactional replication as your migration solution.Note: There are two primary methods for migrating a SQL Server 2005 or later database to Azure SQL Database. The first method (database copy or BACPAC importation) is simpler but requires some, possibly substantial, downtime during the migration. The second method (transactional replication) is more complex, but substantially eliminates downtime during the migration.Incorrect:Not D: The import BACPAC method includes downtime during migration.
https://docs.microsoft.com/en-us/azure/azure-sql/database/migrate-to-database-from-sql-server#method-1- migration-with-downtime-during-the-migration
Post your Comments and Discuss Microsoft DP-300 exam prep with other Community members: