Microsoft Azure Data Fundamentals — Question 91

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?

Answer options

• A. role-based access control (RBAC)
• B. Dynamic Host Configuration Protocol (DHCP)
• C. Domain Name Service (DNS)
• D. a database-level firewall

Correct answer: D

Explanation

The likely cause of the issue is the database-level firewall, which restricts access to the Azure SQL database based on predefined IP addresses. When the IP address of your computer changed, it may have fallen outside the allowed range in the firewall settings, thus blocking access. The other options (RBAC, DHCP, DNS) do not directly relate to the connectivity issue in this scenario.