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
Hi!
I found the AZ-301 exam questions on this site are too old, many new questions are NOT available.
And, I got part of the newest AZ-301 exam questions here:
https://drive.google.com/open?id=1ah1U5ZfTQkd7hMRDhnN0gFL7q8qMqtUl
(UPDATED IN YEAR 2020 – SOME NEW QUESTIONS ARE AVAILABLE)
If somebody has more helpful AZ-301 study materials, please kindly sharing.
Thanks all in advance!!!
Correct answer A. Dynamic management views (aka. DMV)