You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution includes a SQL Server 2008 Analysis Services (SSAS) application that resides on a single server.
Data in the SSAS database grows every month.
You need to provide a scalability strategy that meets the following requirements:
-Maximizes the end-user throughput.
-Minimizes daily downtime window due to processing.
-Accommodates an unexpected increase in the number of users.
What should you do?
A.
Use proactive caching on the server.
B.
Add an additional server and use remote partitions.
C.
Scale out the solution by adding more computers and use the Read-Only Database functionality.
D.
Use the multidimensional online analytical processing (MOLAP)�enabled write-back capabilities of the Analysis Services.
Explanation:
Tip: "scalability strategy" = "Read-Only"