IBM C2090-635 Online Practice Questions and Exam Preparation

IBM C2090-635 Online Questions & Answers

• Question 11:

  What must be done to make the cube data available in Analysis Studio?

  A. Use the PowerCube Connection Utility to publish thecube.
  B. Create a data source connection to the cube in Transformer.
  C. Publish the PowerCube as a data source and a package.
  D. Generate a package that contains a data source connection to the cube.
  C. Publish the PowerCube as a data source and a package.

• Question 12:

  How can a developer best address valuesthat are being rounded excessively?

  A. Adjust the number of decimal places.
  B. Create a calculated measure.
  C. Modify the rollup operations.
  D. Assign scale and precision settings.
  D. Assign scale and precision settings.

• Question 13:

  Where can a developer change relationships to create a structure different from what the data suggests?

  A. Categories Diagram
  B. Dimension Map
  C. Data source property sheet
  D. Level property sheet
  A. Categories Diagram

• Question 14:

  What can be done to correct a report that contains time categories that are out of range and irrelevant to the user?

  A. Ensure the input format is correct for dates in the source data.
  B. Check to see if an absolute rangecategory is automatically generated.
  C. Adjust the acceptable dates included in the model.
  D. Create a non-standard time dimension.
  C. Adjust the acceptable dates included in the model.

• Question 15:

  Which of the following can be done to improve performance when dealing with large volumes of data?

  A. Include multiple data sources.
  B. Use a single large data source.
  C. Include transactional and structural data sources of the same type.
  D. Use Cognos 10 reports as transactional and structural data sources.
  A. Include multiple data sources.

• Question 16:

  As a good practice, what can a developer do to be prepared in case a model develops conflicts or becomes corrupt?

  A. Keepa backup .mdl file.
  B. Keep a backup .py? file.
  C. Keep a backup qy? file.
  D. Keep a backup .py? and qy? files.
  A. Keepa backup .mdl file.

• Question 17:

  For performance reasons, what is thebest parent-child ratio for categories in each level?

  A. 1:10 or less
  B. 1:11 or more
  C. 5:1 or less
  D. 10:1 or more
  A. 1:10 or less

• Question 18:

  What modeling factor affects the auto-partitioningstrategy and causes poor consolidation for partitioned categories?

  A. Wide, flat dimensions
  B. Well-balanced hierarchical dimensions
  C. Allocated measures
  D. After rollup calculated measures
  A. Wide, flat dimensions

• Question 19:

  How can a developer define a specific view of the data and restrict access to it?

  A. Apply cube-based security.
  B. Set member-based security.
  C. Apply namespace-level security.
  D. Set package-based security.
  B. Set member-based security.

• Question 20:

  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.