You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008. Now you are employed in a company
named NaproStar which uses SQL Server2008. You work as the technical support. Now you
are in charge of a SQL Server 2008 Reporting Services (SSRS) instance. Some reports are
included in the instance. The reports access data from a SQL Server 2008 instance by using
stored credentials. There is a computer which contains an instance. The computer
experiences hardware failure, after it recovers, you install a new SSRS instance on it. Now
you must make sure that the reports hosted on the instance can still function correctly. So
what action should you perform?
A.
In order to make sure of this, you should reinitialize the Report Server.
B.
In order to make sure of this, you should restore the encryption keysrestore the encryption
keys
C.
In order to make sure of this, you should recreate the encryption keys.
D.
In order to make sure of this, you should recreate the Report Server database
Explanation:
MCTS Self-Paced Training Kit (Exam 70-448) p. 579
EXAM TIP When faced with a system failure where you lose your SSRS instance and/or
database, you will:* first need to reinstall SSRS.
* After the installation is complete, you can optionally restore the latest backup of your report
server catalog database (if it was also lost).
* After the service and catalog databases are in place,
* your final step is to restore the encryption key onto the newly installed instance of SSRS.
This will enable the report server to be able to decrypt the catalog security, reports, and data
sources.