PrepAway - Latest Free Exam Questions & Answers

Which two actions should you perform?

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.

PrepAway - Latest Free Exam Questions & Answers

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.

Explanation:

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-multidimensionalsolutions-ssas


Leave a Reply