最新のBI0-132問題集で試験を準備する

COGNOS BI0-132 試験概要:

COGNOS BI0-132 試験シラバストピック:

COGNOS Cognos 8 BI Metadata Model Developer 認定 BI0-132 試験問題：

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

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

2. Which of the following is true of an OLAP data structure?

A) Organizes dimension tables into hierarchies and levels.
B) Allows "real time" analysis against disparate data sources.
C) Comprised of normalized dimension and fact tables.
D) Cardinality between tables is typically configured as inner joins.

3. After metadata is imported into Framework Manager or a new query subject is created, it is recommended to first verify which one of the following property settings?

A) Format
B) Usage
C) Semi-Aggregate
D) Data Type

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

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

5. Users want to compare Actual Revenue and Sales Target values by Month. Actual Revenue values are stored at the day grain in the Orders Fact table. Sales Target values are stored at the month grain in the Sales Target Fact table. In Framework Manager, which technique will best prevent Sales Target values from being double-counted in Query Studio reports?

A) Define both Month and Day determinant levels in the Time Dimension and Group By Day.
B) Define both Month and Day determinant levels in the Time Dimension and Group By Month.
C) Create separate star schema groupings for Orders Fact and Sales Target Fact, both at the month grain.
D) Set scope for Actual Revenue at the Day level and Sales Target at the Month level in the Dimension Map.

質問と回答：