CertyRush
Đang tải...
C CertyRush
Câu hỏi free preview

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

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. Y…

Nội dung câu hỏi

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) package. To process complex scientific data originating from a Microsoft Azure SQL Database database, a custom task component is added to the project. You need to ensure that the custom component is deployed on a test environment correctly. What should you do?

Các lựa chọn

Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.

  1. A. Add an OnError event handler to the SSIS project.
  2. B. Use an msi file to deploy the package on the server.
  3. C. Open a command prompt and run the gacutil command. — đáp án hiện tại
  4. D. Open a command prompt and run the dtutil /copy command.
  5. E. Open a command prompt and run the dtexec /rep /conn command.
  6. F. Open a command prompt and run the dtexec /dumperror /conn command.
  7. G. Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility.
  8. H. Create a reusable custom logging component and use it in the SSIS project.
  9. I. Configure the SSIS solution to use the Project Deployment Model.
  10. J. Configure the output of a component in the package data flow to use a data tap. K. Run thedtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server.

Cộng đồng

0 bình luận công khai. Tên thành viên được ẩn một phần.

Chưa có bình luận. Mở giao diện tương tác để bắt đầu thảo luận.

Câu hỏi liền kề