nerdexam
Microsoft

70-177 · Question #70

You have a Project Server 2010 environment. You have a single OLAP cube that your executives are using for data analysis. The Department lookup table lists Departments A and B. You need to create a…

The correct answer is A. Create a new OLAP cube and set department filters. See the full explanation below for the reasoning.

Question

You have a Project Server 2010 environment. You have a single OLAP cube that your executives are using for data analysis. The Department lookup table lists Departments A and B. You need to create a view that shows total project resource costs for Department B, without allowing access to information for Department A. What should you do?

Options

  • ACreate a new OLAP cube and set department filters.
  • BCreate a new OLAP view that filters for Department B.
  • CCreate a new Portfolio Analysis view that filters for Department B.
  • DCreate an enterprise custom project field that points to the Department lookup table.

How the community answered

(57 responses)
  • A
    82% (47)
  • B
    4% (2)
  • C
    11% (6)
  • D
    4% (2)

Community Discussion

No community discussion yet for this question.

Full 70-177 Practice