IBM IBM Certified Specialist C2020-701 Questions & Answers

• Question 41:

  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.

  Correct Answer: ADE

• Question 42:

  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.

  Correct Answer: D

• Question 43:

  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

  Correct Answer: AB

• Question 44:

  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.

  Correct Answer: AC

• Question 45:

  A user wants to interactively stack and unstack dimensions to view.

  What are two ways to accomplish this? (Choose two.)

  A. Use an Excel slice generated from TM1 Cube Viewer.

  B. Use TM1 Cube Viewer.

  C. Use In-Spreadsheet Browser.

  D. Use an Active Form generated from TM1 Cube Viewer.

  Correct Answer: BC

• Question 46:

  What data spreading options are available to users in the Perspectives or Architect Cube Viewer? (Choose two.)

  A. Repeat

  B. Straight Line

  C. Increase

  D. Decrease

  Correct Answer: AB

• Question 47:

  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.

  Correct Answer: B

• Question 48:

  A user has created a Sandbox based on a cube view. The user wants to have the Sandbox data savedas the base information.

  What should the user do?

  A. Save the View but click File > Save As.

  B. Click the Save View button.

  C. Recalculate the data then click Save.

  D. Commit the data to the cube.

  Correct Answer: D

• Question 49:

  A user is a member of four security groups: A, B,C, and D. For the Budgetcube, group A has WRITE access, group B has READ access, group C has RESERVE access, and group D has a NONE access level.

  Which access level will the user have to the Budget cube?

  A. WRITE

  B. READ

  C. RESERVED

  D. NONE

  Correct Answer: C

• Question 50:

  A userentering numerical data into TM1 Application Web places a hold consolidate on North America with three children: Canada, USA, and Mexico. At the time the hold is placed, the value of North America is $30.00, with each child value set at $10.00. A user subsequently adds $10.00 to the value of Canada.

  Which statement is correct?

  A. "North America" increases $10.00, "USA" and "Mexico" remain unchanged.

  B. "North America" remains unchanged. "USA" and "Mexico" are reduced by $5.00 each.

  C. "North America" remains unchanged, "USA" is reduced by $10.00, "Mexico" remains unchanged.

  D. All values are on hold, so the add function is ignored.

  Correct Answer: B