exam questions

Exam 70-463 All Questions

View all questions & answers for the 70-463 exam

Exam 70-463 topic 2 question 25 discussion

Actual exam question from Microsoft's 70-463
Question #: 25
Topic #: 2
[All 70-463 Questions]

DRAG DROP -
You administer a Microsoft SQL Server database. Service accounts for SQL Agents 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.)
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
References: http://msdn.microsoft.com/en-us/library/ms175834.aspx http://msdn.microsoft.com/en-us/library/ms189522.aspx http://msdn.microsoft.com/en-us/library/ms190703.aspx http://msdn.microsoft.com/en-us/library/ms161950.aspx

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
cornford
4 years, 10 months ago
Each proxy corresponds to a security credential. So you have to select the credential when creating a proxy. https://social.technet.microsoft.com/wiki/contents/articles/36797.sql-credentials-and-proxy-for-agent-job.aspx
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...