Microsoft Exam 70-768 Topic 9 Question 5 Discussion

Actual exam question for Microsoft's 70-768 exam

Question #: 5
Topic #: 9

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.

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.

Show Suggested Answer

Suggested Answer: B, C

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 Hermila at May 08, 2022, 06:35 AM

Limited Time Offer

25%

Off

Get Premium 70-768 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!