Microsoft
70-460 · Question #87
You have two servers named Server1 and Server2. Both servers have SQL Server 2012 installed. Both servers have a SQL Server Integration Services (SSIS) catalog. You are preparing a disaster recovery…
The correct answer is C. Back up the master key of the SSISDB database. E. Back up the SSISDB database. See the full explanation below for the reasoning.
Question
You have two servers named Server1 and Server2. Both servers have SQL Server 2012 installed. Both servers have a SQL Server Integration Services (SSIS) catalog. You are preparing a disaster recovery plan for a business intelligence (BI) solution. You need to ensure that the SSIS catalog from Server1 can be restored to Server2. Which two actions should you perform on Server1? Each correct answer presents part of the solution.
Options
- ABack up the master database.
- BRun sp.configure 'clr enabled', 0.
- CBack up the master key of the SSISDB database.
- DBack up the master key of the master database.
- EBack up the SSISDB database.
- FRun sp_configure 'clr enabled', 1.
How the community answered
(34 responses)- B3% (1)
- C79% (27)
- D12% (4)
- F6% (2)
Community Discussion
No community discussion yet for this question.