Exam 70-768 topic 1 question 21 discussion

Actual exam question from Microsoft's 70-768

Question #: 21
Topic #: 1

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.
✑ Project1 uses the tabular data model.
✑ Project2 uses SQL Server data mining to predict customer-purchasing intentions by using the Decision Trees algorithm.
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.

A. Install one tabular instance of SSAS and enable the Data Mining Extensions.
B. Install one multidimensional instance of SSAS.
C. Install one tabular instance of SSAS.
D. Install a multidimensional instance and a Power Pivot instance of SSAS on the same server.
E. Install two separate tabular instances of SSAS.

Show Suggested Answer

Suggested Answer: BC 🗳️
Analysis Services can be installed in one of three server modes: Multidimensional and Data Mining (default), Power Pivot for SharePoint, and Tabular.
References:https://docs.microsoft.com/en-us/sql/analysis-services/comparing-tabular-and-multidimensional-solutions-ssas

by bhrv at Nov. 16, 2020, 3:09 p.m.

Comments

Submit Cancel

bhrv

4 years, 6 months ago

Wrong link is attached pleas correct to https://docs.microsoft.com/en-us/analysis-services/instances/determine-the-server-mode-of-an-analysis-services-instance?view=asallproducts-allversions

upvoted 1 times

...

bhrv

4 years, 6 months ago

Where is information about data mining ? There is nothing about it in the linked article.

upvoted 1 times

...