IBM IBM Cogno C2090-635 Questions & Answers

• Question 41:

  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.

  Correct Answer: C

• Question 42:

  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.

  Correct Answer: D

• Question 43:

  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.

  Correct Answer: A

• Question 44:

  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

  Correct Answer: A

• Question 45:

  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.

  Correct Answer: D

• Question 46:

  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

  Correct Answer: B

• Question 47:

  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.

  Correct Answer: D

• Question 48:

  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

  Correct Answer: A

• Question 49:

  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.

  Correct Answer: B

• Question 50:

  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.

  Correct Answer: A