Câu 49: 70-463: MCSA Implementing a Data Warehouse with Microsoft SQL Server 20122014
You have a secured database that contains all of the customer data for your company. You plan to use a project deployment model. You need to create a SQL Server Integration Services (SSIS) package that connects to the data base by using a dedicated username and password. The solution must ensure that the password used…
Nội dung câu hỏi
You have a secured database that contains all of the customer data for your company. You plan to use a project deployment model. You need to create a SQL Server Integration Services (SSIS) package that connects to the data base by using a dedicated username and password. The solution must ensure that the password used for the connection string is encrypted. Which two actions should you perform? Each correct answer presents part of the solution.
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.
- A. Modify the set_execution_parameter_value stored procedure.
- B. Set the package protection level to EncryptSensitiveWithPassword. — đáp án hiện tại
- C. Select the Sensitive check box for the catalog environment.
- D. Set the sensitive property of the package parameter to True. — đáp án hiện tại
- E. Set the package protection level to EncryptSensitiveWithUserKey.
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.