Vcehome > IBM > IBM Certified Designer IBM Cognos Analytics Author V11 > C2090-621 > C2090-621 Online Practice Questions and Answers

C2090-621 Online Practice Questions and Answers

Questions 4

A report author has added a Button Bar control to an Active Report that allows users to view data for different regions. The report author now wants to make it possible for users to filter the report on multiple regions at once.

What should the report author do?

A. Use the Static version of the Button Bar control.

B. Use the Data-driven version of the Button Bar control.

C. Convert the Button Bar control to a Check Box Group control.

D. Convert the Button Bar control to a Radio Button Group control.

Browse 104 Q&As
Questions 5

A company would like to implement their own corporate style across all reports using a single Report as a reference. A requirement is to display the year of the data selected in the report in the header. The year is not being resolved correctly as shown below: How can the problem with this report be resolved?

A. The component reference has to be overwritten with a new defined "My Header Title" inside the new report.

B. The component reference has to be overwritten with a new defined "MyYear Singleton" inside the new report.

C. A component reference cannot contain a Singleton. The "Corporate Layout Reference" report has to be changed.

D. A component reference cannot contain a Singleton. The reference cannot be used and the header has to be created manually.

Browse 104 Q&As
Questions 6

A report author is building an Active Report for disconnected mobile use only.

Which technique can be used while ensuring the Active Report is fully offline capable?

A. Creating a drill-through to a different PDF report.

B. Setting a default value for a variable in the Active Report.

C. Using an iFrame within the Active Report to another report.

D. Adding a search and select prompt on a prompt page for the report consumer to filter the report on the iPad offline.

Browse 104 Q&As
Questions 7

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.

Browse 104 Q&As
Questions 8

A report author has to create a Crosstab report with Region and Product data in the rows of the Crosstab. The Crosstab can be created in two different ways as shown below.

Which Crosstab/Crosstabs is/are discontinuous Crosstab/Crosstabs?

A. Crosstab A

B. Crosstab B

C. Crosstab A and Crosstab B

D. neither Crosstab A nor Crosstab B

Browse 104 Q&As
Questions 9

A report author wants to display Revenue and Quantity by Product line in one chart and use a combination chart. A bar chart is used for revenue and a line chart for quantity. While the bar chart is clear and easy to understand, the lines are almost missing and are different to read.

What can be done to solve the problem?

A. Use a conditional scale.

B. Build two charts next to each other.

C. Map Quantity to a y axis with a different scale.

D. Multiply Quantity by 1000000 and set the scale to -6 to display.

Browse 104 Q&As
Questions 10

A company has a Product Returns report. The Return Comments query item is present in the list query but was left out of the list due to space constraints on the report page. The users have asked to see this information interactively.

How could the report author add this functionality with only minimal changes to the existing report?

A. Add HTML Items to the Product Name cell that use Report Expression to assign [Return comments] to HTML span title.

B. Add Product Description as a list column and use the Render Variable property and a prompt to conditionally render the column.

C. Add a Drill-through definition to the Product name cell and set the Target to Label and Data Item to the [Return comments] query item.

D. Insert a master-detail single row microchart to the Product column cell with transparency on and chart Tooltips property set to Absolute.

Browse 104 Q&As
Questions 11

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. Make the size of both Charts a percentage of the page width.

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

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

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

Browse 104 Q&As
Questions 12

A company has upgraded all of the models and packages to use Dynamic Query Mode (DQM). 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 against multiple packages.

B. The report author can add multiple packages as Data sources and write the report appropriately.

C. The report author must use SQL nodes for all queries that reference the different query subjects and join them appropriately to get the desired results.

D. The report author must use one SQL node of the queries and the package for the other query and join them appropriately to get the desired results.

Browse 104 Q&As
Questions 13

A report author wants to provide a filter in a report on a data item that has a very large number of distinct values and the users may not know the complete names of the district values.

What type of prompt should be used?

A. Value prompt

B. Text box prompt

C. Generated prompt

D. Select and search prompt

Browse 104 Q&As
Exam Code: C2090-621
Exam Name: IBM Cognos Analytics Author V11
Last Update:
Questions: 104 Q&As

PDF

$49.99

VCE

$59.99

PDF + VCE

$67.99