IBM C2090-635 Online Practice Questions and Exam Preparation

IBM C2090-635 Online Questions & Answers

• Question 1:

  What can be created to provide newinsight into the data if Margin Ranges are defined as Low, Medium, and High, based on a calculated column using the revenue and cost columns?

  A. Scenario dimension
  B. Exception dimension
  C. Special category
  D. Calculated category
  B. Exception dimension

• Question 2:

  What can be done in a manual level to keep new data separate until it can be connected to the appropriate parent category?

  A. Create an orphanage category.
  B. Create a special category.
  C. Include categories when needed.
  D. Prohibit automatic creation of new categories.
  A. Create an orphanage category.

• Question 3:

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

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

• Question 4:

  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 5:

  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 6:

  When there are too many childcategories, what can be created to allow intermediate groupings?

  A. A cube group
  B. An alternate drill-path
  C. A manual level
  D. A subdimension
  C. A manual level

• Question 7:

  A dimension organizes all the regions by Country and City. Disregarding the hierarchicalorganization, how can the five best performing regions be grouped?

  A. Create a scenario dimension.
  B. Add an alternate drill-down path.
  C. Add a special category.
  D. Create a subdimension.
  C. Add a special category.

• Question 8:

  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 9:

  The dimensions in the model include Product, Customer, and Order. If the Powercube should focus on the sales orders, how can the developer remove customer data?

  A. Omit the dimension from the PowerCube.
  B. Apex the dimension in the model.
  C. Set measure allocation for the Customer dimension.
  D. Suppress the dimension in the model.
  A. Omit the dimension from the PowerCube.

• Question 10:

  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
  A. Scenario dimension