IBM C2020-701 Online Practice Questions and Exam Preparation

IBM C2020-701 Online Questions & Answers

• Question 11:

  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. Create an Active Form from within TM1 Cube Viewer.
  D. Select In-Spreadsheet Browser from within TM1 Perspectives.
  E. Create an Excel Slice from within TM1 Cube Viewer.

• Question 12:

  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
  D. Filter-based Dynamic Subset

• Question 13:

  Whywould you use Rebuild over Recalc in an Active Form?

  A. When a conditional format on a report changes
  B. When metadata is added to the TM1 model that must be displayed on the row
  C. When data changes along the rows of a report
  D. When a leaf element is added to a consolidated element of a report
  B. When metadata is added to the TM1 model that must be displayed on the row

• Question 14:

  Whichthree statements are true in regards to the applications folder? (Choose three.)

  A. Application folders can be used to publish reports to TM1 Web.
  B. Application folders can be used to organize reports.
  C. Application folders can be used to store references to URLs.
  D. Application folders do not have any security.
  E. Application folders are not required for published TM1 Web reports.
  A. Application folders can be used to publish reports to TM1 Web.
  B. Application folders can be used to organize reports.
  C. Application folders can be used to store references to URLs.

• Question 15:

  A user has invoked the Slice option in a TM1 Cube Viewer. Which TM1 Excel function is generated in each of the data cells?

  A. DBS
  B. DBR
  C. DBRW
  D. SUBNM
  C. DBRW

• Question 16:

  Using TM1 Application Web, which application is required to create a bottom-up, submission-based workflow with the ability to lock data aftersubmission?

  A. Approval
  B. Responsibility
  C. Central
  D. Managed
  A. Approval

• Question 17:

  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
  B. Only to the creator

• Question 18:

  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. The VIEW function creates an optimized view of the cube specified by the cube argument.
  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.

• Question 19:

  How do you configure aTM1 Administration Server to run as a Windows service?

  A. Usetm1sd.exe.
  B. Usetm1a.exe.
  C. Use tm1 admsd.exe.
  D. Edit the tmls.cfg file.
  C. Use tm1 admsd.exe.

• Question 20:

  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.
  B. The user does not first select the All function.