Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-900 Exam - Topic 9 Question 11 Discussion

You have an Azure SQL database that you access directly from the internet.You recently changed your external IP address.After changing the IP address, you can no longer access the database. You can connect to other resources in AzureWhat is a possible cause of the issue?
A) a database-level firewall
B) role-based access control (RSAC)
C) Dynamic Host Configuration Protocol (DHCP)
D) Domain Name Service (DNS)

Microsoft DP-900 Exam - Topic 9 Question 11 Discussion

Actual exam question for Microsoft's DP-900 exam
Question #: 11
Topic #: 9
[All DP-900 Questions]

You have an Azure SQL database that you access directly from the internet.

You recently changed your external IP address.

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?

Show Suggested Answer Hide Answer
Suggested Answer: A

The Azure SQL Database firewall lets you decide which IP addresses may or may not have access to either your Azure SQL Server or your Azure SQL database.

When creating an Azure SQL Database, the firewall needs to be configured before anyone will be able to access the database. By default, no external access to your SQL Database will be allowed until you explicitly assign permission by creating a firewall rule.


https://www.sqlshack.com/configuring-the-azure-sql-database-firewall/

by Antione at May 04, 2022, 10:16 PM

Limited Time Offer

25%

Off

Get Premium DP-900 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Arlette
10 months ago
Wait, are you sure it's not a DNS issue? That seems odd.
upvoted 0 times
...
Johnetta
10 months ago
Definitely a firewall problem, happened to me before!
upvoted 0 times
...
Kenny
11 months ago
I thought DHCP was supposed to handle that?
upvoted 0 times
...
Paola
11 months ago
Yeah, I agree, the IP change could block access.
upvoted 0 times
...
Alica
11 months ago
Probably a database-level firewall issue.
upvoted 0 times
...
Darrin
11 months ago
I’ve seen questions about DNS before, but I don’t think that would affect direct IP access to the database.
upvoted 0 times
...
Lynelle
11 months ago
DHCP seems unrelated since it deals with assigning IPs, not blocking them. I feel like it’s probably the firewall.
upvoted 0 times
...
Avery
11 months ago
I’m not entirely sure, but I think role-based access control is more about permissions than IP access.
upvoted 0 times
...
Izetta
11 months ago
I remember something about database-level firewalls blocking access based on IP addresses. Could that be the issue here?
upvoted 0 times
...
Cora
11 months ago
Hmm, I'm a bit unsure about this one. I know Azure AD Connect is used for directory integration, but I'm not sure if the cloud sync option (A) or the staging mode (C) might be more appropriate in this case. I'll need to review the details of each approach.
upvoted 0 times
...
Carolynn
11 months ago
I'm feeling pretty confident about this one. The key is understanding how different storage engines handle transactions and rollbacks. I think I've got a good handle on that, so I'll give it my best shot.
upvoted 0 times
...
Yuette
11 months ago
I thought Tl-LFA specifically related to instances, which would make option D more likely, but I could be mixing that up with something else.
upvoted 0 times
...

Save Cancel