Exam 612 – IBM Cognos 10 BI Author

Sample test: The sample test is designed to give the candidate an idea of the content and format of the questions that will be on the certification exam. Performance on the sample test is NOT an indicator of performance on the certification exam. This should not be considered an assessment tool. (Answer key at the end)

1. In Report Studio, an author wants to ensure detailed report data is summarized using the

default aggregation specified in the package. Which of the following is true?

A. The Aggregate Function must be set to Total. B. The Aggregate Function property must be set to None. C. The Auto-Group and Summarize property must be set to No. D. The Auto-Group and Summarize property must be set to Yes.

2. In Report Studio, why would an author unlock a report?

A. To open a report saved locally in XML. B. To insert an object inside a list column. C. To apply conditional formatting. D. To view data that has been restricted in Framework Manager.

3. In Report Studio, an author wants to create a variable for a conditional block so the report

displays either a crosstab or a chart, depending on what the user selects in the prompt. What property of the conditional block must the author define to create this variable?

A. Style Variable B. Current Block C. Block Variable D. Render Variable

4. Sort Key is a data item in Query1, however, it is not part of the rendered report. What must

be done for the Sort Key data item to be applied to the report?

A. The Sort Key is added as a property of the list. B. The Sort Key is added as a property of the page. C. The Sort Key is added as a property of the query. D. The Sort Key is added as a property of the prompt.

5. The following report was created in Report Studio using a relationally modeled package.

How can the author change the report so that the quantity values for EACH product line show the AVERAGE quantities sold, not total which is currently displayed?

A. Define the Aggregate Function property as Average. B. Define the Roll up Aggregate Function property as Average. C. In Query Explorer, define the Auto Group & Summarize property as Average. D. Click the Quantity column, click the Aggregate button and then click Average.

ANSWERS: 1-D; 2-B; 3-C; 4-A; 5-A