IBM C2090-635 Online Practice Questions and Exam Preparation

IBM C2090-635 Online Questions & Answers

• Question 1:

  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
  B. Cube group

• Question 2:

  What can be created to determine the monthly growth showing the percentage of change between Current Month and Last Month for all measures included in the PowerCube?

  A. Calculated columns
  B. Calculated categories
  C. Calculated measure
  D. Alternate hierarchies
  B. Calculated categories

• Question 3:

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

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

• Question 4:

  When running simultaneous cube builds, how can cube build times be decreased?

  A. Assign each Transformer process one CPU.
  B. Assign each Transformer instance one CPU.
  C. Use the same configuration files for each Transformer instance.
  D. Usea single-CPU server model.
  A. Assign each Transformer process one CPU.

• Question 5:

  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.
  D. Drag the custom view to the appropriate Powercube.

• Question 6:

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

  A. Suppress
  B. Summarize
  C. Apex
  D. Cloak
  C. Apex

• Question 7:

  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.
  C. The changes are automatically updated at run time.

• Question 8:

  When can Transformer category codes change?

  A. Whena new cube is defined.
  B. When a reset partition is applied.
  C. When the cube connection is updated with pcconn.
  D. When a Clean House is performed before a cube is rebuilt.
  D. When a Clean House is performed before a cube is rebuilt.

• Question 9:

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

• Question 10:

  What can be done if a regular time dimension is added to a model, and the levels Year, Quarter,and Month are not automatically generated?

  A. Set the date input format for the time dimension.
  B. Set the data class of the source category to Date.
  C. Change the numeric time sequence for each level.
  D. Create a non-standard time dimension with thenew levels.
  B. Set the data class of the source category to Date.