C2090-621 sample questions

Question 1

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?

Accepted Answer

To the right of Region using a vertical drop zone.

Answer

Below Region using a horizontal drop zone.

Answer

Above Region using a horizontal drop zone.

Answer

To the left of Region using a vertical drop zone.

Question 2

The sales department has requested a change to a tabular account report and wants to be able to analyze the monthly amount of each Account name by Year. The report author changed the original report on left to the report on the right.

How was this done?

Accepted Answer

Select Year column and then use the toolbar button Convert to Crosstab.

Answer

Select Year column and then use the toolbar button Pivot List Crosstab.

Answer

Select Amount(month) column and then use the toolbar button Convert to Crosstab.

Answer

Select Account name column and then use the toolbar button Pivot List To Crosstab.

Question 3

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?

Accepted Answer

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

Answer

Default selections are missing in the Value prompt.

Answer

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

Answer

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

Question 4

A customer wants to report the product types with the largest average revenue. In addition, the total revenue should be shown and all product types with revenue less than three percent (>3%) in a single bar.

Targeting this result:

How can this be done?

Accepted Answer

Using the property “summarize small items” on the chart, the type total and setting the item label. Set the order on the default measure.

Answer

Using a visualization, because it is not possible in the default chart engine.

Answer

Using the property “summarize small items” on the chart, the type average and setting the item label. Set the order on the chart node member.

Answer

Writing a new query where you summarize the Product types and create a new “My small value” item based on the calculated average. Order the values in the query.

Question 5

You have a list report showing customer details. You need to add a microchart to each row that visualizes the customer's sales trend over the last 12 months. This requires a separate, more detailed query than the main customer list query. How do you configure the report so that each microchart is filtered for the specific customer in its row? ```mermaid flowchart LR A[Customer List Query (CustID, CustName)] --> B{List Report} C[Sales Trend Query (CustID, Month, Sales)] --> D{Microchart} B --> E((Final Report Row 1: Cust A, Chart A Row 2: Cust B, Chart B)) D --> E ```

Accepted Answer

Select the microchart object after placing it in the list and define a Master-Detail Relationship, linking the list query's Customer ID to the chart query's Customer ID.

Answer

Join the two queries in the Query Explorer using Customer ID.

Answer

Create a drill-through from the customer name to the microchart.

Answer

Use a repeater object instead of a list and place the chart inside it.

Question 6

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?

Accepted Answer

Map Quantity to a y axis with a different scale.

Answer

Use a conditional scale.

Answer

Build two charts next to each other.

Answer

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

Question 7

A report author wants to enhance a report by having the ability to display the data by region and filter by Order method (where Order method includes: Email, Fax, Post, Sales rep, Promo, Phone, Web site).

How can this be accomplished?

Accepted Answer

Select On-demand toolbar > Select checkbox group > Add default values

Answer

Select Button Bar control > Go to properties > Change User interface to checkbox

Answer

Create a parameterized filter from the order_method > Manually populate the parameterized

Answer

Select the Button Bar control > From the on-demand toolbar > Click the ellipsis > Point to convert control > Click check box group

Question 8

A report author has created a report as shown below: What has been defined during the building of this report?

Accepted Answer

List, Crosstab, Header, Microchart

Answer

Section, Singleton, List, Chart, Crosstab

Answer

Crosstab, Master detail relationship, Microchart, Section

Answer

List, Crosstab, Master detail relationship, Section, Microchart

Question 9

How can a report author ensure that a report changes automatically when rotating a mobile device between Landscape and Portrait views?

Accepted Answer

Size the object as a percentage of the available space.

Answer

Set all objects to Portrait views.

Answer

Set all report objects to Portrait aware.

Answer

Set the Mobile alignment property to Automatic.

Question 10

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?

Accepted Answer

Right click the column header and unlock the cell.

Answer

Insert a block into the column header.

Answer

Modify the column header properties and unlock it.

Answer

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

C2090-621 IBM Cognos Analytics Author V11 Practice Questions

Create an account to continue.

Create an account to continue.

Related exams