C2090-635 Online Practice Questions and Answers

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

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.

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.

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.

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. Incrementally update the Powercube.

C. Prevent the automatic generation of new categories.

D. Generate the categories.

To control access to content for users that have similar responsibilities and privileges,where should security be applied?

A. Data source

B. Role

C. User

D. Namespace

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.

What can be done to apply member-based security if the model contains cube groups?

A. Define the security for each member cube.

B. Inherit the security that was used in the control cube.

C. Create a hierarchical custom view.

D. Create a descendant custom view.

What can a developer set up to analyze actual, planned, and forecasted budget information that do not rollup into a single root category?

A. Scenario dimension

B. Calculated category

C. Special category

D. Exception dimension