COG-702 by IBM Valid Free Exam Practice Test

Question 1

The logging parameter within \}CubeProperties is designated by a "Yes" or "No" for each cube.
What does this define?

A. userpermissionsloggedtothetm1server.log B. Data changes to the TM1 cubes logged into the tm1s.log file C. dimensionupdatesloggedintothetm1audit.log D. cubepropertiesdataloggedintothetm1server.log

Correct Answer: B

Question 2

Click the Exhibit button.

Referring to the exhibit, a rule is written where the sales_amt is equal to units multiplied by avg selling price
What does the cube view tell you about the rule calculation?

A. The rule is overfed. B. The ruled calculation is missing a feeder. C. The rule is underfed D. The rule is missing a Skipcheck statement.

Correct Answer: C

Question 3

If vOriginalDate = July 27, and you require vNewDate = Jul2012, which syntax is appropriate to complete this task?

A. vNewDate=SUBST(vOriginalDate,3,3) & '2012'; B. vNewDate=SUBST(vOriginalDate,3,3) | '2012'; C. vOriginalDate=SUBST(vNewDate,3,3) & '2012'; D. vNewDate=SUBST(vOriginalDate,3,3) + '2012';

Correct Answer: B

Question 4

If there is more than one rule in the rules file for a given cell, which rule does IBM CognosTM1 calculate?

A. Depending on which rule was calculated immediately before, the next one is used. B. It calculates the last applicable rule. C. It calculates the first applicable rule and then stops. D. The rule with the highest priority flag is calculated.

Correct Answer: C

Question 5

Which two statements are true about spreading in TM1? (Choose two.)

A. With spreading, there is only one update action allowed: replace. B. The extend option under spreading allows spreading in more than one direction (e.g., right and up) as one operation. C. Spreading can be used to populate a cube with test data. D. Spreading is often performed on a single dimension without involving a cube.

Correct Answer: B,C

Question 6

Following TM1 best practices for budget applications, which dimension omits consolidated elements?

A. Time B. Organization Chart C. Measures D. Chart of Accounts

Correct Answer: C

IBM Cognos TM1 10.1 Developer - COG-702 Exam Practice Test