AZ-120 · Question #338
You have an Azure subscription that contains a Microsoft Entra Domain Services domain-joined Microsoft SQL Server Always On availability group named SQLGroup1 and a virtual machine named VM1. VM1…
The correct answer is C. SQL Server Authentication. What are providers in Azure Monitor for SAP solutions? Provider type: SQL Server You can configure one or more SQL Server providers to enable data collection from SQL Server on virtual machines. The SQL Server provider connects to SQL Server over the SQL port. It then pulls…
Question
You have an Azure subscription that contains a Microsoft Entra Domain Services domain-joined Microsoft SQL Server Always On availability group named SQLGroup1 and a virtual machine named VM1. VM1 hosts an SAP workload and uses SQLGroup1. You deploy Azure Monitor for SAP solutions. You need to configure the SQL Server provider. Which authentication mode should you use?
Options
- AActive Directory - Integrated
- BWindows Authentication
- CSQL Server Authentication
- DMicrosoft Entra ID - Password
How the community answered
(20 responses)- A5% (1)
- C90% (18)
- D5% (1)
Explanation
What are providers in Azure Monitor for SAP solutions? Provider type: SQL Server You can configure one or more SQL Server providers to enable data collection from SQL Server on virtual machines. The SQL Server provider connects to SQL Server over the SQL port. It then pulls data from the database and pushes it to the Log Analytics workspace in your subscription. Configure SQL Server for SQL authentication and for signing in with the SQL Server username and password. Set the SAP database as the default database for the provider. The SQL Server provider collects data every 60 seconds up to every hour from the SQL Server.
Topics
Community Discussion
No community discussion yet for this question.