COGNOS BI0-135 Exam - CertifySky.com

Free BI0-135 Sample Questions:

Q: 1
What occurs when reporting from a cube that contains an Apex custom view?
A. The root member of each apexed view remains the same.
B. Report authored members from one version of an apexed view are valid for all other consumers.
C. Inaccessible members from one view are replaced with corresponding member references from another view.
D. The available levels in the dimemsion may differ based on the level where apex is applied.
Answer: D

Q: 2
What can be created if the financial analyst wants to look at the data by fiscal year, while the senior manager wants to analyze the data by calendar year?
A. An alternate hierarchy in the time dimension.
B. A manual level in the time dimension.
C. A special category.
D. A calculated category.
Answer: A

Q: 3
The Region dimension is organized by Territory, Country, and City. Which option can be applied to only show data for the United States and its descendants?
A. Suppress
B. Apex
C. Summarize
D. Cloak
Answer: B

Q: 4
What must be unique to create an alternate hierarchy?
A. The top level
B. The highest level in a dimension
C. The lowest level in a dimension
D. The level of convergence
Answer: D

Q: 5
What can a developer set up to analyze actual, planned, and forecasted budget information that do not rollup into a single root category?
A. Scenario dimension
B. Calculated category
C. Special category
D. Exception dimension
Answer: A