IBM C2090-620 Online Practice Questions and Exam Preparation

IBM C2090-620 Online Questions & Answers

• Question 11:

  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 12:

  In Report Studio, when should authors use a Generated Prompt?

  A. They only want the user to be able to choose one opton.
  B. They are unsure of the most appropriate prompt type to choose.
  C. They want to use the same prompt on a prompt page and a report page.
  D. They want the optons to be based on selectons made in another prompt.
  B. They are unsure of the most appropriate prompt type to choose.

• Question 13:

  The image below contains two rows of informaton above the column headers.

  

  How were these rows created?

  A. By using a table outside of the list
  B. By insertng list row cells in the list header
  C. By unlocking cells and insertng text items into the column header
  D. By using a block, padding and text items added to the overall header
  D. By using a block, padding and text items added to the overall header

• Question 14:

  In Report Studio, an author creates the following report:

  

  The author wants each row of this report to contain a column chart displaying quantty sold for a partcular product line. How can the author ensure that the chart in each row displays data for only the product line that appears in the same row?

  A. Add a column chart to the list, link the column chart to the same query used for the list and then add data to the chart.
  B. Add a column chart to the list, add data to the chart and then create a union relatonship between the queries for the list and the chart.
  C. Add a column chart to the list, add data to the chart and then create an intersect relatonship between the queries for the list and the chart.
  D. Add a column chart to the list, add data to the chart and then create a master-detail relatonship between the queries for the list and the chart.
  D. Add a column chart to the list, add data to the chart and then create a master-detail relatonship between the queries for the list and the chart.

• Question 15:

  In Report Studio, an author merges Query1 and Query2 into one 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 Quantty 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 data item to Query3.
  D. The author must add a sort key data item to Query1 and to Query2, and then add this sort key data item to Query3.

• Question 16:

  In Report Studio, a query contains the data item Product Line, which is grouped. Which of the following will add a page break for each Product Line?

  A. Create a secton on Product Line.
  B. Add a new page for each Product Line.
  C. Set the rows per page property to Product Line.
  D. Create a page set that is associated with the query.
  D. Create a page set that is associated with the query.

• Question 17:

  An author wants to create a report that displays certain list columns depending on the user's prompt selecton. What property of the list column must the author defne to create this variable?

  A. Text source variable
  B. String variable
  C. Style variable
  D. Render variable
  D. Render variable

• Question 18:

  In the report shown in the image,

  

  users click on the Retailer name in the lef and see the related data on the right. What is the technique used to create this report?

  A. Master-detail relatonship where the master and the detail is in a separate list
  B. Drill-through defniton where one column in a list drills through to a separate list in the same report
  C. Master-detail relatonship where the master and the detail is in the same list
  D. Drill-through defniton where one column in a list drills through to the same list in the same report
  B. Drill-through defniton where one column in a list drills through to a separate list in the same report

• Question 19:

  In Report Studio, which chart lets the report author plot a third measure?

  A. Area
  B. Bubble
  C. Scater
  D. Progressive Column
  B. Bubble

• Question 20:

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

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