IBM Cognos Analytics Author V11 (C2090-621) Free Practice Test

Question 1

A report author has the following filter in a report:
[Product line] in ?pline?
The report author adds a Value prompt based on the existing parameter 'pline'. After adding the prompt, the Auto-submit property is defaulted to 'No' and cannot be changed to 'Yes'.
What is the cause of this?

A. A prompt based on an existing parameter as Auto-submit cannot be made.

B. The Value prompt created based on the filter is a Multi-select prompt.

C. Auto-submit is a property that is only available for select and search prompts.

D. Default selections are missing in the Value prompt.

Correct Answer: B

Question 2

A report author is building a report intended for an iPad on the Cognos Mobile App. the report consists of two Charts that need to be side by side when the tablet is landscape and on top of each other when the tablet is landscape and on top of each other when the tablet is portrait.
What technique should be used to accomplish this?

A. Contain the Charts in two cells of the same table, with a fixed size.

B. Make the size of both Charts a percentage of the page width.

C. Use a conditional style on one of the Charts to adjust its position based on the orientation of the iPad.

D. Contain both charts in separate blocks, with fixed widths and box type set as inline.

Correct Answer: A

Question 3

A report author wants to create an Active Report with a chart that is dynamically rendered in the browser based on user selections.
How can this be accomplished?

A. A legacy chart with server side processing.

B. A Virtualization with client side processing.

C. A Virtualization with server side processing.

D. A legacy chart with client side processing.

Correct Answer: D

Question 4

A report author is asked to create a page break on a List.
What are the initial steps to be taken?

A. Click on Navigate> Click Report Pages> From Toolbox, and Page set to the Report pages pane> In properties pane, under DATA point the preferred query to the query list.

B. Select report> Click on properties> Select Report tab> Report options> Add page break> Associate the data item to the page.

C. Click on Navigate> Click Report Pages> Add Page set> Associate the data item to the page.

D. In the properties pane, under Data click Pages set> From the data items pane, drag the data item page break is based on.

Correct Answer: B

Question 5

How can an Uploaded file be combined with data from a database?

A. Create a Data module.

B. Nest a List using the Uploaded file with another List from a package.

C. Include the Uploaded file and a package as a Data source to the report.

D. Use a Master detail relationship.

Correct Answer: A

Question 6

A user is creating a join relationship in a Data module.
What benefit can be expected from setting a filter join?

A. The join relationship would work on multiple fields in each table.

B. The result set from the join would return less rows.

C. The result set from the join would return more rows.

D. The performance on the join could be improved.

Correct Answer: D

Question 7

A report author wants to reduce the number of columns in a list by moving the related information into a single column.
What is the first action that needs to be performed?

A. Modify the column header properties and unlock it.

B. Right click the column header and unlock the cell.

C. Insert a block into the column header.

D. Click on the more button on the Application bar to unlock the report.

Correct Answer: B

Question 8

A report author has been asked to create a report that needs to be distributed in PDF format. The report has to let users navigate quickly to a desired report page and information within the report.
How can this be accomplished?

A. Using a Hyperlink button.

B. Using a layout component reference.

C. Creating an Active Report.

D. Using drill-through definitions and bookmarks for navigation.

Correct Answer: D

Question 9

A company distributes a monthly email to the sales managers at the beginning of each month that shows how well they are doing using a tabular formatted report. The report is delivered in Excel format and the sales managers would like the report to be in a Crosstab format.
How should the report be changed?

A. Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Save the report.

B. Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Add a page set that is grouped on sales manager. Save the report.

C. Add a repeater to the report. Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Place the Crosstab within the repeater. Create a Master detail relationship between the Crosstab and the repeater on sales manager. Save the report.

D. Add a Crosstab data container to the report. Format and sort it appropriately. Delete the list data container and save the report.

Correct Answer: A

Question 10

A report author requires two conditional styles to be both of which are used on a column.
How can the order in which to evaluate the conditions be specified?

A. The order cannot be defined. All conditions are evaluated and combined in an "AND" logic.

B. By clicking a condition on a selected column and then clicking the move up or move down arrow.

C. The order in which the conditions are evaluated depends on the order of the underlying query item inside the query.

D. Go to the "Manage Conditional Styles@ menu and click the move up or more down arrow.

Correct Answer: A

Welcome to TestSimulate

IBM Cognos Analytics Author V11 (C2090-621) Free Practice Test