IBM C2090-635 Online Practice Questions and Exam Preparation

IBM C2090-635 Online Questions & Answers

• Question 41:

  The model contains a measure named Quantity, and the OLAP reports need to show the Minimum monthly quantity sold to each store. How would a developer get the correct result?

  A. Use a Regular rollup function.
  B. Use a Time state rollup function.
  C. Use an External rollup function.
  D. Use a Non-regular rollup function.
  A. Use a Regular rollup function.

• Question 42:

  Which of the following will help improve processing time when Transformer queries the data?

  A. Use normalized structural data sources.
  B. Separate structural and transactional information in multiple data sources.
  C. Combine structural and transactionalinformation into one data source.
  D. Define dimensions within a transactional data source with unique values.
  B. Separate structural and transactional information in multiple data sources.

• Question 43:

  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.
  D. Delete the old .mdc file and recreate the entire cube.

• Question 44:

  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
  B. .qy?

• Question 45:

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

  What can the developer specify for the cube build to use multiple directories to generate temporary work files?

  A. Log files
  B. Model temporary files
  C. Operating system page file
  D. Data temporary files
  D. Data temporary files

• Question 47:

  What can be applied to a category if only the parent and child categories arerequired?

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

• Question 48:

  Where should fact queries against OLAP sources come from?

  A. A flat file
  B. An .iqd file
  C. A Cognos 10 report
  D. A Cognos 10 package
  A. A flat file

• Question 49:

  How can the cube build flexibility and performance be maximized?

  A. Enable Consolidation.
  B. Enable the AutoSummarize property.
  C. Combine Structural and Transactional data into one data source
  D. Preprocess the data.
  D. Preprocess the data.

• Question 50:

  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.
  B. Resolve the non-unique keys within a dimension in the data source.