Limited Time Discount Offer
30% Off - Ends in 02:00:00

X

IBM C2090-620 Dumps

verified by experts

  • Verified by experts

C2090-620 Premium File

  • 50 Questions & Answers

$21.41

$14.99
IBM
IBM Cognos 10 BI Author
IBM
IBM Cognos 10 BI Author

Questions & Answers for IBM C2090-620

Showing 1-15 of 50 Questions

Question #1

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?

A. Report Studio creates a new query for the crosstab report.

B. Report Studio populates the crosstab with the four data items from the list.

C. Report Studio links the crosstab to the same query as the list report.

D. Report Studio automatically filters on data items that the list is filtered on.

Question #2

In Report Studio, based on the crosstab below,

which of the following is true?

A. Sales territory is a parent to Quantity and Revenue.

B. Quantity and Revenue are a child to Gross Profit.

C. Order method is a peer of Retailer type. Gross Profit is a child to all row and column headers.

D. Sales territory is a peer of Order method.

Question #3

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 situation,
which of the following is true?

A. Formatting all columns will also format aggregate rows in the list.

B. Formatting all columns overrides formatting for an existing formatted column in the list.

C. Formatting all columns affects all subsequent objects added to the report page.

D. Formatting all columns ensures any new columns added to the list will have the same formatting.

Question #4

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?

A. Positioning

B. Size & Overflow

C. Padding

D. Margin

Question #5

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

A. Insert a table.

B. Add a header or footer.

C. Pivot the list to a crosstab.

D. Modify the Spacing & Breaking property.

Question #6

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

A. Run an agent

B. Run an export

C. Run an import

D. Run an index update

Question #7

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 contains two data items: Product line and Quantity sold. The author wants to display
the data from Query3 in a list report. How can the author ensure that all the order method
results appear together and all product line results appear together in the list report?

A. The author must add a sort key data item directly to Query3.

B. The author must sort the Order method data item in Query1 and the Product line data item in Query2.

C. The author must sort the data item in the Query3 that retrieves both Order method and Product line data.

D. The author must add a sort key data item to Query1 and to Query2, and then add this sort key data item to Query3.

Question #8

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?

A. percentage ([Revenue])

B. percentage ([Revenue] for Product type)

C. percentage ([Product type] for [Revenue])

D. percentage ([Product type])

Question #9

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?

A. Detail filter as: [Total (Revenue)] for [Product line] >1000000000Application = After auto aggregation

B. Detail filter as: [Total (Revenue)]>1000000000Scope = Product line

C. Summary filter as: [Total(Revenue)]>1000000000Scope = Product line

D. Summary filter as: [Total(Revenue)] for [Product line]>1000000000)Application = After auto aggregation

Question #10

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?

A. In Query Explorer, change the Rollup Aggregate Function property for the Revenue data item to Total.

B. In Query Explorer, change the Rollup Aggregate Function property for the Product line data item to Total.

C. In the layout, group the Product line column and then add an aggregate row showing total revenue values.

D. In the layout, group the Product type column and then add an aggregate row showing total revenue values.

Question #11

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

A. It contains at least one nested crosstab node.

B. It contains at least one crosstab node member.

C. It contains more than one nested crosstab node.

D. It can contain an empty crosstab node member.

Question #12

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

A. Area

B. Bubble

C. Scatter

D. Progressive Column

Question #13

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

A. To merge two report types into a single report.

B. To merge query items into a single column.

C. To merge a query item into a text item.

D. To merge report objects in table.

Question #14

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
product names, what is the fastest way to add the product names to the filter expression?

A. Use a value prompt to have users select the product names.

B. Use the Select Multiple Values feature to search for the product names.

C. Add the product names from the Source tab in the Available components pane.

D. Add the product names from the Data Items tab in the Available components pane.

Question #15

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?

A. All reports.

B. Reports created using the same package.

C. Reports created within the log on session.

D. Only the current report.

×