BI0-132 무료 덤프문제 온라인 액세스

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.ORDER_METHOD
• B.D2.DAY_DATE
• C.D3.REASON_DESCRIPTION
• D.D3.RETURN_QUANTITY

In Framework Manager, if a modeler tests the Month from Time Dimension and SALE_TOTAL from Sales Fact and applies Auto Sum, which of the following is a modeler most likely to see?

• A.An XSUM on SALE_TOTAL.
• B.An XMIN on Month.
• C.An XSUM on Month.
• D.An XMIN on SALE_TOTAL.

In Framework Manager, which of the following is a correct technique for model segmentation?

• A.Define the repository type and path to the repository inCognos Connection.
• B.Consolidate segmented and linked metadata in a project into a single project by publishing a package to a network location.
• C.Copy all segmented model files into one common folder before using Framework Manger's model merge feature.
• D.Segment a project at the level of an individual query subject.

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(XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) in Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue
• B.XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue2
• 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

To create a report in Report Studio, a report author accesses which object?

• A.The runtime version of a Framework Manager model.
• B.A file that contains query subjects externalized from Framework Manager.
• C.A development model from Framework Manager.
• D.A report specification.