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:ResourceGroupName: RG1 -ServerName: sqlsvr1 -StartIpAddress: 0.0.0.0 -EndIpAddress: 0.0.0.0 -FirewallRuleName: Rule01 -ResourceGroupName: RG1 -ServerName: sqlsvr1 -StartIpAddress: 72.225.0.0 -EndIpAddress: 72.225.255.255 -FirewallRuleName: Rule02 -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? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. A company manages a solution that uses Azure Functions.
HOTSPOT -A company creates an Azure resource group named RG1. RG1 has an Azure SQL Database logical server named sqlsvr1
-
- Site Admin
- Posts: 346795
- Joined: Mon May 16, 2022 9:31 am
HOTSPOT -A company creates an Azure resource group named RG1. RG1 has an Azure SQL Database logical server named sqlsvr1
Register to view solutions, replies, and use search function. Request answer by replying! For more answers visit our other sites: AnswerAccurate HomeworkAnswerHelp AnswerHappy and QuestionAnswerDump