IBM C2090-620 Online Practice Questions and Exam Preparation

IBM C2090-620 Online Questions & Answers

• Question 1:

  In Report Studio, an author wants to conditonally format a list report according to the revenue generated by each product line. The Revenue data item does not appear in the list report but is contained in Query1. Which of the following must the author do in order to apply this conditonal formatng?

  A. Make the Revenue data item a property of Query1.
  B. Make the Revenue data item a property of the List object.
  C. Make the Revenue data item a property of the Page object.
  D. Make the Revenue data item a property of the Variable object.
  B. Make the Revenue data item a property of the List object.

• Question 2:

  In Report Studio, an author notces that the Revenue measure included in a list report has an Aggregate Functon property of Total. What does this property mean?

  A. If the Auto Group and Summarize property for the query is set to No, the list displays total revenue values for the lowest level of detail in the report.
  B. If the Auto Group and Summarize property for the query is set to Yes, the list displays total revenue values for the lowest level of detail in the report.
  C. If the Auto Group and Summarize property for the query is set to No, the list displays total revenue values for highest level of detail in the report.
  D. If the Auto Group and Summarize property for the query is set to Yes, the list displays total revenue values for highest level of details in the report.
  B. If the Auto Group and Summarize property for the query is set to Yes, the list displays total revenue values for the lowest level of detail in the report.

• Question 3:

  In Report Studio, an author edits the SQL statement that a query uses to retrieve data for a crosstab. Afer editng the SQL, the author wants to add a new data item to the query. How can the author add the data item?

  A. The author must convert the edited SQL back to a query object and then add the data item.
  B. The author must edit the SQL statement so that the query retrieves an additonal data item.
  C. The author must add the data item to the query from the package displayed on the Source tab.
  D. The author must add a query reference to the existng query and then add the data item to the referenced query.
  B. The author must edit the SQL statement so that the query retrieves an additonal data item.

• Question 4:

  In Report Studio, an author wants to use a join object to create a relatonship between two queries. Which of the following is true?

  A. The author can use a join object to create either an inner or outer join between the queries.
  B. The author can use a join object only if both queries contain data from OLAP data sources.
  C. The author can use a join object only if both queries contain data from relatonal sources that has not been modeled dimensionally.
  D. Both queries must contain the same number of data items, the data items must be compatble and must appear in the same order.
  A. The author can use a join object to create either an inner or outer join between the queries.

• Question 5:

  In Report Studio, an author creates a list report and adds four data items. The author then adds a crosstab to the report. Which of the following is true?

  A. Report Studio creates a new query for the crosstab report.
  B. Report Studio populates the crosstab with the four data items from the list.
  C. Report Studio links the crosstab to the same query as the list report.
  D. Report Studio automatcally flters on data items that the list is fltered on.
  A. Report Studio creates a new query for the crosstab report.

• Question 6:

  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 Functon property for the Revenue data item to Total.
  B. In Query Explorer, change the Rollup Aggregate Functon 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 7:

  Which statement about the tabular data retrieved by Report Studio queries is true?

  A. Tabular data includes a column for each data item in the query. No grouping is applied to the tabular data.
  B. Tabular data includes a column for each data item in the query. Grouping applied in the report layout is also applied to the tabular data.
  C. Tabular data can only include columns for data items that appear in the layout. No grouping is applied to the tabular data.
  D. Tabular data includes a column for each data item that appears in both the query and the layout. Grouping applied in the report layout is also applied to the tabular data.
  A. Tabular data includes a column for each data item in the query. No grouping is applied to the tabular data.

• Question 8:

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

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

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

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