70-448 · Question #53
You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL…
The correct answer is B. In order to make sure of this, you should restore the encryption keysrestore the encryption keys. 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…
Question
You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL Server 2008. 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?
Options
- AIn order to make sure of this, you should reinitialize the Report Server.
- BIn order to make sure of this, you should restore the encryption keysrestore the encryption keys
- CIn order to make sure of this, you should recreate the encryption keys.
- DIn order to make sure of this, you should recreate the Report Server database
How the community answered
(36 responses)- A17% (6)
- B75% (27)
- C6% (2)
- D3% (1)
Explanation
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
Topics
Community Discussion
No community discussion yet for this question.