File Info
| Exam | IBM Cognos TM1 10.1 Analyst |
| Number | C2020-701 |
| File Name | IBM.C2020-701.PassCertification.2019-02-06.33q.vcex |
| Size | 188 KB |
| Posted | Feb 06, 2019 |
| Download | IBM.C2020-701.PassCertification.2019-02-06.33q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
A user has created a Sandbox based on a cube view. The user wants to have the Sandbox data saved as the base information. What should the user do?
- Save the View but click File > Save As.
- Click the Save View button.
- Recalculate the data then click Save.
- Commit the data to the cube.
Correct answer: D
Question 2
You need to calculate the possible 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?
- Use Slice to Excel and change all values there.
- Create a named Sandbox and change all values there.
- Use Snapshot to Excel and change all values there.
- Create a named scenario and change all values there.
Correct answer: B
Question 3
A user wants to interactively stack and unstack dimensions to view. What are two ways to accomplish this? (Choose two.)
- Use an Excel slice generated from TM1 Cube Viewer.
- Use TM1 Cube Viewer.
- Use In-Spreadsheet Browser.
- Use an Active Form generated from TM1 Cube Viewer.
Correct answer: BC
Question 4
What data spreading options are available to users in the Perspectives or Architect Cube Viewer? (Choose two.)
- Repeat
- Straight Line
- Increase
- Decrease
Correct answer: AB
Question 5
A user wants to create a TM1 Excel report using the DBRW function. What are two ways to reference the elements in the dimensions? (Choose two.)
- Use an Element Name,
- Use an Element Attribute,
- Use an Element Alias.
- Use an Element Index.
Correct answer: AC
Question 6
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?
- Create a filtered subset for products with the option TopSum.
- Create a view filter with the option TopSum.
- Create a filtered subset for products with the option TopCount,
- Create a view filter with the option TopCount.
Correct answer: D
Question 7
Which two options allow the 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)
- Active Form
- TM1 Web Cube View
- Websheet
- TM1 Dynamic View
Correct answer: AB
Question 8
When using the suppress zero option in a cube view, data that is in an aggregated or calculated value but still zero will display as what?
- Highlighted in blue
- Zeros
- Hidden
- Bold text
Correct answer: C
Question 9
Which three statements are true regarding TM1 Excel functions? (Choose three.)
- The VIEW function creates an optimized view of the cube specified by the cube argument.
- The DBR function stands for Database Read.
- The value returned by the DBRA function cannot be edited.
- ELCOMP returns the name of a child of a consolidated element in a specified dimension
- SUBNM returns the element of a dimension subset and allows a double-click to bring up the subset editor.
Correct answer: ADE
Question 10
What are three reasons why you would choose an Active Form over other report styles? (Choose three.)
- When the user needs to drill down and drill up on rows
- When the user needs to drill down and drill up on columns
- When the user needs to suppress zeros
- When there is a need to dynamically format cells
- When the user needs to move dimensions around the report
Correct answer: ACD
