IBM IBM Certified Specialist C2020-701 Questions & Answers

• Question 1:

  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

  Correct Answer: C

• Question 2:

  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.

  Correct Answer: ADE

• Question 3:

  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.

  Correct Answer: B

• Question 4:

  You are asked to prepare next year's budget for your organization. Because of budgetary pressures for the new year, you are instructed to copy last year's budget into the new year and reduce it by 5%. The TM1 cube you are using contains last year's budgetary data and the new year element has been added.

  Which two TM1 data spreading operations will allow you to do this? (Choose two.)

  A. Proportional Spread followed by Percent Change

  B. Relative Percent Adjustment

  C. Relative Proportional Spread followed byPercent Change

  D. Relative Proportional Spread followed by Relative Percent Adjustment

  Correct Answer: CD

• Question 5:

  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.

  Correct Answer: BCD

• Question 6:

  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

  Correct Answer: D

• Question 7:

  An international company has an existing TM1 server application they use for planning, forecasting, and reporting. The corporate strategydepartment wants to share parts of this application with external consultants and partners. They decide to create Cognos Insight workspaces which includes data from this server application combined with additional analysis and content. They intend to distribute a single workspace ".cdd" file to the recipients.

  How should they integrate the TM1 server data with additional content resulting in distributable Cognos Insight workspace files?

  A. Connect to the server using Distributed Mode, save the workspace and then modify as needed.

  B. Drag and drop TM1 cube views and subsets into the workspace, save the workspace and then modify as needed.

  C. Connect to the server using Connected Mode, save the workspace and then modify as needed.

  D. Import TM1 cube views and subsets, save the workspace and then modify as needed.

  Correct Answer: D

• Question 8:

  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

  Correct Answer: C

• Question 9:

  When should you use the DBR formula over the DBRW formula?

  A. When you only want users to read the data

  B. When a cell must be calculated prior to beingreferenced

  C. When referencing a SUBNM formula

  D. When using Active Forms

  Correct Answer: B

• Question 10:

  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.

  Correct Answer: C