C2020-702 Exam Training Practice Tests (IBM Cognos TM1 10.1 Developer)]

Question 1

In Cognos Insight, you have a cube containing the following dimensions with the following members.
Products - Pencils, Pens
Regions - North,
South, East, West
Months - Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sept, Oct, Nov, Dec
Versions - Actuals, Budget You need to determine which region did not sell any Pencils in January (Jan).
Where do you need to set explore points?

A. Jan. Budget. Pens B. Jan. Actuals, Pencils C. All regions, all months except Jan, Pens, Budget D. All regions, all months except Jan, Pencils, Actuals

Correct Answer: B

Question 2

You want to export only user-entered non-zero numeric values from a cube.
Which three view manipulation functions are required? (Choose three.)

A. ViewExtractSkipZeroesSet (exclude zero/null values in export) B. ViewExtractSkipRuleValuesSet (exclude rule calculated values in export) C. ViewExtractSkipStringSet (exclude string values in export) D. ViewExtractSkipLevelZero (exclude leaf level values in export) E. ViewExtractSkipCalcsSet (exclude consolidated values in export)

Correct Answer: A,B,E

Question 3

Click the Exhibit button.

Referring to the entries in the tm1server.log shown in the exhibit, which statement is correct?

A. The process Update_Product_Dimension has no parameters. B. The chore Scheduledjmport has completed. C. The process Update_Product_Dimension has not created an error log. D. The product dimension has been updated.

Correct Answer: C

Question 4

You are concerned about overfeeding in a TM1 model.
What are two symptoms of this? (Choose two.)

A. Increases the log file size B. Data integrity risks occur C. Sub-optimal view performance D. Unnecessary RAM consumption

Correct Answer: C,D

Question 5

Click the Exhibit button.

You have the dimension shown in Performance Modeler as shown in the exhibit.
Which three actions create a subset containing the countries starting with "A" in alphabetical order? (Choose three)

A. Sort descending. B. Hide consolidated members. C. Hide leaf members. D. Sort ascending. E. Filter by wildcard A*.

Correct Answer: B,D,E

Question 6

A TM1 Operations Console shows a thread which is waiting to obtain a read lock on a cube.
Which thread is blocking it?

A. A thread which is waiting to write to the cube B. A thread which holds a write lock on the cube C. A thread which holds a read lock on the cube D. A thread which holds an intent to write lock on the cube

Correct Answer: B

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