What should you include in the recommendation?

You plan to deploy 200 Microsoft SQL Server databases to Azure by using Azure SQL Database and Azure SQL Database Managed Instance.

You need to recommend a monitoring solution that provides a consistent monitoring approach for all deployments.

The solution must meet the following requirements:

– Support current-state analysis based on metrics collected near real-time, multiple times per minute, and maintained for up to one hour

– Support longer term analysis based on metrics collected multiple times per hour and maintained for up to two weeks.

– Support monitoring of the number of concurrent logins and concurrent sessions.

What should you include in the recommendation?
A . dynamic management views
B . trace flags
C . Azure Monitor
D . SQL Server Profiler

View Answer

Answer: C