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

COGNOS BI0-132 試験概要:

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

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

問題 #1

Although modelers can use model query subjects to create entire business views, it is recommended to use them to do which of the following?

A. Provide dimensional information through the use of determinants.
B. Combine facts and dimensions for intuitive ad hoc business views.
C. Resolve reporting traps and simplify snowflake tables through consolidation.
D. Resolve conflicting keys and indexes and generate minimized SQL.

問題 #2

In Framework Manager, why is it recommended that modelers alter the default all-inclusive select statements of data source query subjects as little as possible?

A. To generate the most efficient SQL at run time and simplify model maintenance.
B. To prevent improperly constructed SQL and reduce issues with model documentation and readability.
C. To prevent the exclusion of columns from a table that may be required in future reports.
D. To provide authors with access to all columns in a database table which reduces requests to the modeler.

問題 #3

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 XMIN on SALE_TOTAL.
B. An XSUM on Month.
C. An XSUM on SALE_TOTAL.
D. An XMIN on Month.

問題 #4

The illustration below represents which of the following data traps?

A. Bridge
B. Connection
C. Parallel relationship
D. Many-to-many relationship

問題 #5

What technique can Framework Manager modelers use to implement a time dimension for models that lack a time dimension?

A. Use parameter maps to map date values in one query subject to date values in another query subject.
B. Identify a time dimension table source, import into the model and create relationships to fact query subjects.
C. Use the Time Dimension wizard to generate a time dimension and create the appropriate relationships.
D. Create relationships from date fields in one dimension to date fields in another dimension.

解説：