C2090-620 by IBM Actual Free Exam Questions And Answers

Question 1

An author creates a report in Report Studio. The report contains a parameter for the Product line query item. The author wants to let users drill through to this report from a variety of reports created using the GO Data Warehouse (query) package. To ensure that this target report contains data for the appropriate products, the author wants to limit the report cells that users can drill through from in source reports. What must the author do when creating the drill-through definition?

A. Set the Product line query item as the scope of the drill-through definition.

B. Delete all data items except for the Product line query item from the drill-through definition.

C. Set the Product line query item as the target of the drill-through definition.

D. Add a parameter for the Product line query to the drill-through definition.

Discussion 0

Correct Answer: A Vote an answer

Question 2

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 3

In a Report Studio report, to add white space around text within a block, which of the following properties must be set to the block?

A. Padding

B. Margin

C. Positioning

D. Size & Overflow

Discussion 0

Correct Answer: A Vote an answer

Question 4

In Report Studio, why would an author create Static Choices for a prompt?

A. To provide prompt options that are not found in the data source.

B. So that the items that appear in the prompt depend on items selected in another prompt.

C. So that the prompt appears with an option selected by default.

D. To provide default values to satisfy a parameter so a prompt page will not appear.

Discussion 0

Correct Answer: A Vote an answer

Question 5

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 an intersect relationship between the queries for the list and the chart.

B. 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.

C. 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.

D. 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.

Discussion 0

Correct Answer: D Vote an answer

IBM Cognos 10 BI Author - C2090-620 Exam Practice Test

Contact Us

Useful Links

Latest Updated