C2090-635 Online Practice Questions and Answers

What must be done to make the cube data available in Analysis Studio?

A. Use the PowerCube Connection Utility to publish thecube.

B. Create a data source connection to the cube in Transformer.

C. Publish the PowerCube as a data source and a package.

D. Generate a package that contains a data source connection to the cube.

How can a developer customize the reporting period so that the year has 52 weeks, with 7 days in each week, yielding 364 days?

A. Set up a lunar time period.

B. Set up a time period based on a calendar year.

C. Set up a time period based on fiscal year.

D. Set up a relative time category.

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.

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.

Where should fact queries against OLAP sources come from?

A. A flat file

B. An .iqd file

C. A Cognos 10 report

D. A Cognos 10 package

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

A. The measure values are not rolled up to the new path of the moved categories.

B. The category can bemoved to another level.

C. The developer must manually restructure the categories in the dimension.

D. The category moved within the level has its data history moved with it.

A group called Authors is used in a custom view. How is information updated if the Author group members change in the authentication provider?

A. The PowerCube must be rebuilt.

B. The services must be restarted in Cognos Configuration.

C. The changes are automatically updated at run time.

D. The package must be republished.

A dimension organizes all the regions by Country and City. Disregarding the hierarchicalorganization, how can the five best performing regions be grouped?

A. Create a scenario dimension.

B. Add an alternate drill-down path.

C. Add a special category.

D. Create a subdimension.

Which option decreases cube size by removing data from the cube?

A. Suppress

B. Summarize

C. Apex

D. Cloak

What can be done in a manual level to keep new data separate until it can be connected to the appropriate parent category?

A. Create an orphanage category.

B. Create a special category.

C. Include categories when needed.

D. Prohibit automatic creation of new categories.