bi0-112 test questions
www.passguide.com/bi0-112.html
Which statement about the tabular data retrieved by Report Studio queries is true?
A. Tabular data includes a column for each data item in the query. No grouping is applied to the
tabular data.
B. Tabular data includes a column for each data item in the query. Grouping applied in the report
layout is also applied to the tabular data.
C. Tabular data can only include columns for data items that appear in the layout. No grouping is
applied to the tabular data.
D. Tabular data includes a column for each data item that appears in both the query and the
layout. Grouping applied in the report layout is also applied to the
Answer: A
In Report Studio, an author wants to conditionally format a list report according to the revenue
generated by each product line. The Revenue data item does not appear in the list report but is
contained in Query1. Which of the following must the author do in order to apply this conditional
formatting?
A. Make the Revenue data item a property of Query1.
B. Make the Revenue data item a property of the List object.
C. Make the Revenue data item a property of the Page object.
D. Make the Revenue data item a property of the Variable object.
Answer: B
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
In Report Studio, an author wants to use a join object to create a relationship between two
queries. Which of the following is true?
A. The author can use a join object to create either an inner or outer join between the queries.
B. The author can use a join object only if both queries contain data from OLAP data sources.
C. The author can use a join object only if both queries contain data from relational sources that
has not been modeled dimensionally.
D. Both queries must contain the same number of data items, the data items must be compatible
and must appear in the same order.
Answer: A
In Report Studio, an author notices that the Revenue measure included in a list report has an
Aggregate Function property of Total. What does this property mean?
A. If the Auto Group Summarize property for the query is set to No, the list displays total revenue
values for the lowest level of detail in the report.
B. If the Auto Group Summarize property for the query is set to Yes, the list displays total revenue
values for the lowest level of detail in the report.
C. If the Auto Group Summarize property for the query is set to No, the list displays total revenue
values for grouped data items.
D. If the Auto Group Summarize property for the query is set to Yes, the list displays total revenue
values for grouped data items.
Answer: B
In Report Studio, an author creates a list report containing columns for Staff Name, Order
number, and Revenue. The author wants to burst this report to various sales staff members. Each
member should see only data relating to sales they have made. What must the author do to
specify that the burst report output will contain only data for the appropriate sales staff member?
A. In the report layout, create a master-detail relationship on the Staff Name data item.
B. In the report layout, add the Staff Name data item as a property of the List object.
C. In the burst options for the report, use the Staff Name data item to specify the Burst
Recipients.
D. In the burst options for the report, use the Staff Name data item to specify the Burst Groups.
Answer: D
Which statement is true about using a burst key to burst reports?
A. A burst key can be added to a crosstab report.
B. A burst key can be added to a list report.
C. A burst key can be added to a chart report.
D. A burst key can be added to a map report.
Answer: B
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
