C2090-621 Online Practice Questions and Answers

An Active Report contains a data deck with the following values on multi select controls:

How many cards would be generated?

A. 5

B. 9

C. 14

D. 20

A report author has applied a Union set operation on two queries with the resultant query named Main_Query containing the data items: Product line, Order method/Region, Revenue and Unit Sale Price. The report author added the data items to the list, grouped on Product line and Order method/Region. The screenshot below shows the result:

What must the report author do for the report to look like the following?

A. Set the detail aggregation property to Automatic for each field.

B. Set the detail aggregation property to None for product line and order method. Total for Revenue. Average for Unit Sale Price.

C. Set the detail aggregation property to None for only Product Line and Order Method. Automatic for Revenue. Average for Unit Sale Price.

D. Set the detail aggregation property to Default for product line and Order method. Default for Revenue and Average for Unit Sale Price.

A report author created a crosstab as shown below:

The crosstab report, when run, shows the following data:

The author wants to split the revenue for each region by year. Where should the year data item be added?

A. Below Region using a horizontal drop zone.

B. Above Region using a horizontal drop zone.

C. To the left of Region using a vertical drop zone.

D. To the right of Region using a vertical drop zone.

A report author has created this join relationship:

The Order number by product query includes only orders that contain a specific product selected at run time.

What must the report author do to ensure that the joined query will only contain Order numbers that appear in both of the queries?

A. Select "+" from the Operator drop down list.

B. Select "=" from the Operator drop down list.

C. Select "in" from the Operator drop down list.

D. Select ">=" from the Operator drop down list.

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. Default selections are missing in the Value prompt.

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

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

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

A company would like to distribute reports to users via an email address or a directory entry. How should the burst table be defined for this to work appropriately?

A. Directory entries must not use the alternate path syntax.

B. The burst table can be an uploaded file and contain as many columns as needed.

C. The burst table must contain three columns (Recipient, Recipient type and Data item) to burst on.

D. The directory entry can use either the alternate path syntax or the internal search path using the CAMID.

A report author needs to verify that the cardinality is set correctly in order to properly group a list report. What is the correct setting?

A. 1:1 cardinality from left to right

B. 1:1 cardinality from right to left

C. 1:n cardinality from left to right

D. 1:n cardinality from right to left

A report author wants to create an Active Report with a Data deck that only prompts for Product line and Year. For each card created, the Order method type broken down by revenue should be shown.

What needs to be done to ensure the data on each card reflects the correct year and Product line?

A. Use a Repeater table in the Card deck.

B. Each card should have a separate query.

C. Filters should be copied from the Data deck to the cards.

D. Use a Master detail relationship between the cards and the Data deck.

A company is using a model that was created in Compatible Query Mode (CQM). There is a report that must reference query subjects from two different packages.

How can this be accomplished?

A. The report author cannot create reports that reference multiple Data sources.

B. The report author can add multiple packages to the reports as Data sources and create the report as needed.

C. The report author must use SQL nodes for all queries that reference the data items in the two packages and join them appropriately to get the desired results within the report.

D. The report author can use user-defined SQL to develop the query from one of the packages and the other package to develop the other query and then join them appropriately to get the desired results within the report.

A report author creates the following filter in a report:

[Region] in (`Americas','Asia Pacific')

Which type of filter was created?

A. Advanced

B. Combined

C. Parameterized

D. Custom based on data item

A report author would like to reuse a logo across all existing reports. Which object should be used?

A. Template

B. Bookmark

C. Global Class

D. Layout Component Reference

A report author wants to use a calculation which is not a string function to manipulate text. Which function can be used?

A. trim()

B. lower()

C. extract()

D. substring()

A report author needs the label in a List column title to be dynamic.

How can this be implemented with a dynamic value?

A. Pivot the List to a Crosstab.

B. Create a Master detail relationship to the data.

C. Unlock the report and insert a data item into the List column title.

D. Select the List column title and change the Source type to Data item label.

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> Add Page set> Associate the data item to the page.

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

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

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

Which file type can be uploaded in Cognos Analytics?

A. Fixed width text file.

B. Tab separated value text file.

C. Colon separated value text file.

D. Microsoft word document (.docx).