IBM Cognos 10 BI Author - C2090-620 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

The sales department requires a report that numerically compares the gross profit generated for all product lines in each territory. In Report Studio, which is the most appropriate report type?

A. Map report B. Crosstab C. Chart D. List

Discussion 0

Correct Answer: B Vote an answer

Question 2

In Report Studio, why would an author use the Page Structure view?

A. To add a new page to the report. B. To move objects in a report. C. To change the underlying query. D. To drive page layout using a query.

Discussion 0

Correct Answer: B Vote an answer

Question 3

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 Quantity sold. The author wants to display the datafrom 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 to Query1 and to Query2, and then add this sort key data item to Query3. B. The author must add a sort key data item directly to Query3. C. The author must sort the Order method data item in Query1 and the Product line data item in Query2. D. The author must sort the data item in the Query3 that retrieves both Order method and Product line data.

Discussion 0

Correct Answer: A Vote an answer

Question 4

In Report Studio, an author creates the following report: The author wants each row of this report to contain a column chart displaying quantity sold for a particular 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, add data to the chart and then create a master-detail relationship between the queries for the list and the chart. B. 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. C. Add a column chart to the list, add data to the chart and then create an intersect relationship 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 union relationship between the queries for the list and the chart.

Discussion 0

Correct Answer: A Vote an answer

Question 5

In Report Studio, what can an author do to organize list data into logical sections?

A. Modify the Spacing & Breaking property. B. Insert a table. C. Add a header or footer. D. Pivot the list to a crosstab.

Discussion 0

Correct Answer: C Vote an answer