Azure SQL firewall rules - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of Azure SQL firewall rules?

Azure SQL firewall rules control which IP addresses can connect to your Azure SQL Database, helping to protect it from unauthorized access.

beginner

How do you allow a specific IP address to access an Azure SQL Database?

You create a firewall rule that specifies the start and end IP address as the same IP, allowing that single IP to connect.

intermediate

What is the difference between server-level and database-level firewall rules in Azure SQL?

Server-level rules apply to all databases on the server, while database-level rules apply only to a specific database.

intermediate

Can Azure services access Azure SQL Database without adding their IP to the firewall rules?

Yes, if you enable the option 'Allow Azure services and resources to access this server', Azure services can connect without specific IP rules.

beginner

What happens if no firewall rules are configured on an Azure SQL server?

No external IP addresses can connect to the Azure SQL Database, effectively blocking all access except from within Azure if allowed.

What does an Azure SQL firewall rule control?

A The database schema

B The size of the database

C The backup schedule

D Which IP addresses can connect to the database

Firewall rules control network access by IP address to protect the database.

How do you allow all Azure services to access your Azure SQL server?

A Enable 'Allow Azure services and resources to access this server' option

B Add 0.0.0.0 as a firewall rule

C Create a database-level firewall rule

D Use a VPN connection

This option allows trusted Azure services to bypass IP restrictions.

What is the range of IP addresses you can specify in a firewall rule?

A Start IP and End IP defining a range

B Only a single IP address

C Only private IP addresses

D Only public IP addresses from your local network

You specify a start and end IP to allow a range of addresses.

Where do server-level firewall rules apply?

A Only to the master database

B Only to one database

C To all databases on the server

D Only to Azure services

Server-level rules cover all databases hosted on that server.

If you want to block all external access to your Azure SQL Database, what should you do?

A Add a firewall rule with IP 0.0.0.0

B Do not configure any firewall rules

C Enable Azure services access

D Create a database-level firewall rule

Without firewall rules, no external IPs can connect.

Explain how Azure SQL firewall rules protect your database and how you configure them.

Think about who can connect and how you specify allowed IPs.

Describe the difference between server-level and database-level firewall rules in Azure SQL.

Consider which databases are affected by each rule type.