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

When importing metadata into Framework Manager from a relational database, which of the following can be controlled by the modeler performing the import?

• A.Specifying the usage property for generated query items.
• B.Defining multiple connections to the data source.
• C.Generating relationships based on existing primary and foreign key relationships in the database.
• D.Converting inner joins in the database to outer joins in the model.

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

• A.It is possible to select to automatically repair certain issues that have been detected.
• B.The model can only be verified through the Publish Packages wizard.
• C.The entire model must be verified, individual objects cannot be verified.
• D.The model can be verified fromCognos Connection or through the Publish Packages wizard.

In Framework Manager, when using star schema groupings in the business view, conformed dimensions can be identified by which one of the following?

• A.Viewing the properties of the query subjects in Framework Manager.
• B.Viewing the properties of the query subjects in Report Studio.
• C.Using the same name for the dimension in each star schema grouping.
• D.Using a different query subject icon for display in the studios.

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

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.Set scope for Actual Revenue at the Day level and Sales Target at the Month level in the Dimension Map.
• B.Define both Month and Day determinant levels in the Time Dimension and Group By Month.
• C.Define both Month and Day determinant levels in the Time Dimension and Group By Day.
• D.Create separate star schema groupings for Orders Fact and Sales Target Fact, both at the month grain.