nerdexam
Microsoft

DP-300 · Question #382

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 provided question is incomplete, as it lacks a specific proposed solution to evaluate against the stated requirements for Azure SQL Database access control.

Submitted by haruto_sh· Mar 6, 2026Plan and implement data platform resources

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 DB1 and run the following command. EXECUTE sp_set_firewall_rule 'Allow db1 users', '131.107.10.0', '131.107.10.255' You connect to DB2 and run the following command. EXECUTE sp_set_database_firewall_rule 'Allow db2 users', '131.107.11.0', '131.107.11.255' Does this meet the goal?

Options

  • AYes
  • BNo

How the community answered

(32 responses)
  • A
    6% (2)
  • B
    94% (30)

Why each option

The provided question is incomplete, as it lacks a specific proposed solution to evaluate against the stated requirements for Azure SQL Database access control.

AYes

Choosing 'Yes' would be incorrect because no proposed solution is provided within the question stem to assess whether it successfully implements the specified access controls for the Azure SQL databases.

BNoCorrect

The answer 'No' is correct because without a specific solution detailed in the question, it's impossible to verify if any configuration would effectively meet the requirement that DB1 be accessed only by users in Branch1, or the second, truncated requirement.

Concept tested: Incomplete question analysis

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-300 Practice