Which two of the following options would also be appropriate for this model?

You have been hired as a Business Intelligence (BI) developer at ABC.com. The company uses a
Microsoft SQL Server 2012 infrastructure.
You are using SQL Server Data Tools (SSDT) to create a BI Semantic Model (BISM) that will be
used by company employees to create Power View reports.
The model will pull data from data hosted on a single SQL Server. As the volume of data is small
and static, you decide to configure the project to use the query mode of In-Memory and the project
type of Tabular.
Which two of the following options would also be appropriate for this model? (Choose two).

You have been hired as a Business Intelligence (BI) developer at ABC.com. The company uses a
Microsoft SQL Server 2012 infrastructure.
You are using SQL Server Data Tools (SSDT) to create a BI Semantic Model (BISM) that will be
used by company employees to create Power View reports.
The model will pull data from data hosted on a single SQL Server. As the volume of data is small
and static, you decide to configure the project to use the query mode of In-Memory and the project
type of Tabular.
Which two of the following options would also be appropriate for this model? (Choose two).

A.
A tabular project type.

B.
A multidimensional project type.

C.
A MOLAP (Multidimensional OLAP) storage mode.

D.
A ROLAP (Relational OLAP) storage mode.

E.
A SharePoint Server running a PowerPivot workbook.

Explanation:



Leave a Reply 8

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


Andres

Andres

Which two of the following options WOULD ALSO BE appropriate for this model? (Choose two).
BC is correct

Jane

Jane

Incorrect. Power View requires tabular model.

riu

riu

lol Jane really ???

riu

riu

Answer is B and E