C2090-635 Online Practice Questions and Answers

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.

For performance reasons, what is thebest parent-child ratio for categories in each level?

A. 1:10 or less

B. 1:11 or more

C. 5:1 or less

D. 10:1 or more

Transformer is unable to locate one of the source files for a data source in the model, and the model update fails. Which type of files can be used to restart the processing at the point of failure?

A. .py?

B. .qy?

C. .mdl

D. .mdx

Columns have been renamed in the data source. Which command must the developer run to update the model?

A. Check Columns

B. Update Columns

C. Rename columns

D. Modify Columns

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 does the developer specify when creating a test build that uses a subset of the source data?

A. The number of categories.

B. The dimensions to include in the cube.

C. The number of records.

D. The measures to include in the cube.

How does a developer associate a custom view with a PowerCube?

A. Update the Powercube properties.

B. Specify the path of the Powercube in the custom view.

C. Specify the packagename in the custom view.

D. Drag the custom view to the appropriate Powercube.

How is the PowerCube updated once changes are made to a custom view?

A. The cube must be rebuilt.

B. The custom view should be re-defined.

C. The changes are automatically updated.

D. Security objects must be re-assigned.

What objects can be created within the Cognos Namespace?

A. Roles and users

B. Groupsand roles

C. Groups and users

D. Members