Basic Concept: This question tests Azure monitoring and performance management, including which metric, log destination, or alerting behavior fits the operational requirement.
Why C is Correct: 8 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. This fits the case because the requested outcome is: You need to reduce tempdb contention without regatively affecting server performance. The selected feature addresses that outcome directly rather than relying on a workaround.
Why A is Wrong: 2 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 B is Wrong: 4 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.
Why D is Wrong: 64 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.