BI0-132試験無料問題集（53題）「COGNOS Cognos 8 BI Metadata Model Developer 認定」

出題：1

The illustration below represents which of the following data traps?

A. Bridge

B. Parallel relationship

C. Connection

D. Many-to-many relationship

正解：B 解答を投票する

出題：2

An author creates a Report Studio report that contains Month, Product Line and Revenue. Revenue has a footer to show the overall total. What will the author see in the generated Cognos SQL for the Revenue footer column?

A. XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue2

B. XSUM(XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) in Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue

C. XSUM(XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) at Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue1

D. XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue

正解：C 解答を投票する

出題：3

Which column is most likely a non-conformed or non-shared dimension from the SQL below?
select coalesce(D2.DAY_DATE,D3.DAY_DATE) as DAY_DATE, coalesce(D2.ORDER_METHOD,D3.ORDER_METHOD) as ORDER_METHOD, D3.REASON_DESCRIPTION as REASON_DESCRIPTION, D2.SALE_TOTAL as SALE_TOTAL, D3.RETURN_QUANTITY as RETURN_QUANTITY from

A. D2.DAY_DATE

B. D3.REASON_DESCRIPTION

C. D2.ORDER_METHOD

D. D3.RETURN_QUANTITY

正解：B 解答を投票する

出題：4

Which of the following is true for 0..n cardinality?

A. The cardinality is optional and an inner join will be performed.

B. The cardinality is optional and an outer join will be performed.

C. The cardinality is unknown and an inner join will be performed.

D. The cardinality is optional and a union will be performed.

正解：B 解答を投票する

出題：5

The Cognos 8 report below contains two conformed dimensions, Time Dimension and Product Dimension, and one non-conformed dimension, Order Method. Which of the following best describes the results?

A. Cross join

B. Multi-fact split

C. Correlated list

D. Contiguous result set

正解：C 解答を投票する

BI0-132試験無料問題集「COGNOS Cognos 8 BI Metadata Model Developer 認定」