PrepAway - Latest Free Exam Questions & Answers

Which Microsoft Project Server service manages OLAP cubes to view within Project Web Access and to use Data An

Which Microsoft Project Server service manages OLAP cubes to view within Project Web Access and to use Data Analysis cubes?

PrepAway - Latest Free Exam Questions & Answers

A.
Data Management Service

B.
Analysis Services

C.
Cube Building Service

D.
Reporting Data Service

Explanation:
It is the Cube Building Service that provides the ability to view data through Project Web Access and to use Data Analysis Services.
Answer option D is incorrect. Reporting Data Service generates metadata and data for the Cube Building Service.
Answer option A is incorrect. There is no such service as Data Management Service. Answer option B is incorrect. Analysis services allow Data Analysis to interact with the cube and the data.
What is the Cube Building Service?
The Cube Building Service is a reporting and analysis feature in Microsoft Project Server that allows a user to perform complex analysis of project data. It uses SQL Server Analysis Services to create an online analytical processing (OLAP) database containing several cubes that are used for data analysis reporting. It is administered through the Project Web Access Site Settings page. It allows for data cubes to be built from selections within the Reporting database.


Leave a Reply