70-448 · Question #51
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 A. On both cluster nodes, you should install SSRS to use the same ReportServer database. See the full explanation below for the reasoning.
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. You company CIO decides to deploy SQL Server 2008 Reporting Services (SSRS) on a SQL Server 2008 failover cluster. Since you are the IT support, the company CIO assigns this task to you. You check and find that both nodes of the cluster have been installed with Internet Information Services (IIS) which is virtualized on the Network Load Balancing (NLB) cluster. Now you have to perform the deployment of the SSRS in a fault-tolerant scale-out deployment. So what action should you perform?
Options
- AOn both cluster nodes, you should install SSRS to use the same ReportServer database
- BOn both cluster nodes, you should install SSRS to use separate ReportServer databases
- COn both cluster nodes, you should install SSRS, and then you should use the SQL Server resource
- DOn both cluster nodes, you should install SSRS, and then you should use a new resource group to
How the community answered
(53 responses)- A77% (41)
- B6% (3)
- C13% (7)
- D4% (2)
Community Discussion
No community discussion yet for this question.