PrepAway - Latest Free Exam Questions & Answers

Which of the following actions should you take?

You work as a database administrator at ABC.com. You are assigned to manage a server named
ABC-DB01. Your duties include managing a SQL Server 2008 Integration Services (SSIS)
instance.
The SQL instance was tested in a local development environment. You receive an instruction from
the CIO to deploy the instance to ABC-DB01. The CIO informs you that the level of security must
be configured for users when they run the package.
Which of the following actions should you take?

PrepAway - Latest Free Exam Questions & Answers

A.
The EncryptPartWithUserKey option should be used.

B.
The EncryptAllWithUserKey option should be used.

C.
The connection string should be used.

D.
The ServerStorage option should be used.


Leave a Reply