Cognos

BI0-132

Cognos 8 BI Metadata Model Developer

https://killexams.com/pass4sure/exam-detail/BI0-132

Answer: C

QUESTION: 48

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?

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

Answer: D

QUESTION: 49

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

Unspecified
Running
Unknown
Extended

Answer: B

QUESTION: 50

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

Enable the Allow Enhanced Model Portability governor.
Set the Cross¬product joins and Outer Joins governors to Deny.
Add filters and calculations to model query subjects rather than data source query subjects.
Ensure that, where required, queries are executed against materialized views which contain only aggregated data rather than base tables that contain all the data.

Answer: A

QUESTION: 51

In Framework Manager, which of the following will have a positive impact on query performance without intervention from an author?

Create stand¬alone filters.
Add performance indicators to functions.
Configure data sources in a project pointing to the same database instance to use the same connection.
For a query item having an integer data type, set the Display Item Reference property to display an integer value.

Answer: C

QUESTION: 52

A user¬defined function imported into Framework Manager can be viewed and used in the following locations?

Viewed in the Explorer and used in the expression editor.
Viewed in the Project Viewer and used in the expression editor.
Viewed in the Explorer and used in the SQL of a model query subject.
Viewed in the Diagram and used in the SQL of a data source query subject.

Answer: A

QUESTION: 53

A recursive relationship exists between SALES_STAFF_CODE and MANAGER_CODE in the SALES_STAFF data source query subject. This query subject is provided in a model to report authors. Using this query subject alone, report authors cannot create a report that includes management staff and the sales staff that report to them. How can the existing recursive relationship in the model be modified to provide this ability to report authors?

Import a query subject that does not contain a recursive relationship.
Create a star schema grouping that contains the SALES_STAFF data source query subject and a shortcut to the SALES_STAFF data source query subject.
Create a model query subject with the appropriate relationship to the existing SALES_STAFF data source query subject and make both available to report authors.
Create a shortcut to the SALES_STAFF data source query subject, and report authors will use it instead of the underlying query subject to create the required report.

Answer: C

QUESTION: 54

In Framework Manager, if a modeler changes the business key for a level in a regular dimension, which of the following may change?

Level MUN
Level identifier
Member MUNs
Member aliases

Answer: C

QUESTION: 55

What must amodeler consider when modeling for drill¬through between multiple data sources?

Drill¬through values must be cast.
Drill¬through values must be conformed.
Drill¬through values must be consolidated.
Drill¬through values must be identifiers.