IBM Cognos BI Professional: C2090-180

A user makes the following request:"I need to see actual sales compared with projected sales,and margin range for branches within each division, by product line, sales rep by sales manager,and cost center over time."

Which of the following is a dimension identified by the request?

A. Cost

B. Margin Range

C. Actual / Projected

D. Sales Range

Which of the following describes an advantage of using the dimensionally modeled relational(DMR) technique to access a normalized data structure?

A. eliminates the need for aggregate tables

B. reduces the time needed to fetch the required data

C. enables drill up/down functionality in reports and ad hoc queries

D. enables creation of IQDs for creating Power Cubes

When comparing two differently grained facts directly against one another, the developer must:

A. either write a union query or two reports that roll both facts up to a common level

B. either roll up the lower grained fact to the higher level or allocate the higher grained fact to thelower level

C. declare determinants at multiple levels in the dimensions of a DMR Framework Managermodel

D. ensure that all conformed dimensions shared by the facts have the same number of levels