PrepAway - Latest Free Exam Questions & Answers

Which three steps should you perform in sequence?

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package that is ready for
deployment to a production server. The package contains sensitive information secured by
using the EncryptSensitiveWithUserKey package protection level.
You are preparing the package for deployment by the production operations team.
You need to ensure that the production operations team can open and execute the package
without re-entering the sensitive information.
Which three steps 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.)

PrepAway - Latest Free Exam Questions & Answers

Answer:

29 Comments on “Which three steps should you perform in sequence?

  1. hamam says:

    wrong again !! whats wrong with this questions !! be aware guys its full of wrong answers !!!

    1-open the package in SQL server data tool
    2-change the design surface of the control flow designer
    3-in the properties window … etc




    0



    0
  2. John Sno says:

    I believe it should be:
    open the package in SQL server data tool
    click the task that contains the sensitive information
    in the properties window change …




    0



    0
    1. Panos says:

      No, you don’t know that there is only one task there and the question says that the sensitive data is encrypted by EncryptSensitiveWithUserKey, so this is what you need to change to EncryptSensitiveWithPassword.
      Agree with hamam




      0



      0
  3. henrov says:

    Hamam is right.
    A lot of these questions have terrible answers.
    But they are great for learning because everytime they differ from what I think, I start doubting myself and I find myself re-examining the subject 😀




    0



    0

Leave a Reply