nerdexam
Microsoft

70-473 · Question #78

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 shou

Sign in or unlock 70-473 to reveal the answer and full explanation for question #78. The question stem and answer options stay visible for context.

Design and implement data security

Question

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 should you use?

Options

  • Athe sp_set_database_firewall_rule statement
  • Bthe New-AzureSqlDatabaseServerFirewallRule cmdlet
  • Cthe Azure portal to add an endpoint
  • Dthe Set-AzureSqlDtatabaseServerFirewallRule cmdlet

Unlock 70-473 to see the answer

You've previewed enough free 70-473 questions. Unlock 70-473 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Azure SQL Database#Firewall rules#IP restriction#Network security
Full 70-473 Practice