Exam Code: C2021-701 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: IBM Cognos TM1 10.1 Analyst
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2021-701 Exam.
2021 May C2021-701 Study Guide Questions:
Q21. A cube called Salary has two dimensions: Employee and Time. Using cube security, the security group Executive is assigned READ access to the Salary cube. Using element security, the security group Executive is assigned WRITE access to all elements of the Employee dimension.
Using element security, the security group Executive is assigned WRITE access to only 1 element, July, and READ access to all other elements in the Time dimension.
A user of the security group Executive willhave which access level when viewing the Salary cube?
A. WRITE access to July cells only
B. WRITE access to all cells
C. READ access to all cells
D. READ access to July cells only
Answer: C
Q22. 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.
Answer: D
Q23. 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.
Answer: B
Far out C2021-701 free practice exam:
Q24. You need to calculate a ratio on all levels in IBM Cognos Insight. Which action would you take?
A. Create a calculation for C and N elements.
B. Create a calculation and set the calculation order to Summarize First.
C. Create a calculation for all elements.
D. Create a calculation and set the calculation order to Calculate First.
Answer: B
Q25. Whenever you open the Salescube you see a hierarchical list of all products. The default view consists of default subsets for all dimensions. You would like to see a list of 10 products you are responsible for by default.
Which three actions would achieve this? (Choose three.)
A. Create a private default subset for the product dimension and leave the default view unchanged.
B. Create a private default subset for the product dimension and leave the default view unchanged,
C. Create a private named subset for the product dimension and create a private named view using it.
D. Create a private named subset for the product dimension and create a private default view using it.
E. Create a private default subset for the product dimension and create a private default view using it.
Answer: A,D,E
Q26. 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.
Answer: C
High value C2021-701 questions pool:
Q27. When publishing a IBM Cognos Insight workspace to servers, which three actions can you perform? (Choose three.)
A. Publish to a TM1 server as an Excel Report.
B. Publishto a TM1 server as a Responsibility Application.
C. Publish to a TM1 server as a Central Application.
D. Publish to a Cognos 10 B1 server as crosstab reports.
E. Publish to a Cognos 10 B1 server as PowerPlay cubes.
Answer: B,C,D
Q28. 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
Answer: C
Q29. 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
Answer: A,B
Q30. There has been a number of requests by users to have an option to easily select quartersfor their views, rather than having to select the individual quarters every time they go into their views.
Which solution meets this requirement?
A. A new public view should be created.
B. A new private subset should be created.
C. A new public subsetshould be created.
D. A new alias should be created.
Answer: C