IBM IBM Cogno C2090-620 Questions & Answers

• Question 11:

  In Report Studio, based on the crosstab below,

  

  which of the following is true?

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

  B. Quantty and Revenue are a child to Gross Proft.

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

  D. Sales territory is a peer of Order method.

  Correct Answer: A

• Question 12:

  In Report Studio, what is a baseline?

  A. A value in a list report that other values are compared against.

  B. A constant value that represents the x-axis in a chart.

  C. A constant value drawn on a chart to indicate major divisions in the data.

  D. A break point that keeps part of a report statonary while the user scrolls.

  Correct Answer: C

• Question 13:

  The sales department requires a report that numerically compares the gross proft generated for all product lines in each territory. In Report Studio, which is the most appropriate report type?

  A. List

  B. Chart

  C. Crosstab

  D. Map report

  Correct Answer: C

• Question 14:

  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.

  Correct Answer: B

• Question 15:

  An author wants to apply formatng 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 situaton, which of the following is true?

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

  B. Formatng all columns overrides formatng for an existng formated column in the list.

  C. Formatng all columns afects all subsequent objects added to the report page.

  D. Formatng all columns ensures any new columns added to the list will have the same formatng.

  Correct Answer: D

• Question 16:

  In Report Studio, an author wants to change the locaton of the legend in the chart report. What property will accomplish this?

  A. Auto Truncaton

  B. Axis Assignment

  C. Absolute Positon

  D. Relatve Alignment

  Correct Answer: C

• Question 17:

  In Report Studio, an author is using a relatonally modeled package and wants to flter a report to only include three specifc 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 flter expression?

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

  B. Use the Select Multple 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.

  Correct Answer: B

• Question 18:

  The following report was created in Report Studio using a relatonal package and shows revenue by sales rep, city, and country.

  

  What will the report show if the author creates a detail flter for Revenue>500,000 and applies the flter

  AFTER auto aggregaton?

  A. Only reps who generated total revenue greater than 500,000.

  B. Only cites that generated total revenue greater than 500,000.

  C. Only countries that generated total revenue greater than 500,000.

  D. Only reps who had individual sales transactons of greater than 500,000.

  Correct Answer: A

• Question 19:

  An author wants to create a flter on this report to only show Product line totals larger than 1 billion.

  

  What calculaton is used to create this flter?

  A. Detail flter as: [Total (Revenue)] for [Product line] >1000000000Applicaton = Afer auto aggregaton

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

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

  D. Summary flter as: [Total(Revenue)] for [Product line]>1000000000)Applicaton = Afer auto aggregaton

  Correct Answer: C

• Question 20:

  In Report Studio, why would an author create Statc Choices for a prompt?

  A. To provide prompt optons that are not found in the data source.

  B. So that the prompt appears with an opton selected by default.

  C. To provide default values to satsfy a parameter so a prompt page will not appear.

  D. So that the items that appear in the prompt depend on items selected in another prompt.

  Correct Answer: A