Free Cheat-test Samples and Demo Questions Download
Adobe exams Adobe
Apple exams Apple
Avaya exams Avaya
Check Point exams Check Point
Cisco exams Cisco
Citrix exams Citrix
CIW exams CIW
CompTIA exams CompTIA
EC-Council exams EC-Council
EMC exams EMC
Exin exams Exin
Fortinet exams Fortinet
Hitachi exams Hitachi
HP exams HP
IBM exams IBM
Isaca exams Isaca
ISC exams ISC
Juniper exams Juniper
LPI exams LPI
McAfee exams McAfee
Microsoft exams Microsoft
Oracle exams Oracle
PMI exams PMI
Riverbed exams Riverbed
SNIA exams SAP
Sun exams SAS
Symantec exams Symantec
VMware exams VMware
All certification exams

Cognos BI0-112 Exam -

Free BI0-112 Sample Questions:

1. 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.
Answer: B

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.
Answer: B

3. The sales department requires a report that numerically compares the gross profit 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. Repeater
Answer: C

4. 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.
Answer: D

5. In Report Studio, what is a 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.
Answer: C

6. In Report Studio, which chart lets the report author plot a third measure?
A. Area
B. Bubble
C. Scatter
D. Progressive Column
Answer: B

7. 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
Answer: C

© 2014, All Rights Reserved