IBM IBM Cognos COG-310 Questions & Answers

• Question 41:

  When creating a drill process to drill to data from an external source, which of the following must be created?

  A. An ODBC connection.

  B. A process to read the data into a cube.

  C. A cube containing the data.

  D. A view of the data.

  Correct Answer: A

• Question 42:

  Why would a developer create a consolidated element?

  A. To display comments in a cube.

  B. To apply alternate names to an element.

  C. To store numeric data.

  D. To calculate an aggregation.

  Correct Answer: D

• Question 43:

  An application developer would like to place a button on a template to run a process to upload data.

  Which of the following can be used to do this?

  A. Control toolbox

  B. Data validation

  C. Turbo Integrator

  D. Action button

  Correct Answer: D

• Question 44:

  Why must an application developer publish a report or template in an application folder?

  A. To update the reference on the TM1 server.

  B. To move the reference to the TM1 server.

  C. To make the reference available on TM1 web.

  D. To move the reference to a common location.

  Correct Answer: C

• Question 45:

  Which of the following rules should appear first in a rule file?

  A. []

  B. ['Gross Margin %']

  C. ['Gross Margin %', 'January']

  D. ['Gross Margin %', 'Total Year'].

  Correct Answer: C

• Question 46:

  Which of the following rules indicates an incorrect or missing feeder statement?

  A. Jan and Q1 have values but Feb and Mar are zero.

  B. Jan and Feb have values but Mar is zero.

  C. Jan, Feb, Mar are zero but Q1 has a value.

  D. Jan, Feb, Mar have values but Q1 is zero.

  Correct Answer: D

• Question 47:

  Which of the following rules should be fed?

  A. []=C:'Price'*'Cost';

  B. []=N:'Price'*'Cost';

  C. []=S:'Price*Cost';

  D. []=C:'Price'/'Cost';

  Correct Answer: B

• Question 48:

  Why would an application developer compute Gross Margin in a dimension hierarchy?

  A. To use the fast consolidation engine.

  B. To use a feeder.

  C. To store the data in a specific cell in the cube.

  D. To optimize a rule.

  Correct Answer: A

• Question 49:

  In order to calculate Revenue in the Sales cube, the application developer uses the Unit Price from the Pricing cube to multiply it by Units sold, also in the Sales cube.

  Where should the most efficient rule and feeder reside?

  A. Rule and feeder in Sales.

  B. Rule and feeder in Pricing.

  C. Rule in Sales, feeder in Pricing.

  D. Rule in Pricing, feeder in Sales.

  Correct Answer: A

• Question 50:

  When an application developer adds new rules to a cube, which of the following statements should be added to the rules file to turn the fast consolidation algorithm on?

  A. SKIPCHECK

  B. STET

  C. CONTINUE

  D. FEEDERS

  Correct Answer: A