C2090-635 Online Practice Questions and Answers

A developer added a manuallevel in the time dimension. During category generation, the developer gets a warning that Transformer is not able to relate the categories to the parent levels. What must be done to ensure Transformer relates the categories correctly?

A. Specify a date function for each level.

B. Specify date input format.

C. Specify an Invalid Dates category.

D. Specify a time-state rollup.

Senior Managers need to see total and regional sales figures, but Regional Managers should see relevant figures for only their regions. Where can the developer specify the degree of detail to be included?

A. Ina manual level

B. In a cube group

C. In the PowerCube

D. In a scenario dimension

If a cube group based on a level in a dimension is created, how can thedeveloper prevent another cube from being added to the cube group?

A. Ensure the level labels and category labels remain unchanged.

B. Specify a category limit for the level.

C. Prevent the automatic creation of categories.

D. Exclude the dimension from auto-partitioning.

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.

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.

What should a developer do if some levels appear red after validating the model using Show Scope?

A. Ensure thelevel exists in the data source.

B. Specify a valid relationship between the level and the data source.

C. Re-attach the categories in the Dimension Diagram.

D. Apply unique move to the level and regenerate the categories.

How can a developer rebuild an incrementally updated cube?

A. Enabletime-based partitioning and rebuild the cube.

B. Clean house and rebuild the cube.

C. Save the model, and revert to the backup .mdl file.

D. Delete the old .mdc file and recreate the entire cube.

A developer notices thattildes (~) exist in the category codes. What can be done to avoid unstable MUN values?

A. Perform a Clean House.

B. Resolve the non-unique keys within a dimension in the data source.

C. Regenerate the categories.

D. Ensure the values are non-conformedin the data source.

What objects can be created within the Cognos Namespace?

A. Roles and users

B. Groupsand roles

C. Groups and users

D. Members

A developer created a cube for each regional Sales Manager. Each cube shouldcontain only the transactional details for each Sales Manager's region, as well as the summarized values for other regions. What should be created?

A. Custom view

B. Cube group

C. Apexed view

D. Suppressed view