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
Answer: C