Microsoft
70-768 · Question #15
You are responsible for installing new database server instances. You must install Microsoft SQL Server Analysis Services (SSAS) to support deployment of the following projects. You develop both…
The correct answer is B. Install one multidimensional instance of SSAS. C. Install one tabular instance of SSAS. Analysis Services can be installed in one of three server modes: Multidimensional and Data Mining (default), Power Pivot for SharePoint, and Tabular. https://docs.microsoft.com/en-us/sql/analysis-services/comparing-tabular-and-multidimensional-
Implement a Comprehensive Datacenter Management Solution
Question
You are responsible for installing new database server instances. You must install Microsoft SQL Server Analysis Services (SSAS) to support deployment of the following projects. You develop both projects by using SQL Server Data Tools. You need to install the appropriate services to support both projects. Which two actions should you perform? Each correct answer presents part of the solution.
Options
- AInstall one tabular instance of SSAS and enable the Data Mining Extensions.
- BInstall one multidimensional instance of SSAS.
- CInstall one tabular instance of SSAS.
- DInstall a multidimensional instance and a Power Pivot instance of SSAS on the same server.
- EInstall two separate tabular instances of SSAS.
How the community answered
(46 responses)- A13% (6)
- B78% (36)
- D7% (3)
- E2% (1)
Explanation
Analysis Services can be installed in one of three server modes: Multidimensional and Data Mining (default), Power Pivot for SharePoint, and Tabular. https://docs.microsoft.com/en-us/sql/analysis-services/comparing-tabular-and-multidimensional-
Topics
#SSAS installation#tabular mode#multidimensional mode#SQL Server services
Community Discussion
No community discussion yet for this question.