Cognos Report Studio Questions
Q: 1 In Report Studio, Based on the crosstab below, which of the following
is true?
A: Sales territory is a parent to Quality and Revenue.
B: Quality and Revenue have a parent-child relationship.
C: Order method is a peer of Retailer type.
D: Sales territory is a peer of Order method.
Correct:A
Q: 2 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 must contain more than one crosstab node member.
Correct:B
Q: 3 The sales department require a report that numerically compares the gross
profit generated for all products lines in each territory. In Report Studio,
which is the most appropriate report type?
A: List
B: Chart
C: Crosstab
D: Repeater
Correct:C
Q: 4 An author wants to apply formatting to a list report, In report Studio, the
author clicks a column, 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 foe 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.
Correct:D
Q: 5 In Report Studio what is the baseline?
A: A value in a list report that other values are compared against.
B: A border in a crosstab that separates measures from aggregate totals.
C: A constant value drawn on a chart to indicate major divisions in the data.
D: A break point that lets you keep part of a report stationary while you
scroll.
Corrcet:C
Q: 6 In Report Studio, an author wants to change the location of the legend in
the chart report. What property will accomplish this?
A: Auto Truncation
B: Axis Assignment
C: Absolute Position
D: Relative Alignment
Correct:C
Q: 7 The following report was created in Report Studio using a relational
package and shows revenue by sales rep, city and country. What will the
report show if the author creates a detail filter for Revenue > 500,000
and applies the filter AFTER auto aggregation?
A: Only reprs who generated total revenue greater than 500,000.
B: Only cities that generated total revenue greater than 500,000.
C: Only countries generated total revenue greater than 500,000.
D: Only reps who had individual sales transactions of greater than 500,000.
Correct:A
Q: 8 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: Run the report with all product names and copy 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.
Correct:B
Q: 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)>1000000000
Application =After auto aggregation
B: Detail filter as: Total ([Revenue] for Product line)>1000000000
Scope = Product line
C: Summary filter as:[Revenue]>1000000000
Scope = Product line
D: Summary filter as:([Revenue] for Product line)>1000000000
Application =After auto aggregation
Correct:C
Q: 10 In Report Studio, which chart lets the report author plot a third measure?
A: Area
B: Bubble
C: Scatter
D: Progressive column
No comments:
Post a Comment