70-463 Question #212: Real Exam Question with Answer & Explanation

Question

Options

• AUse an event handler for OnError for the package.
• BUse an event handler for OnError for each data flow task.
• CUse an event handler for OnTaskFailed for the package.
• DView the job history for the SQL Server Agent job.
• EView the All Messages subsection of the All Executions report for the package.
• FStore the System::SourceID variable in the custom log table.
• GStore the System::ServerExecutionID variable in the custom log table.
• HStore the System::ExecutionInstanceGUID variable in the custom log table.
• IEnable the SSIS log provider for SQL Server for OnError in the package control flow.
• JEnable the SSIS log provider for SQL Server for OnTaskFailed in the package control flow,

Explanation

In the Project Deployment Model, every package execution is assigned a unique System::ServerExecutionID by the SSIS Catalog. When packages write custom log messages to their own log table, storing this ServerExecutionID alongside each custom entry creates a foreign key link to the catalog's built-in execution log tables (e.g., catalog.operation_messages). This allows reports to JOIN both tables on ServerExecutionID, producing a unified view of custom and system-generated messages. System::SourceID (F) identifies the object that raised an event and is not suitable as a cross-table correlation key. System::ExecutionInstanceGUID (H) is a GUID generated per-execution but is used in the Package Deployment Model, not the Project Deployment Model's catalog, making it unsuitable for catalog-side JOINs.

No community discussion yet for this question.