Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-300

Free Microsoft DP-300 Exam Braindumps (page: 17)

Page 12 of 61
PDF with 406 Questions

HOTSPOT (Drag and Drop is not supported)
You have an Azure subscription.

You plan to migrate 10 on-premises Microsoft SQL Server instances to Azure.

You need to ensure that the migrated environment can be managed by using multiserver administration and supports master/target (MSX/TSX) jobs.

The solution must minimize administrative effort.

Which SQL deployment options should you select as the master server (MSX) and the target server (TSX)? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



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

Answer(s): C



HOTSPOT (Drag and Drop is not supported)
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.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



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.

Answer(s): B



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

Answer(s): A



Viewing page 17 of 61
Viewing questions 81 - 85 out of 406 questions



Post your Comments and Discuss Microsoft DP-300 exam prep with other Community members:

DP-300 Exam Discussions & Posts