Microsoft
DP-300 · Question #384
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. This command attempts to deny access from the opposite branch subnets, but it does not explicitly allow the correct subnets access to the respective databases. Moreover, denying a range is not a typical configuration for SQL Database firewall rules, which are generally based on…
Submitted by tarun92· 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 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?
Options
- AYes
- BNo
How the community answered
(33 responses)- A27% (9)
- B73% (24)
Explanation
This command attempts to deny access from the opposite branch subnets, but it does not explicitly allow the correct subnets access to the respective databases. Moreover, denying a range is not a typical configuration for SQL Database firewall rules, which are generally based on allowing specific IP ranges.
Topics
#Azure SQL Database#firewall rules#on-premises connectivity#network access
Community Discussion
No community discussion yet for this question.