nerdexam
Microsoft

70-448 · Question #187

70-448 Question #187: Real Exam Question with Answer & Explanation

The correct answer is B. Restore the encryption keys.. Managing the Encryption Keys is a core to any SQLRS database recoveries that may need to be done. It is therefore recommended that those responsible for supporting SQLRS instances familiarise themselves with the concepts discussed SQLRS Books Online (BOL) under "Managing Encrypti

Question

You administer a SQL Server 2008 Reporting Services (SSRS) instance. The instance contains several reports that use stored credentials to access data from a SQL Server 2008 instance. A computer that hosts the instance recovers from a hardware failure and has a newly installed SSRS instance. You need to ensure that the reports hosted on the instance continue to function correctly. What should you do?

Options

  • AReinitialize the Report Server.
  • BRestore the encryption keys.
  • CRecreate the Report Server database.
  • DRecreate the encryption keys.

Explanation

Managing the Encryption Keys is a core to any SQLRS database recoveries that may need to be done. It is therefore recommended that those responsible for supporting SQLRS instances familiarise themselves with the concepts discussed SQLRS Books Online (BOL) under "Managing Encryption Keys" During setup SQLRS creates encryption keys, which are then used to secure credentials, connection information, and accounts that are used in server operations. As soon as you finish installing SQLRS, you should make a copy of the symmetric key. If you ever need to repair a Reporting Services installation due to changes in computer name, instance name, or user account values, you can apply the key to make the report server database operational.

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-448 Practice