PrepAway - Latest Free Exam Questions & Answers

What should you do?

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?

PrepAway - Latest Free Exam Questions & Answers

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"


Leave a Reply