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

Question

Options

• AAnalysis Services
• BData Management Service
• CCube Building Service
• DReporting Data Service

• A
  6% (2)
• B
  3% (1)
• C
  86% (30)
• D
  6% (2)

Explanation

It is the Cube Building Service that provides the ability to view data through Project Web Access and to use Data Analysis Services. 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. Answer option D is incorrect. The Reporting Data Service generates metadata and data for the Cube Building Service. Answer option B is incorrect. This option is invalid. There is no such service as Data Management Answer option A is incorrect. Analysis Services allow the Data Analysis Wizard to interact with the cube and the data. SSAS stands for SQL Server Analysis Services. It stores, processes, and secures data. It delivers OLAP (Online Analytical Processing) and data mining functionalities for business intelligence applications. It is used to design, create, and manage multi-dimensional structures that contain data aggregated from other data sources.

No community discussion yet for this question.