BI0-132問題集、COGNOS実際の試験問題

質問 1

The groups and roles defined in the Cognos namespace can be used to assign access rights to which of the following Framework Manager objects?

A. Data sources.

B. Parameter maps.

C. Query items.

D. Relationships.

正解: C

質問 2

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

A. Defining multiple connections to the data source.

B. Generating relationships based on existing primary and foreign key relationships in the database.

C. Converting inner joins in the database to outer joins in the model.

D. Specifying the usage property for generated query items.

正解: B

質問 3

Which of the following components does a basic Cognos 8 stitch query consist of?

A. Coalesce function, full outer join, multiple queries that query some of the same information.

B. Coalesce function, full outer join, multiple queries that each query exclusive information.

C. SC() function, full outer join, multiple queries that each query exclusive information.

D. SC() function, full outer join, multiple queries that query some of the same information.

正解: A

質問 4

Which of the following data structures typically contain normalized data?

A. Operational

B. Flat file

C. Star schema

D. Cube

正解: A

質問 5

In order to create complex joins in Framework Manager, a modeler can use which of the following techniques?

A. Select the relationship, and then from the Actions menu, select "Merge in New Query Subject".

B. Open the Relationship Definition dialog, and then edit the join expression as required.

C. Open the Relationship Expression dialog, and then change both cardinality settings to 0..n or 0..1.

D. Right-click a relationship in the Object diagram or Context Explorer, and then select "Create Compound Join".

正解: B

質問 6

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.

正解: A

COGNOS Cognos 8 BI Metadata Model Developer - BI0-132 模擬練習