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. 579EXAM 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.