C2020-701 Online Practice Questions and Answers

Click the Exhibit button.

In the Assumptions dimension all key figures are formatted correctly as shown in the exhibit, yet all values are displayed as currency.

Wherewould you search for the currency format?

A. In the title dimensions

B. In the other row dimension

C. In the column dimensions

D. In the cube format

A user is a member of four security groups: A, B,C, and D. For the Budgetcube, group A has WRITE access, group B has READ access, group C has RESERVE access, and group D has a NONE access level.

Which access level will the user have to the Budget cube?

A. WRITE

B. READ

C. RESERVED

D. NONE

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.

A financial controller wants to create a financial statement report however, the chart of accounts dimension has more aggregations than is requiredfor the report. The controller wants to create a subset that has only the sub account and account elements

How should this be accomplished?

A. Use the Filter by Attribute function.

B. Use the Filter by Level function.

C. Use the Filter by Wildcard function.

D. Use the Filter by Element function.

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

The manufacturing department interacts with IBMCognosTM1 data using TM1 Perspectives. They want to view data by product and location. Products are on the rows of the analysis and plants are on the columns. Products are consolidated into categories and locations are consolidated into regions.

Which twointerfaces allow them to expand and collapse on both the rows and columns of the analysis? (Choose two.)

A. Active Form

B. Cube Viewer

C. In-Spreadsheet Browser

D. Excel Slice

A user requires the use of the "Insert Subset" operation to create a user-defined consolidation in the TM1 Subset Editor. Which TM1 user interface would be used to do this?

A. TM1 Contributor

B. TM1 Websheet

C. TM1 Explorer

D. TM1 Web Cube Viewer

Click the Exhibit button.

Referring to the exhibit, you are asked to allocate overhead expenses to the budget. Currently everything is set to zero. You are instructed toallocate $100,000 to the Communications budget and to distribute the amount equally across all months.

Which three TM1 data spreading operations will allow you to do this? (Choose three.)

A. Proportional Spread

B. Equal Spread and selecting the "Extend Right" checkbox

C. Relative Proportional Spread

D. Equal Leaves Spread and selecting the "Apply to All Leaf Cells" radio button

E. Relative Percent Change

A user wants to update a TM1 cube with string data from an Excel spreadsheet Which TM1 Excel function will allow you to do this?

A. DBRW

B. DBSW

C. DBSS

D. DBS

You are asked to prepare next year's budget for your organization. Because of budgetary pressures for the new year, you are instructed to copy last year's budget into the new year and reduce it by 5%. The TM1 cube you are using contains last year's budgetary data and the new year element has been added.

Which two TM1 data spreading operations will allow you to do this? (Choose two.)

A. Proportional Spread followed by Percent Change

B. Relative Percent Adjustment

C. Relative Proportional Spread followed byPercent Change

D. Relative Proportional Spread followed by Relative Percent Adjustment