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 DirectQuery 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 DirectQuery 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 ROLAP (Relational OLAP) storage mode.

D.
An In-Memory query mode.

E.
A SharePoint Server running a PowerPivot workbook.

Explanation:

Show Hint

Leave a Reply 3

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

Lorenzo

Lorenzo

Hey, I have bought an updgrae a week ago and things are not ok, for indeed even seeming it is alright, products in home are not appearing, and also any search I try to do, it shows errors like the ones below.:[Microsoft][ODBC Microsoft Access Driver] ORDER BY clause (customerTypesPrices.price) conflicts with DISTINCT./Comersus/includes/databaseFunctions.asp, line 57=========================another search gives (seems any search gives error)(Search criteria: Category .. ordered by: no ordering specified ) Microsoft VBScript runtime error ‘800a0006 Overflow: cint’/comersus/includes/itemFunctions.asp, line 273===========================and also the backoffice is not working.are there bugs in this items functions.asp or is something wrong with my db? By the way, I have a list of almost 70000 items (as it was in the former version and never had any problem).Paulo[] Reply:December 6th, 2012 at 1:38 amYou need to updgrae your database structure to 9.10 before using 9.10 Power Pack. Upgrade DB utility is provided in Free Downloads Page.[]

Reply