Exam 70-463 topic 2 question 54 discussion

Actual exam question from Microsoft's 70-463

Question #: 54
Topic #: 2

Note: This question is a part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series.
Information and details provided in a question apply only to that question.
You are developing a SQL Server Integration Services (SSIS) project with multiple packages to copy data to a Microsoft Azure SQL 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?

A. Use an event handler for OnError for the package.
B. Use an event handler for OnError for each data flow task.
C. Use an event handler for OnTaskFailed for the package.
D. View the job history for the SQLServer Agent job.
E. View the All Messages subsection of the All Executions report for the package.
F. Store the System::SourceID variable in the custom log table.
G. Store the System::ServerExecutionID variable in the custom log table.
H. Store the System::ExecutionInstanceGUID variable in the custom log table.
I. Enable the SSIS log provider for SQL Server for OnError in the package control flow.
J. Enable the SSIS log provider for SQL Server for OnTaskFailed in the package control flow. K. Deploy the project by using dtutil.exe with the /COPY DTS option. L. Deploy the project by using dtutil.exe with the /COPY SQL option. M. Deploy the .ispac file by using the Integration Services Deployment Wizard. N. Create a SQL Server Agent job to execute the SSISDB.catalog.validate_project stored procedure. O. Create a SQL Server Agent job to execute the SSISDB.catalog.validate_package stored procedure. P. Create a SQL Server Agent job to execute theSSISDB.catalog.create_execution and SSISDB.catalog.start_executionstored procedures. Q. Create a table to store error information. Create an error output on each data flow destination that writes OnError event text to the table. R. Create a table to store error information. Create an error output on each data flow destination that writes OnTaskFailed event text to the table.

Show Suggested Answer

Suggested Answer: N 🗳️

by Eras at Jan. 7, 2021, 3:18 p.m.

Comments

Submit Cancel

Eras

4 years, 5 months ago

N. Create a SQL Server Agent job to execute the SSISDB.catalog.validate_project stored procedure

upvoted 1 times

...