[2026] IBM Cognos 10 BI Metadata Model Developer

문제1

In Framework Manager, which of the following will have a negative impact on query performance?

A. Add filters and calculations to model query subjects rather than data source query subjects.

B. Enable the Allow Enhanced Model Portability governor.

C. Ensure that, where required, queries are executed against materialized views which contain only aggregated data rather than base tables that contain all the data.

D. Set the Cross-product joins and Outer Joins governors to Deny.

정답: 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(XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) in Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue

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

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

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

정답: B

문제3

What question should a data modeler answer before accepting this proposed operational data structure?

A. Should a role playing dimension be created?

B. Should all three tables be consolidated into one?

C. Is there a direct relationship between Branch and Employee?

D. Are Branch and Employee dimension tables or fact tables?

정답: C

문제4

In Framework Manager, which of the following is true about verifying your model?

A. The model can only be verified through the Publish Packages wizard.

B. The entire model must be verified, individual objects cannot be verified.

C. It is possible to select to automatically repair certain issues that have been detected.

D. The model can be verified from Cognos Connection or through the Publish Packages wizard.

정답: C

문제5

The generated Cognos SQL below contains which one of the following joins?

A. Left inner join on RETURN_REASON_KEY.

B. Inner join on RETURN_REASON_KEY.

C. Left outer join on RETURN_REASON_KEY.

D. Outer join on RETURN_REASON_KEY.

정답: B

문제6

When running an interactive HTML report, which of the following aggregation methods is used by default?

A. Running

B. Extended

C. Unknown

D. Unspecified

정답: A

IBM Cognos 10 BI Metadata Model Developer - COG-632무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트