IBM C2020-701 Online Practice Questions and Exam Preparation

IBM C2020-701 Online Questions & Answers

• Question 51:

  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.
  B. Use the Filter by Level function.

• Question 52:

  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.
  D. Column labels can be dynamic by using Excel functions.

• Question 53:

  Click the Exhibit button.

  

  In the cube shown in the exhibit, you need to show only the five most expensive products. The list should change dynamically with the selection of the budget version.

  How would you achieve this?

  A. Create a filtered subsetfor products with the option TopSum.
  B. Create a view filter with the option TopSum.
  C. Create a filtered subset for products with the option TopCount,
  D. Create a view filter with the option TopCount.
  D. Create a view filter with the option TopCount.

• Question 54:

  What is the differencebetween a TM1 Sandbox and a Personal Workspace?

  A. A Personal Workspace allows you to work in a private area where a Sandbox is shared.
  B. A Personal Workspace is a special default unnamed Sandbox where you begin your work.
  C. A Personal Workspace is shared.
  D. A Personal Workspace does not require you to commit your data as a Sandbox does.
  B. A Personal Workspace is a special default unnamed Sandbox where you begin your work.

• Question 55:

  An end user wants to interactively create a temporary consolidation that does not exist within the dimension using the TM1 Cube Viewer. Which action will accomplish this?

  A. Create a user defined subset and the roll up takes place automatically.
  B. Create a user defined subset and use the Roll Up function.
  C. Create a roll up set and insert into a user defined subset.
  D. Create a roll up set and insert into a dynamic subset.
  B. Create a user defined subset and use the Roll Up function.

• Question 56:

  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
  B. Cube Viewer
  C. In-Spreadsheet Browser

• Question 57:

  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
  B. Weight
  C. Type
  E. Attribute

• Question 58:

  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
  C. Relative Proportional Spread followed byPercent Change
  D. Relative Proportional Spread followed by Relative Percent Adjustment

• Question 59:

  The human resources department requires a TM1 Web Labor Detail report which shows Total Salary, Benefits, and Taxes for each employee within a selecteddepartment. The user should be able to select a department and have the rows of the report display just the employees in that department with the costs across the columns. Employees should be sorted in descending order based on Total Salary. UnfortunatelySalary, Benefits, and Taxes are all stored in different cubes and the cubes only share the Employee and Department dimensions.

  How should you build the Labor Detail report?

  A. Use three slices, one for each of the source cubes and combine using Excel formulas.
  B. Use one slice with zero suppression for Salary and two snapshots for the other cubes.
  C. Use an Active Form.
  D. Use the In-Spreadsheet Browser.
  C. Use an Active Form.

• Question 60:

  When exporting a cube view from TM1 Web, which prerequisite is required to ensure charts are included?

  A. DoJo 1.6
  B. Java Runtime Engine(JRE)
  C. Microsoft Excel
  D. Adobe Acrobat
  C. Microsoft Excel