IBM C2020-612 Online Practice Questions and Exam Preparation

IBM C2020-612 Online Questions & Answers

• Question 1:

  In Report Studio, an author merges Query1 and Query2 intoone result set (Query3) using a Union set operator. Query1 contains two data items: Order method and Revenue. Query2 also contains two data items: Product line and Quantity sold. The author wants to display the data from Query3 in a list report. How can the author ensure that all the order method results appear together and all product line results appear together in the list report?

  A. The author must add a sort key data item directly to Query3.
  B. The author must sort the Order method data item in Query1 and the Product line data item in Query2.
  C. The author must sort the data item in the Query3 that retrieves both Order method and Product line data.
  D. The author must add a sort key data item to Query1 and to Query2, and then add this sort key dataitem to Query3.
  D. The author must add a sort key data item to Query1 and to Query2, and then add this sort key dataitem to Query3.

• Question 2:

  In Report Studio, an author creates a report using Package A. Users should be able to drill through to target reports created for this package. What must the author do?

  A. Enablepackage drill-through behavior for the report.
  B. Add this report as a source report for each target created for the package.
  C. Add all drill-through definitions created for the package as targets for the source report.
  D. Add all drill-through definitions created for the package to the scope of the report.
  A. Enablepackage drill-through behavior for the report.

• Question 3:

  In Report Studio, an author wants to change the location of the legend in the chart report.

  What property will accomplish this?

  A. Auto Truncation
  B. Axis Assignment
  C. Absolute Position
  D. Relative Alignment
  C. Absolute Position

• Question 4:

  In Report Studio, an author creates the following report:

  

  The author wants the report to show the total revenue generated by each Product line. How can the author accomplish this?

  A. In Query Explorer, change the Rollup Aggregate Function property for the Revenue data item to Total.
  B. In QueryExplorer, change the Rollup Aggregate Function property for the Product line data item to Total.
  C. In the layout, group the Product line column and then add an aggregate row showing total revenue values.
  D. In the layout, group the Product type column and then add an aggregate row showing total revenue values.
  C. In the layout, group the Product line column and then add an aggregate row showing total revenue values.

• Question 5:

  InReport Studio, where can an author modify a global class to apply a change to all objects that use that class?

  A. Page Explorer
  B. Query Explorer
  C. Conditional Explorer
  D. Page Structure view
  A. Page Explorer

• Question 6:

  In Report Studio, when would the author need to unlock cells on a report?

  A. To merge two report types into a single report.
  B. To merge query items into a single column.
  C. To merge a query item into a text item.
  D. To merge report objects in table.
  B. To merge query items into a single column.

• Question 7:

  In Report Studio, a report contains several blocks and tables. To determine if there is sufficient space between objects, what will show how the report looks when it is generated?

  A. View a Print Preview.
  B. Hide the boundary lines.
  C. Unlock the report objects.
  D. Open the Page Structure view.
  B. Hide the boundary lines.

• Question 8:

  In Event Studio,which of the following tasks are available to a report author?

  A. Run an agent
  B. Run an export
  C. Run an import
  D. Run an index update
  A. Run an agent

• Question 9:

  In Report Studio, if an author adds a prompt to a report page containing a list, how can the author prevent an automatically generated prompt from appearing when the report runs?

  A. Add a Static Choice
  B. Specify a Default Selection
  C. Set the Auto-Submit property to Yes
  D. Change the Required property to No
  B. Specify a Default Selection

• Question 10:

  In Report Studio, when creating a list report, what is thedifference between creating a section and creating a header?

  A. Headers appear outside the list.
  B. Sections appear outside the list.
  C. Headers appear once at the top of the list.
  D. Sections appear once at the top of the list.
  B. Sections appear outside the list.