nerdexam
Microsoft

DP-300 · Question #396

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…

The correct answer is B. No. The proposed solution fails to meet the requirement that DB1 can only be accessed by users in Branch1, likely due to insufficient restriction mechanisms or overly broad access.

Submitted by sofia.br· Mar 6, 2026Implement a secure environment

Question

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. 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?

Options

  • AYes
  • BNo

How the community answered

(36 responses)
  • A
    28% (10)
  • B
    72% (26)

Why each option

The proposed solution fails to meet the requirement that DB1 can only be accessed by users in Branch1, likely due to insufficient restriction mechanisms or overly broad access.

AYes
BNoCorrect

The solution is insufficient because it does not ensure that access to DB1 is exclusively limited to users in Branch1, indicating a failure to properly implement network isolation or restrictive access controls.

Concept tested: Azure SQL Database network access control

Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/firewall-configure

Topics

#Azure SQL Database#firewall rules#on-premises connectivity#network access

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-300 Practice