ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-467 All Questions

View all questions & answers for the 70-467 exam
Go to Exam

Exam 70-467 topic 1 question 87 discussion

Actual exam question from Microsoft's 70-467
Question #: 87
Topic #: 1
[All 70-467 Questions]

You have two servers named Served 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.

  • A. Back up the master database.
  • B. Run sp.configure 'clr enabled', 0.
  • C. Back up the master key of the SSISDB database.
  • D. Back up the master key of the master database.
  • E. Back up the SSISDB database.
  • F. Run sp_configure 'clr enabled', 1.
Show Suggested Answer Hide Answer
Suggested Answer: CE 🗳️
by [deleted] at April 4, 2025, 12:41 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Currently there are no comments in this discussion, be the first to comment!
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel