Scenario: Real-time processing must be monitored to ensure that workloads are sized properly based on actual usage patterns.
To monitor the performance of a database in Azure SQL Database and Azure SQL Managed Instance, start by monitoring the CPU and IO resources used by your workload relative to the level of database performance you chose in selecting a particular service tier and performance level.
[Reference:, https://docs.microsoft.com/en-us/azure/azure-sql/database/monitor-tune-overview, , , , , , Basic Concept: This question tests Azure monitoring and performance management, including which metric, log destination, or alerting behavior fits the operational requirement., Why A is Correct: SU% Utilization is the Stream Analytics metric used to determine whether the job has enough streaming units for its workload. This fits the case because the requested outcome is: Which counter should you monitor for real-time processing to meet the technical requirements? The selected feature addresses that outcome directly rather than relying on a workaround., Why B is Wrong: CPU percentage is important for database compute monitoring, but it is not the Stream Analytics sizing metric when the question is about streaming units. It would produce a different operational signal than the one needed to investigate, alert, or tune the workload in this question., Why C is Wrong: Concurrent users is related to operational monitoring or tuning, but it must match the exact signal needed: query history, resource utilization, wait/blocking detail, or automatic remediation. It does not expose the required metric, query history, wait/blocking signal, or tuning mechanism; using it would not give the administrator the evidence requested., Why D is Wrong: Data Conversion Errors is related to operational monitoring or tuning, but it must match the exact signal needed: query history, resource utilization, wait/blocking detail, or automatic remediation. It is useful in other troubleshooting paths, but this scenario requires a more specific monitoring or optimization feature., Verification Note: The original listed answer was B; the corrected answer is A because For Azure Stream Analytics workload sizing, SU% Utilization is the service metric used to evaluate whether streaming units are appropriately sized., ]