DP-300 Practice Test

Question 51

You have an Azure subscription. You need to deploy an Azure SQL managed instance that meets the following requirements: • Optimize latency. • Maximize the memory-to-vCore ratio. Which service tier and hardware generation should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 52

You have a Microsoft SQL Server 2017 server. You need to migrate the server to Azure. The solution must meet the following requirements: • Ensure that the latest version of SQL Server is used. • Support the SQL Server Agent service. • Minimize administrative effort. What should you use?

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

Question 53

You have a Microsoft SQL Server 2017 server that hosts five databases. You plan to migrate the databases to Azure. You need to recommend a solution that meets the following requirements: • Automatically scales compute based on the workload demand • Provides per-second billing What should you include in the recommendation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 54

You have an on-premises Microsoft SQL Server 2019 database named SQL1 that uses merge replication. You need to migrate SQL1 to Azure. Which service should you use?

1. Azure SQL Edge
2. Azure SQL Database
3. SQL Server on Azure Virtual Machines
4. Azure SQL Managed Instance

Question 55

You have an on-premises datacenter that contains a 2-TB Microsoft SQL Server 2019 database named DB1. You need to recommend a solution to migrate DB1 to an Azure SQL managed instance. The solution must minimize downtime and administrative effort. What should you include in the recommendation?

1. Log Replay Service (LRS)
2. log shipping
3. transactional replication
4. SQL Data Sync