C2020-701 Exam - Free IBM Questions and Answers

Question #11 (Topic: )

Which three statements are true regardingTM1 Excel functions? (Choose three.)

A. The VIEW function creates an optimized view of the cube specified by the cube argument. B. The DBR function stands for Database Read. C. The value returned by the DBRA function cannot be edited. D. ELCOMP returns the name of a child of a consolidated element in a specified dimension E. SUBNM returns the element of a dimension subset and allows a double-click to bring up the subset editor.

Answer: A,D,E

Question #12 (Topic: )

A Private TM1 Cube View can be shared with which group?

A. Public B. Only to the creator C. Administrators D. Only to directory managers

Answer: B

Question #13 (Topic: )

A userentering numerical data into TM1 Application Web places a hold consolidate on
North America with three children: Canada, USA, and Mexico. At the time the hold is
placed, the value of North America is $30.00, with each child value set at $10.00. A user
subsequently adds $10.00 to the value of Canada.
Which statement is correct?

A. "North America" increases $10.00, "USA" and "Mexico" remain unchanged. B. "North America" remains unchanged. "USA" and "Mexico" are reduced by $5.00 each. C. "North America" remains unchanged, "USA" is reduced by $10.00, "Mexico" remains unchanged. D. All values are on hold, so the add function is ignored.

Answer: B

Question #14 (Topic: )

Which three selections would you find in the Properties window of the subset editor?
(Choose three.)

A. Alias B. Weight C. Type D. Parent Element E. Attribute

Answer: B,C,E

Question #15 (Topic: )

In which tier of the IBM Cognos TM1 client-server architecture does the TM1 Administration
Server reside?

A. Tier 2: Web Application Server B. Tier 1: Web Client C. Tier 4:Relational Store D. Tier 3: Data

Answer: D

IBM C2020-701 - IBM Cognos TM1 10.1 Analyst Exam