DP-300 Practice Test

DP-300 Practice Test practice questions, page 10 of 15, with answer review and explanations.

Question 46

You have two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2. You need to migrate the databases hosted on SQL1 to Azure. The solution must meet the following requirements: • The service that hosts the migrated databases must be able to communicate with SQL2 by using linked server connections. • Administrative effort must be minimized. What should you use to host the databases?

  1. a single Azure SQL database
  2. SQL Server on Azure Virtual Machines
  3. Azure SQL Managed Instance
  4. an Azure SQL Database elastic pool

Question 47

You have an on-premises Microsoft SQL Server 2016 instance that hosts a database named db1. You have an Azure subscription that contains an Azure SQL managed instance named MI1. You plan to perform an online migration of db1 to MI1 by using Azure Database Migration Service. You need to create the backups for the migration. The solution must minimize the number of backup files created. Which type of backups should you create, and how should you store the backups? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 48

You have a SQL Server on Azure Virtual Machines instance named SQLVM1 that was deployed by using an Azure Marketplace SQL Server 2019 Enterprise image. You need to change the Microsoft SQL Server instance on SQLVM1 to the Standard edition. The solution must ensure licensing compliance. What should you do first?

  1. From the SQL Server Installation Center on SQLVM1, run the Edition Upgrade wizard.
  2. From SQLVM1, uninstall the SQL Server instance.
  3. From the SQL Server Installation Center on SQLVM1, run the Repair wizard.
  4. From the Azure portal, reconfigure SQLVM1.

Question 49

Your on-premises network contains a Microsoft SQL Server 2016 server that hosts a database named db1. You have an Azure subscription. You plan to migrate db1 to an Azure SQL managed instance. You need to create the SQL managed instance. The solution must minimize the disk latency of the instance. Which service tier should you use?

  1. Business Critical
  2. Hyperscale
  3. General Purpose
  4. Premium

Question 50

You have an Azure subscription. You need to deploy an Azure SQL database. The solution must meet the following requirements: • Dynamically scale CPU resources. • Ensure that the database can be paused to reduce costs. What should you use?

  1. the Business Critical service tier
  2. the serverless compute tier
  3. an elastic pool
  4. the General Purpose service tier