Microsoft
70-448 · Question #261
You plan to deploy SQL Server 2008 Reporting Services (SSRS) on a SQL Server 2008 failover cluster. Internet Information Services (IIS) is installed on both nodes of the cluster. The IIS is…
The correct answer is B. Install SSRS on both cluster nodes to use the same ReportServer database. See the full explanation below for the reasoning.
Question
You plan to deploy SQL Server 2008 Reporting Services (SSRS) on a SQL Server 2008 failover cluster. Internet Information Services (IIS) is installed on both nodes of the cluster. The IIS is virtualized on the Network Load Balancing (NLB) cluster. You need to deploy SSRS in a fault-tolerant scale-out deployment. What should you do?
Options
- AInstall SSRS on both cluster nodes to use separate ReportServer databases.
- BInstall SSRS on both cluster nodes to use the same ReportServer database.
- CInstall SSRS on both cluster nodes and cluster the SSRS service by using a new resource group.
- DInstall SSRS on both cluster nodes and cluster the SSRS service by using the SQL Server resource group.
How the community answered
(41 responses)- A7% (3)
- B73% (30)
- C15% (6)
- D5% (2)
Community Discussion
No community discussion yet for this question.