COG-612 Exam Questions

An author wants to create a report that displays certain list columns depending on the user's prompt selection. What property of the list column must the author define to create th...

In Report Studio, a block object contains a text item in the page header. If the author reuses the block in the page footer, which of the following is true?

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

In Report Studio, which report outputs can produce a bookmark?

In Report Studio, what must an author create to let users view a report as either a list, a crosstab, or a chart?

In the image below, the last column calculates the percentage that each Product type contributed to the overall revenue. What is the calculation in the last column?

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?

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

An author wants to create a filter on this report to only show Product line totals larger than 1 billion. What calculation is used to create this filter?

The following report was created in Report Studio using a relational package and shows revenue by sales rep, city, and country. IBM COG-612 Exam What will the report show if the au...

In Report Studio, an author is using a relationally modeled package and wants to filter a report to only include three specific products. If the author is not sure how to spell the...

In Report Studio, an author wants to change the location of the legend in the chart report. What property will accomplish this?

An author wants to apply formatting to a list report. In Report Studio, the author clicks a column in the list, clicks Select Ancestor, and then clicks List Columns. In this situat...

In Report Studio, what is true about a crosstab node?

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

In Report Studio, what is a baseline?

IBM COG-612 Exam In Report Studio, based on the crosstab below, which of the following is true?

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

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

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

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

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?

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?

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

In Report Studio, an author edits the SQL statement that a query uses to retrieve data for a crosstab. After editing the SQL, the author wants to add a new data item to the query....

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

In Report Studio, an author wants to conditionally format a list report according to the revenue generated by each product line. The Revenue data item does not appear in the list r...

In Report Studio, an author creates a list report containing columns for Staff Name, Order number, and Revenue. The author wants to burst this report to various sales staff members...

Which statement is true about using a burst key to burst reports?

An author creates a report for bursting. In Report Studio, the author sets the burst type for the report to Directory entries. In Cognos Connection, the author sets the run options...

In Report Studio, when would the author need to unlock cells on a report?

In Report Studio, an author creates a report using Package A. Users should be able to drill through to target reports created for this package. What must the author do?

In Report Studio, which variable requires the author to create values?

In Report Studio, an author wants the report title to appear in the language in which the report is run. What property of the report header must the author define to create this va...

IBM COG-612 Exam In Report Studio, an author creates a weekly sales report and modifies the global class settings in the report. Which reports will this modification affect?

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

In Report Studio, when creating a list report, what is the difference between creating a section and creating a header?

In Report Studio, for which task would an author create a query calculation?

The image below contains two rows of information above the column headers. IBM COG-612 Exam How were these rows created?

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

In the report shown, users click on the Product line link to navigate to the specific product line in the list below. Users can also click on the Top link to return to the Product...

In Report Studio, a report contains several blocks and tables. To determine if there is sufficient space between objects, what will show how the report looks when it is generated?

In the report shown in the image, users click on the Retailer name in the left and see the related data on the right. What is the technique used to create this report?

In Report Studio, where can an author modify a global class to apply a change to all objects that use that class?

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?

The following steps are used to create an agent in Event Studio. Which sequence logically orders the items from first to last?Add a task Schedule the agent Specify an event conditi...

In Event Studio, which of the following tasks are available to a report author?

In Event Studio, which definition best describes the event key?

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

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