IBM C2020-701 Online Practice Questions and Exam Preparation

IBM C2020-701 Online Questions & Answers

• Question 1:

  A user would like to export data from a TM1 Web Cube View so that subsequent data changes on the TM1 server will not affect the exported data. Which two export options should the user select? (Choose two.)

  A. Slice to Excel
  B. Snapshot to Excel
  C. Export to PDF
  D. Slice to Active Form
  B. Snapshot to Excel
  C. Export to PDF

• Question 2:

  What are three reasons why you would use Cognos BI Reporting rather than TM1 Web? (Choose three.)

  A. You must merge data from different cube sources.
  B. You require bursting of reports.
  C. You require different report versions.
  D. You require data entry capability.
  E. You require highlight capability for reports.
  A. You must merge data from different cube sources.
  B. You require bursting of reports.
  C. You require different report versions.

• Question 3:

  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
  C. DBSS

• Question 4:

  A TM1 Application Web user has completed data input. Which action allows the user to lock the data for review?

  A. Commit
  B. Save
  C. Release ownership
  D. Submit
  D. Submit

• Question 5:

  What must a TM1 Application Web user do to perform what-if analysis on budgetamounts, without affecting the current version of the data?

  A. Export to Cognos Insight.
  B. Create a Sandbox.
  C. Slice to Excel.
  D. Create a scenario.
  B. Create a Sandbox.

• Question 6:

  In TM1 Cube Viewer, you are viewing an Income Statementcube containing dimensions for Department, Months, Budget Version, and Account. Currently, the Account dimension is listed in the rows and the Months dimension is listed in the columns. You want to see a comparison of each element in the Budget Version dimension next to each account.

  Which feature in TM1 Cube Viewer will accommodate this requirement?

  A. Personal Workspace
  B. Sandbox
  C. Stacking dimensions
  D. Layout Right to Left
  C. Stacking dimensions

• Question 7:

  Which three statements are true when using the Print Report wizard? (Choose three.)

  A. Print Report can be scheduled.
  B. Print Report can be used to print for multiple elements in a title dimension.
  C. Print Report can be used to convert DBRW formula to values.
  D. Print Report can print to e-mail.
  E. Print Report can print to PDF.
  B. Print Report can be used to print for multiple elements in a title dimension.
  C. Print Report can be used to convert DBRW formula to values.
  E. Print Report can print to PDF.

• Question 8:

  A company usesExcel workbooks to access IBM Cognos TM1 data over a wide area network. The company needs to improve the performance of their Excel workbooks which contain multiple slices from multiple TM1 cubes. Which two changes will improve performance? (Choose two.)

  A. Convert all DBR() functions to DBRW() functions.
  B. Make all DBRW() functions reference a single VIEW function.
  C. Convert all DBRA() functions to DBRW() functions.
  D. Convert all DBRW() functions to DBR() functions.
  A. Convert all DBR() functions to DBRW() functions.
  C. Convert all DBRA() functions to DBRW() functions.

• Question 9:

  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
  C. In the column dimensions

• Question 10:

  A user wants to createa TM1 Excel report using the DBRW function.

  What are two ways to reference the elements in the dimensions? (Choose two.)

  A. Use an Element Name,
  B. Use an Element Attribute,
  C. Use an Element Alias.
  D. Use an Element Index.
  A. Use an Element Name,
  C. Use an Element Alias.