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

What must a modeler consider when modeling for drill-through between multiple data sources?

• A.Drill-through values must be identifiers.
• B.Drill-through values must be conformed.
• C.Drill-through values must be consolidated.
• D.Drill-through values must be cast.

Which of the following is true of the generated native SQL below?

• A.The parent select statement uses an inner join to directly match columns from physical tables in the database.
• B.The derived table is executed independently, using Pass-Through SQL, and then processed locally.
• C.The derived table is used to retrieve one data set, in order to fulfill the join condition of another data set.
• D.The outer projection list will return more columns than listed, due to extra columns retrieved in the derived table.

Which of the following objects in the Framework Manager environment acts as a container and provides a unique name for objects?

• A.namespace
• B.folder
• C.model
• D.query subject folder

What does a star schema database structure typically consist of?

• A.De-normalized hierarchy of dimension tables and fact tables.
• B.De-normalized dimension tables and fact tables.
• C.Normalized dimension tables and detailed fact tables.
• D.Normalized dimension tables and summarized fact tables.

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 entire model must be verified, individual objects cannot be verified.
• C.The model can only be verified through the Publish Packages wizard.
• D.The model can be verified from Cognos Connection or through the Publish Packages wizard.