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?

Aa database-level firewall

Brole-based access control (RSAC)

CDynamic Host Configuration Protocol (DHCP)

DDomain Name Service (DNS)

Show Suggested 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:

Submit Cancel

Arlette

4 months ago

Wait, are you sure it's not a DNS issue? That seems odd.

upvoted 0 times

...

Johnetta

4 months ago

Definitely a firewall problem, happened to me before!

upvoted 0 times

...

Kenny

4 months ago

I thought DHCP was supposed to handle that?

upvoted 0 times

...

Paola

5 months ago

Yeah, I agree, the IP change could block access.

upvoted 0 times

...

Alica

5 months ago

Probably a database-level firewall issue.

upvoted 0 times

...

Darrin

5 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

5 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

5 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

5 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

5 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

5 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

5 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

...