Which Transact-SQL command or Azure PowerShell cmdlet should you use next?

Relecloud recently implemented the planned changes. you plan to add a new customer named Fabrikam, Inc. You need to ensure that the administrators at Fabrikam can access their data after the data

loading process. You collect the IP addresses used by the Fabrikam administrators.

Which Transact-SQL command or Azure PowerShell cmdlet should you use next?
A . sp_set_firewall_rule
B . Set-AzureRmSqlServerFirewallRule
C . sp_set_database_firewall_rule
D . new-AzureRmSqlServerFirewallRule

View Answer

Answer: D

Explanation:

The New-AzureRmSqlServerFirewallRule cmdlet creates a firewall rule for the specified Azure SQL Database server.

Database-level firewall rules enable clients to access certain (secure) databases within the same logical server. You can create these rules for each database (including the master database) and they are stored in the individual databases.

Reference:

https://docs.microsoft.com/en-us/powershell/module/azurerm.sql/new­azurermsqlserverfirewallrule?view=azurermps-6.7.0 https://docs.microsoft.com/en-us/azure/sql-database/sql-database-firewall-configure