Microsoft
70-463 · Question #211
70-463 Question #211: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #211. The question stem and answer options stay visible for context.
Question
You are developing a SQL Server Integration Services (SSIS) project with multiple packages to copy data to a Windows Azure SQL Database database. An automated process must validate all related Environment references, parameter data types, package references, and referenced assemblies. The automated process must run on a regular schedule. You need to establish the automated validation process by using the least amount of administrative effort. What should you do?
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.
Unlock 70-463 to see the answer
You've previewed enough free 70-463 questions. Unlock 70-463 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.