70-467 Question #74: Real Exam Question with Answer & Explanation

Question

Options

• ACreate a log table and use SSIS event handlers to write to the log table.
• Buse the SSIS log provider for SQL Server.
• CCreate a log table and build a custom log provider to write to the log table.
• DCreate an SSRS report that uses the catalog.executions and

Explanation

The SSISDB catalog views such as catalog.executions provide built-in execution history, making an SSRS report against them the most direct way to produce a Package Activity report.

Common mistakes.

• A. Writing to a custom log table via SSIS event handlers requires adding event handler tasks to every package and maintaining a custom schema, adding unnecessary complexity when catalog views already exist.
• B. The SSIS log provider for SQL Server writes to the sysssislog table in msdb, which has a fixed schema not designed for flexible package activity reporting.
• C. Building a custom log provider requires .NET development effort and ongoing maintenance, far exceeding what is needed when the SSISDB catalog already tracks execution data.

Concept tested. SSISDB catalog views for package execution reporting

Reference. https://learn.microsoft.com/en-us/sql/integration-services/system-views/catalog-executions-ssisdb-database

No community discussion yet for this question.