C2020-701 Online Practice Questions and Answers

You have entered new planning data into a TM1 Model and all figures are blue. Which statement is correct?

A. The numbers are in the base cube andneed to be submitted before seen by others.

B. The numbers are in the base cube and need to be committed before seen by others.

C. The numbers are in a Personal Workspace and need to be committed before seen by others.

D. The numbers are in a Personal Workspace and need to be saved before seen by others.

A user wants to create a view looking at a particular product called "101 - Chips". They use the "Filter by Wild Card' function to locate the product, but no elements are returned.

Which statement describes what is happening?

A. The user does not firstselect the Hierarchy Sort function.

B. The user does not first select the All function.

C. The user did not first select the Reload Subset function.

D. The user should be using Filter by Level function.

A user wants to update TM1 data within a Microsoft Excel worksheet. What are the three ways to do this? (Choose three.)

A. Create an Active Form from within TM1 Cube Viewer.

B. Createa Snapshot from within TM1 Cube Viewer.

C. Create a Sandboxfrom within TM1 Cube Viewer.

D. Select In-Spreadsheet Browser from within TM1 Perspectives.

E. Create an Excel Slice from within TM1 Cube Viewer.

A customer wants to be able to select elementsfrom a subset for a fixed number of columns. Which statement is correct?

A. Column labels are always static.

B. Column labels can be dynamic by using a dynamic subset.

C. Column labels can be dynamic by using a named subset.

D. Column labels can be dynamic by using Excel functions.

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

In Cognos Insight, users can perform which twofunctions? (Choose two.)

A. Import data,

B. Publish model.

C. Run scripts from an Action Button.

D. Generate an Excel slice.

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

An international company has an existing TM1 server application they use for planning, forecasting, and reporting. The corporate strategydepartment wants to share parts of this application with external consultants and partners. They decide to create Cognos Insight workspaces which includes data from this server application combined with additional analysis and content. They intend to distribute a single workspace ".cdd" file to the recipients.

How should they integrate the TM1 server data with additional content resulting in distributable Cognos Insight workspace files?

A. Connect to the server using Distributed Mode, save the workspace and then modify as needed.

B. Drag and drop TM1 cube views and subsets into the workspace, save the workspace and then modify as needed.

C. Connect to the server using Connected Mode, save the workspace and then modify as needed.

D. Import TM1 cube views and subsets, save the workspace and then modify as needed.

Auser would like to create a view showing the top 10 sales by region. Which type of subset would the user use to accomplish this?

A. Expression Base Subset

B. Static Subset

C. User Defined Subset

D. Filter-based Dynamic Subset

You need to calculate a ratio on all levels in IBM Cognos Insight. Which action would you take?

A. Create a calculation for C and N elements.

B. Create a calculation and set the calculation order to Summarize First.

C. Create a calculation for all elements.

D. Create a calculation and set the calculation order to Calculate First.