Microsoft
70-768 · Question #47
70-768 Question #47: Real Exam Question with Answer & Explanation
The correct answer is A. Create a second instance of SSAS on a different server and dedicate this instance to processing C. Create a new Network Load Balanced (NLB) cluster. E. Create a new remote SSAS partition.. See the full explanation below for the reasoning.
Question
You manage an instance of SQL Server Analysis Services (SSAS). Over the last several months, the usage on the server increased by 50% as users begin to create and run more analyses. Queries are taking longer to run, and processor usage is consistently above 80%. You predict that query usage will continue to increase at 5% per month. You need to scale SSAS to accommodate the present and future processing load. Which three actions could you take? Each correct answer presents a complete solution.
Options
- ACreate a second instance of SSAS on a different server and dedicate this instance to processing
- BCreate a new local SSAS partition.
- CCreate a new Network Load Balanced (NLB) cluster.
- DCreate a second instance of SSAS on the same server and dedicate this instance to processing
- ECreate a new remote SSAS partition.
Community Discussion
No community discussion yet for this question.