Cognosは世界で一番大きくて最もみごとな業務知能会社である。1969年に設立して、会社は全世界に135余り国家と地区は22，000の多数の取引先を持って、従業員は2900人を上回ります。世界で3,000のパートナーと販売店を持ち、ユーザーのために便利な業務知能技術支持とサービスを提供いたします。Cognos認証を持って、あなたがもっと多く面接のチャンスがもらえますよ
下はBI0-110の問題集で、みんなと分かち合います
1. 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 line results appear together in the 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 Query3 that retrieves both Order method and Product line data.
D. The author must add a sort key data item to Query1 and Query2,and then add this sort key data item to
Query3.
Answer: C
2. Which member is used for dimensions in package that are not referenced in the expression?
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 data item that appears in both the query and the layout. Grouping
applied in the report layout is also applied to tabular data.
Answer: A
3. In Report Studio, an author uses the tuple function to retrieve the intersection of members from two
dimensions. Which member is used for dimensions in the package that are not referenced in the
expression?
A. No member is used.
B. The root member is always used.
C. The last sibling of the lowest member is always used.
D. The default member for that Dimension is always used.
Answer: B
4. 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 item, the data items must be compatible and must
appear in the same order.
Answer: D
5. 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
Answer: B
6. 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 Quety1. Which of the following must the author do in order to apply this conditional formatting?
A. Make the Revenue data item a property of Queery1.
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