Exam: DP-900: Microsoft Azure Data Fundamentals 0 Likes
You recently changed the public IP address of your computer (DP-900)
You have an Azure SQL database that you access directly from the Internet.
You recently changed the public IP address of your computer.
After changing the IP address, you can no longer access the database. You can connect to other resources in Azure.
What is a possible cause of the issue?
A) role-based access control (RBAC).
B) Dynamic Host Configuration Protocol (DHCP).
C) Domain Name Service (DNS).
D) a database-level firewall.
Solution
Correct answer: D) a database-level firewall.
The issue you're facing after changing your computer's public IP address and losing access to the Azure SQL database is likely due to a database-level firewall restriction.
Azure SQL databases often have firewall rules set up to control access based on IP addresses. When you changed your computer's public IP address, the new IP might not be included in the allowed IP addresses specified in the database-level firewall settings. As a result, the database is denying access from your updated IP.
Category: Considerations for working with non-relational data on Azure