What information does query history provide that supports both troubleshooting and capacity planning?
Select an answer to reveal the explanation.
Short Explanation
Query history gives you the real executed workloads, not the ones you guessed. You can use that record to troubleshoot failures and to size future capacity based on actual behavior.
Full Explanation
The correct answer is the record of executed statements with their outcomes and execution characteristics, showing which workloads run, how often, and how they behave. That execution record shows which statements run, how frequently, and how they behave. That serves troubleshooting, because it reveals the failing statement and its error, and capacity planning, because it reveals the actual workload shape rather than an assumed one.
The permissions held by each user at the time of execution is incorrect because entitlement at a point in time comes from access control records, not from the execution log.
The physical storage tier of each file the query touched is incorrect because storage tier placement is a storage-management concern surfaced elsewhere.
The list of dashboards configured to refresh on a schedule is incorrect because a dashboard refresh schedule is a property of the BI tool.
For the exam, query history is the operational record of executed work, useful for both diagnosis and sizing.