ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam
Go to Exam

Exam DP-300 topic 14 question 1 discussion

Actual exam question from Microsoft's DP-300
Question #: 1
Topic #: 14
[All DP-300 Questions]

HOTSPOT -
You are planning the migration of the SERVER1 databases. The solution must meet the business requirements.
What should you include in the migration plan? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Premium 4-VCore -
Scenario:
An on-premises named SERVER1 hosts an instance of Microsoft SQL Server 2012 and two 1-TB databases.
Migrate the SERVER1 databases to the Azure SQL Database platform.
Minimize downtime during the migration of the SERVER1 databases.
Premimum 4-vCore is for large or business critical workloads. It supports online migrations, offline migrations, and faster migration speeds.
Incorrect Answers:
The Standard pricing tier suits most small- to medium- business workloads, but it supports offline migration only.
Box 2: A virtual network that has service endpoints
Scenario: The primary datacenter has an ExpressRoute connection that uses both Microsoft peering and private peering.
You need to create a Microsoft Azure Virtual Network for the Azure Database Migration Service by using the Azure Resource Manager deployment model, which provides site-to-site connectivity to your on-premises source servers by using either ExpressRoute or VPN.
Note: During virtual network setup, if you use ExpressRoute with network peering to Microsoft, add the following service endpoints to the subnet in which the service will be provisioned:
Target database endpoint (for example, SQL endpoint, Cosmos DB endpoint, and so on)

Storage endpoint -

Service bus endpoint -
This configuration is necessary because Azure Database Migration Service lacks internet connectivity.
Reference:
https://azure.microsoft.com/pricing/details/database-migration/ https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-azure-sql-online
by devpool at April 10, 2021, 9:05 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
devpool
Highly Voted 4 years, 1 month ago
Premium 4-vCore A VPN gateway
upvoted 18 times
...
aakben
Highly Voted 3 years, 7 months ago
1- A main office in Boston. The main office hosts a sales department 2- The main office hosts a sales department and the primary datacenter for the company. 3- The sales department has the following database workload: An on-premises named SERVER1 hosts an instance of Microsoft SQL Server 2012 and two 1-TB databases. 4- The primary datacenter has an ExpressRoute connection that uses both Microsoft peering and private peering. The private peering connects to an Azure virtual network named HubVNet. https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-azure-sql Link Says : During virtual network setup, if you use ExpressRoute with network peering to Microsoft, add the following service endpoints to the subnet in which the service will be provisioned: Target database endpoint (for example, SQL endpoint, Cosmos DB endpoint, and so on) I think correct answers are : Premium - 4vCore ( Premium supports online migration, but Standard not support) A virtual network that has service endpoint
upvoted 7 times
...
bingomutant
Most Recent 7 months ago
Azure Database Migration Service pricing tier: Standard 4-vCore: This option offers sufficient compute resources to handle the migration of multiple large databases like the ones hosted on SERVER1, without the additional premium cost. Required Azure resource: A virtual network that has service endpoints: For Azure Database Migration Service to connect securely to both the on-premises data sources and Azure databases, the service needs to operate within a virtual network with service endpoints enabled.
upvoted 1 times
...
eric0718
3 years ago
Premium 4-vCore A VPN gateway
upvoted 3 times
...
jimmyzaas
3 years, 8 months ago
The sales department is in the main office/primary datacenter which has an ExpressRoute to Azure. Access to the SERVER1 Azure SQL Database would be by ExpressRoute. Should this not be Virtual Network with service endpoints?
upvoted 6 times
...
jimmyzaas
3 years, 8 months ago
The sales on prem server is with the sales department which is in the main office/datacenter. This location has an express route to Azure. Why do we need a VPN gateway?
upvoted 2 times
...
Eleonora77
3 years, 10 months ago
Answer is correct but selection is wrong
upvoted 7 times
...
gills
3 years, 11 months ago
Explanation in the answer and what is selected as the answer in the visuals are not the same.
upvoted 5 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago