PrepAway - Latest Free Exam Questions & Answers

Which of the following is the stored procedure being discussed?

You work as a database developer at ABC.com. The ABC.com network consists of a single
domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.

You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing the use of a stored procedure that creates an environment reference for a project in the
SSIS catalog.
Which of the following is the stored procedure being discussed?

PrepAway - Latest Free Exam Questions & Answers

A.
The catalog.create_execution stored procedure.

B.
The catalog.create_environment_variable stored procedure.

C.
The catalog.create_environment_reference stored procedure.

D.
The catalog.add_data_tap stored procedure.

Explanation:


Leave a Reply