Which four actions should you perform in sequence?

DRAG DROP
You administer a Microsoft SQL Server database. Service accounts for SQL Agent are
configured to use a local user. A Microsoft SQL Server Integration Services (SSIS) job step
has been created within a SQL Server Agent job. The SSIS package accesses a network
share when exporting data from a SQL Server database.
When you execute the SQL Server Agent job, it fails due to a permissions failure on a share
on a remote server. You need to ensure that the SQL Server Agent job can execute the
SSIS package. Which four actions should you perform in sequence? (To answer, move the
appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

DRAG DROP
You administer a Microsoft SQL Server database. Service accounts for SQL Agent are
configured to use a local user. A Microsoft SQL Server Integration Services (SSIS) job step
has been created within a SQL Server Agent job. The SSIS package accesses a network
share when exporting data from a SQL Server database.
When you execute the SQL Server Agent job, it fails due to a permissions failure on a share
on a remote server. You need to ensure that the SQL Server Agent job can execute the
SSIS package. Which four actions should you perform in sequence? (To answer, move the
appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Answer:

Explanation:
References:
http://msdn.microsoft.com/en-us/library/ms175834.aspx
http://msdn.microsoft.com/en-us/library/ms1 89522.aspx
http://msdn.microsoft.com/en-us/library/ms190703.aspx
http://msdn.microsoft.com/en-us/library/ms161950.aspx



Leave a Reply 0

Your email address will not be published. Required fields are marked *