What should you do?

Topic 2, Misc. Questions Set

HOTSPOT

A company creates an Azure resource group named RG1.

RG1 has an Azure SQL Database logical server named sqlsvr1 that hosts the following resources:

An administrator grants a user named User1 the Reader RBAC role in RG1. The administrator grants User2 the Contributor role in sqlsvr1.

User1 reports that they can connect to SQLDB1 from the IP address 155.127.95.212. User1 cannot connect to SQLDB2. User2 can connect to both SQLDB1 and SQLDB2 from the IP address 121.19.27.18. Both users can successfully connect to SQLDB1 and SQLDB2 from VM1.

You are helping the administrator troubleshoot the issue. You run the following PowerShell command:

Get-AzSqlServerFirewallRule -ResourceGroupName ‘RG1’ -ServerName ‘sqlsvr1’

The following output displays:

You need to identify the cause for the reported issue and resolve User1’s issues. The solution must satisfy the principle of least privilege.

What should you do?

View Answer

Answer:

Explanation:

Text

Description automatically generated