DP-300 Practice Questions & Answers • ExamPrepare

Question 1

You have an on-premises server named Server1 that has Microsoft SQL Server 2022 installed.

You have an Azure subscription that contains an Azure SQL managed instance named MI1. MI1 contains a database named DB2.

You need to create a copy of DB2 on Server1.

Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Actions

Answer Area

Question 2

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have the on-premises networks shown in the following table.

Name	Location	Subnet
Branch1	Sydney	131.107.10.0/24
Branch2	Melbourne	131.107.11.0/24

You have an Azure subscription that contains an Azure SQL Database server named SQL1. SQL1 contains two databases named DB1 and DB2.

You need to configure access to DB1 and DB2. The solution must meet the following requirements:

Ensure that DB1 can be accessed only by users in Branch1.
Ensure that DB2 can be accessed only by users in Branch2.

Solution: You connect to DB1 and run the following command.

EXECUTE sp_set_firewall_rule 'Deny db1 users', '131.107.11.0', '131.107.11.255'

You connect to DB2 and run the following command.

EXECUTE sp_set_database_firewall_rule 'Deny db2 users', '131.107.10.0', '131.107.10.255'

Does this meet the goal?

Yes
No

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.

Question 3

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have the on-premises networks shown in the following table.

Name	Location	Subnet
Branch1	Sydney	131.107.10.0/24
Branch2	Melbourne	131.107.11.0/24

You have an Azure subscription that contains an Azure SQL Database server named SQL1. SQL1 contains two databases named DB1 and DB2.

You need to configure access to DB1 and DB2. The solution must meet the following requirements:

Ensure that DB1 can be accessed only by users in Branch1.
Ensure that DB2 can be accessed only by users in Branch2.

Solution: You connect to the master of SQL1 and run the following command.

EXECUTE sp_set_firewall_rule 'Allow db1 and db2 users', '131.107.11.0', '131.107.11.255'

Does this meet the goal?

Yes
No

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.

Question 4

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have the on-premises networks shown in the following table.

Name	Location	Subnet
Branch1	Sydney	131.107.10.0/24
Branch2	Melbourne	131.107.11.0/24

You have an Azure subscription that contains an Azure SQL Database server named SQL1. SQL1 contains two databases named DB1 and DB2.

You need to configure access to DB1 and DB2. The solution must meet the following requirements:

Ensure that DB1 can be accessed only by users in Branch1.
Ensure that DB2 can be accessed only by users in Branch2.

Solution: You connect to the master of SQL1 and run the following command.

EXECUTE sp_set_firewall_rule 'Allow db1 and db2 users', '131.107.10.0', '131.107.10.255'

Does this meet the goal?

Yes
No

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.

Question 5

You have an Azure subscription.

You need to deploy two virtual machines named VM1 and VM2 that will host Microsoft SQL Server instances. The solution must meet the following requirements:

VM1 must provide the highest I/O throughput-to-vCore ratio.
VM2 must provide the highest memory-to-vCore ratio.

Which series should you select for each virtual machine? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Question 6

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.