Câu 54: 70-463: MCSA Implementing a Data Warehouse with Microsoft SQL Server 20122014

DRAG DROP -You have a SQL Server Integration Services (SSIS) package that runs on a server named SQL1 and connects to a SQL Server database on a server namedSQL2. You schedule the package to run via a SQL Server Agent job. The package fails and generates the following error message: "Unknown server or Access is Denied".You discover that the package is configured to authenticate by using Windows authentication and that the SQL Server Agent on SQL1 uses NT Service\SQLSERVERAGENT as a service account. You verify that other jobs run on the server without errors. You create a user account named CONTOSO\JobProcess1 and provide all of the required access to the tables on SQL2. You need to ensure that the package runs successfully via the SQL Server Agent job. Which three 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:

1. A. Lựa chọn A bằng hình ảnh — đáp án hiện tại