PrepAway - Latest Free Exam Questions & Answers

Which scale-out strategy should you use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You have deployed a SQL Server 2008 Reporting Services (SSRS) application. The number of users for the SSRS application increases. This results in performance problems. The datasets for the reports are optimized.
You investigate the SSRS deployment and discover the following characteristics:
-Users report that the reports take a long time to run.
-There are a large number of graphical reports that summarize data.
-Subscription processing affects the performance of reports that are run by interactive users.

You need to modify the SSRS infrastructure to resolve the performance problems.
Which scale-out strategy should you use?

PrepAway - Latest Free Exam Questions & Answers

A.
Single SSRS server and a single reporting database server

B.
Multiple SSRS servers and a single reporting database server

C.
Single SSRS server and multiple reporting database servers

D.
Multiple SSRS servers and multiple reporting database servers

Explanation:
Tip: "scale-out strategy" = "Multiple SSRS .. single database"

Scaling Out
The Enterprise edition of SSRS supports scaling outthat is, using more than one physical machine to support the particular SSRS solution that runs from a common database.
Multiple reporting database servers are not possible and Single SSRS server won’t improve RS performance.


Leave a Reply