You need to install the appropriate services to support…

HOTSPOT
You are a database administrator in a company that uses Microsoft SharePoint Server for all intranet sites. You are responsible for the installation of new database server instances.
You must install Microsoft SQL Server Analysis Server (SSAS) to support deployment of the following projects.
You develop both projects by using SQL Server Data Tools.
Project1 is based on a multidimensional data model that contains four cubes. Each cube has nine dimensions.
Project2 uses SQL Server data mining to predict customer purchasing intention using the Decision Trees algorithm.You need to install the appropriate services to support both projects.
What should you do? In the table below, select the appropriate services for each project.
NOTE: Make only one selection in each column. Each correct selection is worth one point.
Hot Area:

HOTSPOT
You are a database administrator in a company that uses Microsoft SharePoint Server for all intranet sites. You are responsible for the installation of new database server instances.
You must install Microsoft SQL Server Analysis Server (SSAS) to support deployment of the following projects.
You develop both projects by using SQL Server Data Tools.
Project1 is based on a multidimensional data model that contains four cubes. Each cube has nine dimensions.
Project2 uses SQL Server data mining to predict customer purchasing intention using the Decision Trees algorithm.You need to install the appropriate services to support both projects.
What should you do? In the table below, select the appropriate services for each project.
NOTE: Make only one selection in each column. Each correct selection is worth one point.
Hot Area:

Answer:

Explanation:
Project1:
Project2: MultidimensionalNote: Analysis Services can be installed in one of three server modes: Multidimensional and Data Mining
(default), Power Pivot for SharePoint, and Tabular.
Incorrect Answers:
Not Power Pivot: Power Pivot is simpler, offering visual data modeling in Excel, with server support provided via
SharePoint.
References:https://docs.microsoft.com/en-us/sql/analysis-services/comparing-tabular-and-multidimensionalsolutions-ssas



Leave a Reply 0

Your email address will not be published. Required fields are marked *