You have 10 Microsoft Azure SQL databases. One of the databases is named DB1. You need to ensure that only a specific IP address can be used to access DB1. The solution must affect only DB1. What…

`sp_set_database_firewall_rule` is a T-SQL stored procedure used to create database-level firewall rules, which would directly affect only DB1, but the question implies a PowerShell cmdlet solution.

`New-AzureSqlDatabaseServerFirewallRule` is the PowerShell cmdlet used to create a server-level firewall rule for an Azure SQL logical server. This rule allows a specific IP address to connect to the server, providing the foundational network access necessary for DB1, which can be combined with other security layers to enforce database-specific access.

Adding an endpoint in the Azure portal is a more generic action and not the specific method for configuring IP-based firewall rules for Azure SQL Database.

`Set-AzureSqlDtatabaseServerFirewallRule` (containing a typo) is used to modify an existing server-level firewall rule, not to create a new one as required.