COG-632 試験問題を無料オンラインアクセス

The illustration below represents which of the following data traps?

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

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

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

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.Resolve reporting traps and simplify snowflake tables through consolidation.
• B.Provide dimensional information through the use of determinants.
• C.Combine facts and dimensions for intuitive ad hoc business views.
• D.Resolve conflicting keys and indexes and generate minimized SQL.

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

The database table below would typically be found in what data structure?

• A.Operational
• B.Normalized
• C.Star schema
• D.Cartesan