IBM Cognos 10 BI OLAP Developer - C2020-635 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Where should fact queries against OLAP sources come from?

A. A flat file B. A Cognos 10 package C. A Cognos 10 report D. An .iqd file

Discussion 0

Correct Answer: A Vote an answer

Question 2

What can the developer specify for the cube build to use multiple directories to generate
temporary work files?

A. Operating system page file B. Log files C. Data temporary files D. Model temporary files

Discussion 0

Correct Answer: C Vote an answer

Question 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. Apex B. Summarize C. Cloak D. Suppress

Discussion 0

Correct Answer: A Vote an answer

Question 4

At the beginning of the fiscal year, the Camping Equipment product line reduced the number of
products that are being sold. What can be done to remove the inactive categories that are no
longer needed in the model?

A. Set the level inclusion to suppress categories that are not needed. B. Prevent the automatic generation of new categories. C. Generate the categories. D. Incrementally update the Powercube.

Discussion 0

Correct Answer: A Vote an answer

Question 5

How can a developer populate a level with a different data source column?

A. Through level properties. B. Through data source scope. C. Through data source properties. D. Through column properties.

Discussion 0

Correct Answer: A Vote an answer

Question 6

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 an External rollup function. B. Use a Regular rollup function. C. Use a Time state rollup function. D. Use a Non-regular rollup function.

Discussion 0

Correct Answer: B Vote an answer

Question 7

What does unique mean when applied to a level in a dimension map?

A. The level must be the bottom level of the dimension. B. The data history does not move with the categories as they move in the level. C. The level is designated as a convergence level. D. No two categories in the level can be derived from the same source value.

Discussion 0

Correct Answer: D Vote an answer