IBM IBM Cognos COG-310 Questions & Answers

• Question 51:

  The application developer created a rule to apply to all elements in a dimension yet the result does not appear.

  Which of the following would have caused this?

  A. A rule impacting this dimension exists above it.

  B. A rule impacting elements in this dimension exists above it.

  C. A rule impacting this dimension exists below it.

  D. A rule impacting elements in this dimension exists below it.

  Correct Answer: B

• Question 52:

  Some users would like to display an account using the account name followed by the account number. Other users would like to display only the account name.

  Which option should the application developer use to satisfy both requirements?

  A. Create a text attribute for each requirement.

  B. Define an alias for each requirement.

  C. Define two alternate hierarchies.

  D. Create two dimensions that link to each other.

  Correct Answer: B

• Question 53:

  Which of the following functions can be used in rules to share data across cubes?

  A. IF

  B. DB

  C. Continue

  D. STET

  Correct Answer: B

• Question 54:

  Which of the following options should an application developer use when they need to verify the children of a selected consolidated cell are fed properly?

  A. Check calculations

  B. Trace calculations

  C. Trace feeders

  D. Check feeders

  Correct Answer: D

• Question 55:

  Which of the following is the best location to calculate a formula once a month, when the data is updated?

  A. Rule

  B. Hierarchy

  C. Turbo Integrator

  D. Relational Database

  Correct Answer: C

• Question 56:

  Which of the following is used in a function to evaluate the current element from the Month dimension?

  A. 'January'

  B. !January

  C. 'Month'

  D. !Month

  Correct Answer: D

• Question 57:

  Which of the following examples will apply a rule to a subset of the Month dimension?

  A. [{'Jan', 'Feb', 'Mar'\}]

  B. ["Jan", "Feb", "Mar"]

  C. ['Jan', 'Feb', 'Mar']

  D. [('Jan', 'Feb', 'Mar')]

  Correct Answer: A

• Question 58:

  Which of the following must be used to reference cube, dimension, and element names in a rule?

  A. Curly braces

  B. Single quotes

  C. Square brackets

  D. Double quotes

  Correct Answer: B

• Question 59:

  An application developer would like to calculate the average percentage ratio instead of the default hierarchy consolidation, but leave the ratio calculation as it appears.

  Which of the following will do this?

  A. Use a function to determine the aggregated cells.

  B. Use an alias to determine the aggregated cells.

  C. Use a feeder statement to determine the aggregated cells.

  D. Use a C: to determine the aggregated cells.

  Correct Answer: D

• Question 60:

  Why would an application developer use a DB () function in an internal cube reference?

  A. To nest another function into it.

  B. To format data in a cube.

  C. To clear data in a cube.

  D. To display an alias.

  Correct Answer: A