IBM C2020-701 Online Practice Questions and Exam Preparation

IBM C2020-701 Online Questions & Answers

• Question 21:

  You have imported a sales data Cognos Insight local cube. You have years, quarters, and months in different dimensions. However, for your business requirements, it would be better to have a one-time dimension. How would you change your model?

  A. Change the cube structure using the Group Dimension function.
  B. Create a new cube using the Group Dimension function.
  C. Change the cube structure using the Combine Dimension function.
  D. Create a new cube using the Combine Dimension function.
  B. Create a new cube using the Group Dimension function.

• Question 22:

  Which two options allowthe end user to expand and collapse dimensional elements listed on the row dimension of a given data view in TM1 Web "on-the-fly"? (Choose two)

  A. Active Form
  B. TM1 Web Cube View
  C. Websheet
  D. TM1 Dynamic View
  A. Active Form
  B. TM1 Web Cube View

• Question 23:

  A user working within a TM1 Web cube view needs to prevent a leaf cell from being changed by a spread operation. Which command would you use?

  A. Protect
  B. Hold
  C. Lock
  D. Reserve
  B. Hold

• Question 24:

  You need to calculate thepossible outcome if prices are raised. However, the data in the IBM TM1 server should not be overwritten. The IBM TM1 model contains many business rules and calculations but no scenario dimension, which is what you want.

  How do you proceed?

  A. Use Sliceto Excel and change all values there.
  B. Create a named Sandbox and change all values there.
  C. Use Snapshot to Excel and change all values there.
  D. Create a named scenario and change all values there.
  B. Create a named Sandbox and change all values there.

• Question 25:

  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. Proportional Spread
  B. Equal Spread and selecting the "Extend Right" checkbox
  D. Equal Leaves Spread and selecting the "Apply to All Leaf Cells" radio button

• Question 26:

  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.
  B. Create a calculation and set the calculation order to Summarize First.

• Question 27:

  When should you use the DBR formula over the DBRW formula?

  A. When you only want users to read the data
  B. When a cell must be calculated prior to beingreferenced
  C. When referencing a SUBNM formula
  D. When using Active Forms
  B. When a cell must be calculated prior to beingreferenced

• Question 28:

  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
  D. Tier 3: Data

• Question 29:

  A company wants to deploy an application of summary level data with drill through capability to the underlying transaction detail. Which interface should be used?

  A. Active Report
  B. TM1 Web
  C. Cognos Insight Connected
  D. Cognos InsightDisconnected
  B. TM1 Web

• Question 30:

  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.
  D. Import TM1 cube views and subsets, save the workspace and then modify as needed.