DRAG DROP
You are the administrator of a SQL Server Integration Services (SSIS) catalog. You have
access to the original password that was used to create the SSIS catalog.
A full database backup of the SSISDB database on the production server is made each day.
The server used for disaster recovery has an operational SSIS catalog.
Information that is encrypted in the SSISDB database must not be lost.
You need to document the disaster recovery solution that restores the production SSIS
catalog to the disaster recovery server.
Which three steps should you document in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.
Answer: See the explanation.
Explanation:
Box 1: Restore the SSISDB database from the last backup.
Box 2: Restore the SSISDB master key.
Box 3: Open the SSISDB database master keyNote:
To Restore the SSIS Database
1. Restore the SSISDB database from the backup by using the Restore Database
dialog box in SQL Server Management Studio.
2. Restore the master key (Use this method if you have the original password that was
used to create SSISDB), open master key decryption by password = ‘LS1Setup!’ —
‘Password used when creating SSISDB’Alter Master Key Add encryption by Service Master
Key
Sure that is right? You wouldn’t restore the SSISDB master key because it was specified that we do have the PW.
I wish MS would just release official practice exams for 466 ad 467. I did so well on the first 5 exams thanks to that. Not sure why MS can’t make practice exams for these 2.
0
0
https://msdn.microsoft.com/en-us/library/hh213291.aspx
0
0