Microsoft
70-460 · Question #87
70-460 Question #87: Real Exam Question with Answer & Explanation
Sign in or unlock 70-460 to reveal the answer and full explanation for question #87. The question stem and answer options stay visible for context.
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.
Unlock 70-460 to see the answer
You've previewed enough free 70-460 questions. Unlock 70-460 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.