IBM C2090-635 Online Practice Questions and Exam Preparation

IBM C2090-635 Online Questions & Answers

• Question 31:

  To add dimensional data to an existing model, how can metadata be leveraged from other published OLAP packages?

  A. Insert an OLAP package in the data source list.
  B. Import a PowerCube as a data source.
  C. Add dimensions from an OLAP package in the dimension map.
  D. Add a data source query using a Cognos 10 OLAP report.
  C. Add dimensions from an OLAP package in the dimension map.

• Question 32:

  How can a developer include a key performance indicator that is unavailable in the Transformer data source?

  A. Add a manual category.
  B. Add a calculated measure.
  C. Create a cube group.
  D. Add a measure allocation.
  B. Add a calculated measure.

• Question 33:

  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.
  D. The category moved within the level has its data history moved with it.

• Question 34:

  For a cube that represents values in Euros, what should be done for American consumers to see the appropriate currency symbol in Euros?

  A. Build Cubes using a system locale that matches the measure locale.
  B. Manually create and update the base currency information.
  C. Set up currency conversion without defining a default currency.
  D. Use more than one data source to supply the conversion rates.
  A. Build Cubes using a system locale that matches the measure locale.

• Question 35:

  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.
  A. Set the level inclusion to suppress categories that are not needed.

• Question 36:

  When measures are calculated after rollup, when are the calculations performed?

  A. Before time state rollup takes place.
  B. After allocated measures are calculated.
  C. Before regular rollup takes place on all measures.
  D. After relative time calculations.
  B. After allocated measures are calculated.

• Question 37:

  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.
  A. Set up a lunar time period.

• Question 38:

  What must be unique to create an alternate hierarchy?

  A. The top level
  B. The highest level in a dimension
  C. The lowest level in adimension
  D. The level of convergence
  D. The level of convergence

• Question 39:

  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.
  C. Use calculated columns instead of before rollup measures.

• Question 40:

  What can be done to show how many retailers of each type bought a specific product each month, quarter, or year?

  A. Create a calculated measure with a Time state rollup.
  B. Specify an allocated measure as the Activity Measure.
  C. Create a calculated column.
  D. Define a measure that counts categories.
  D. Define a measure that counts categories.