IBM C2020-635 - IBM Cognos 10 BI OLAP Developer Exam

Question #11 (Topic: )
How can the parent-child relationship for each category be established?
A. Verify the model. B. Insert manual levels. C. Show category counts. D. Generate the categories.
Answer: D
Question #12 (Topic: )
The developer notices a decrease in run-time performance in a model that has calculated
measures (before rollup). Because auto-partitioning is not used, how can the developer
increase performance?
A. Use a duplicates rollup instead of a before rollup setting. B. Use an external rollup instead of a before rollup setting. C. Use calculated columns instead of before rollup measures. D. Use atime state rollup instead of before rollup setting.
Answer: C
Question #13 (Topic: )
How can a developer include a key performance indicator that is unavailable in the
Transformer data source?
A. Add a manual category. B. Add a calculated measure. C. Create a cube group. D. Add a measure allocation.
Answer: B
Question #14 (Topic: )
What can be done to show how many retailers of each type bought a specific product each
month, quarter, or year?
A. Create a calculated measure with a Time state rollup. B. Specify an allocated measure as the Activity Measure. C. Create a calculated column. D. Define a measure that counts categories.
Answer: D
Question #15 (Topic: )
The model contains a measure named Quantity, and the OLAP reports need to show the
Minimum monthly quantity sold to each store. How would a developer get the correct
result?
A. Use a Regular rollup function. B. Use a Time state rollup function. C. Use an External rollup function. D. Use a Non-regular rollup function.
Answer: A
Download Exam
Page: 3 / 13
Total 65 questions