nerdexam
Microsoft

70-466 · Question #83

You need to identify the reports that produce the errors that Marc is receiving. What should you do?

The correct answer is C. Write a query by using the ExecutionLog3 view in the report server database.. Identifying which specific SSRS reports produce errors requires querying the ExecutionLog3 view, which stores structured per-execution records including status and error details for every report run.

Implement a reporting services solution

Question

You need to identify the reports that produce the errors that Marc is receiving. What should you do?

Options

  • AWrite a query by using the Subscriptions table in the report server database.
  • BUse the Windows Event Viewer to search the Application log for errors.
  • CWrite a query by using the ExecutionLog3 view in the report server database.
  • DSearch the ReportServerService_<timestamp>.log file for errors.

How the community answered

(69 responses)
  • A
    4% (3)
  • B
    7% (5)
  • C
    87% (60)
  • D
    1% (1)

Why each option

Identifying which specific SSRS reports produce errors requires querying the ExecutionLog3 view, which stores structured per-execution records including status and error details for every report run.

AWrite a query by using the Subscriptions table in the report server database.

The Subscriptions table stores subscription definitions and delivery configuration metadata, not runtime execution outcomes or error details, so it cannot identify which reports produced errors during execution.

BUse the Windows Event Viewer to search the Application log for errors.

Windows Event Viewer captures system-level and application-level events but does not record individual SSRS report execution results with enough granularity to map errors back to specific report names.

CWrite a query by using the ExecutionLog3 view in the report server database.Correct

The ExecutionLog3 view in the report server database records one row per report execution and includes columns for report name, user, execution status, error messages, and parameters. Filtering this view by user and error status pinpoints exactly which reports are failing for Marc without manual log parsing.

DSearch the ReportServerService_<timestamp>.log file for errors.

The ReportServerService trace log records internal service-level diagnostics and exceptions but is a flat text file - it does not provide a structured, queryable mapping of errors to specific report names and users.

Concept tested: Querying SSRS ExecutionLog3 view to identify report errors

Source: https://learn.microsoft.com/en-us/sql/reporting-services/report-server/report-server-executionlog-and-the-executionlog3-view

Topics

#ExecutionLog3#report server database#SSRS troubleshooting#report errors

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice