Cognos Framework Manager
.jpg "Cognos Framework Manager - Quiz")
Related to topics in Framework Manager User Guide and Advanced Configuration Techniques.
- 1.
Why do you import different databases into different namespaces?
- A.
To avoid duplication of data.
- B.
To keep databases separate and distinct.
- C.
To ensure silo characteristics of reporting data.
- D.
All of the above.
Correct Answer
A. To avoid duplication of data. -
- 2.
What is a package in Cognos Framework Manager?
- A.
The filters and namespaces used in Report Studio.
- B.
The source code from which objects in Framework Manager get their information.
- C.
What is actually published to the IBM Cognos BI server, and it is used to create reports, analyses, and ad hoc queries.
- D.
The components imported into Framework Manager for use in namespaces.
Correct Answer
A. The filters and namespaces used in Report Studio. -
- 3.
What are the two types of Dimensions in Framework Manager?
- A.
Measure
- B.
Crosstab
- C.
Regular
Correct Answer(s)
A. Measure
C. Regular -
- 4.
What are the types of query subjects?
- A.
Data source, dimensional, integrated
- B.
Dimensional, model, stored procedure
- C.
Data source, model, stored procedure
- D.
Dimensional, function, macros
Correct Answer
C. Data source, model, stored procedure -
- 5.
What's the best way of describing a query item?
- A.
Similar to a table in a relational database.
- B.
A branch in the Cognos Star Schema.
- C.
The smallest piece of a model that can be in a report.
- D.
A set of objects used in Report Studio.
Correct Answer
C. The smallest piece of a model that can be in a report. -
- 6.
What are the objects associated to a one-part identifier?
- A.
Shortcuts to namespaces
- B.
Namespaces
- C.
Packages
- D.
Shortcuts to folders
- E.
Functions
Correct Answer(s)
A. Shortcuts to namespaces
B. Namespaces
D. Shortcuts to folders
E. Functions -
- 7.
What are the objects associate to a two part identifier?
- A.
Query items
- B.
Measure dimensions
- C.
Shortcuts to query subjects
- D.
Query subjects
- E.
Regular dimensions
Correct Answer(s)
B. Measure dimensions
C. Shortcuts to query subjects
D. Query subjects
E. Regular dimensions -
- 8.
What are the objects associated to three part identifiers?
- A.
Query items
- B.
Query subjects
- C.
Hierarchies
- D.
Measures
Correct Answer(s)
A. Query items
C. Hierarchies
D. Measures -
- 9.
What is the objects assoicated to four part identifiers?
- A.
Levels
- B.
Query subjects
- C.
Packages
Correct Answer
A. Levels -
- 10.
What do five part identifiers consist of in most cases?
- A.
Namespace name
- B.
Dimension name
- C.
Query subjects
- D.
Hierarchy name
- E.
Level name
- F.
Query item name
- G.
Captions in member unique names
- H.
Business keys in member unique names
Correct Answer(s)
A. Namespace name
B. Dimension name
D. Hierarchy name
E. Level name
F. Query item name
G. Captions in member unique names
H. Business keys in member unique names -
- 11.
What are the types of authentication in Framework Manager?
- A.
IBM Cognos service credentials
- B.
External namespace
- C.
No authentication
- D.
Token
Correct Answer(s)
A. IBM Cognos service credentials
B. External namespace
C. No authentication -
- 12.
What is synonymous with a table in a relational database?
- A.
Query item
- B.
Package
- C.
Dimension
- D.
Query subject
Correct Answer
D. Query subject -
- 13.
What is synonymous with a column in a relational database?
- A.
Table
- B.
Column
- C.
Stored procedure
- D.
Function
Correct Answer
B. Column -
- 14.
What are isolation levels in Framework Manager?
- A.
Specifies how transactions that occur at run-time are handled.
- B.
Levels at which namespaces are separated.
- C.
Specifies how transactions that modify the database are handled.
- D.
Specifies the way database connections are integrated in Framework Manager.
Correct Answer
C. Specifies how transactions that modify the database are handled. -
- 15.
What are levels of isolation in the order of lowest to most isolation?
- A.
Read Uncommitted, Cursor Stability, Read Committed, Reproducible Read, Serializable, Phantom Protection
- B.
Read Uncommitted, Read Committed, Cursor Stability, Reproducible Read, Phantom Protection, Serializable
- C.
Read Uncommitted, Cursor Stability, Read Committed, Phantom Protection, Reproducible Read, Serializable
Correct Answer
B. Read Uncommitted, Read Committed, Cursor Stability, Reproducible Read, Phantom Protection, Serializable -
- 16.
How do you import metadata that has the same tables names?
- A.
Create three names spaces and merge the tables separately, then merge the two tables into one consistent table.
- B.
Create one namespace and merge the tables.
- C.
Create two namespaces and import each table into a different namespace.
- D.
Create one namespace and duplicate tables by using metadata wizard.
Correct Answer
C. Create two namespaces and import each table into a different namespace. -
- 17.
What happens when you reimport a table that you have already imported but renmaed in a namespace?
- A.
Framework Manager recognizes the object already exists.
- B.
Framework Manager will automatically crash and you may lose your entire project due to inconsistencies.
- C.
The originating table is deleted.
- D.
The table being imported is deleted.
Correct Answer
A. Framework Manager recognizes the object already exists. -
- 18.
What a view synonymous with in Framework Manager?
- A.
Query Item
- B.
View
- C.
Query Subject
- D.
Package
Correct Answer
C. Query Subject -
- 19.
What is a synonym synonymous with in Framework Manager?
- A.
Query Subject
- B.
Query Item
- C.
Package
- D.
Synonym
Correct Answer
A. Query Subject -
- 20.
What is a procedure synonymous with in Framework Manager?
- A.
Query Subject
- B.
Query Item
- C.
Function
- D.
Macro
- E.
Expression
Correct Answer
A. Query Subject -
- 21.
What is a function synonymous with in Framework Manager?
- A.
Query Subject
- B.
Query Item
- C.
Project Function
- D.
Project Expression
Correct Answer
C. Project Function -
- 22.
Where does the Table Name Attribute map to in Framework Manager?
- A.
Name of the database query subject on which the model query representing the package is based.
- B.
Name of the database query item on which the packaged query representing the fact is based.
- C.
Name of the database query item on which the packaged query representing the dimension is based.
- D.
Name of the database query subject on which the model query representing the fact is based.
Correct Answer
D. Name of the database query subject on which the model query representing the fact is based. -
- 23.
Where does the Short name Attribute map to in Framework Manager?
- A.
Query Subject Description
- B.
Query Item Description
- C.
Package Descriptions
- D.
Measure Dimension Description
Correct Answer
A. Query Subject Description -
- 24.
Where does the Business name Attribute map to in Framework Manager?
- A.
Query Subject
- B.
Query Item
- C.
Expression
- D.
Custom Property
Correct Answer
D. Custom Property -
- 25.
Where does the Description Attribute map to in Framework Manager?
- A.
Package description
- B.
Query subject description
- C.
Query item Description
- D.
Dimension description
Correct Answer
B. Query subject description -
- 26.
Where does the Column name Attribute map to in Framework Manager?
- A.
Dimension name
- B.
Table name
- C.
Column name
- D.
Does not map
Correct Answer
C. Column name -
- 27.
Where does the Column type Attribute map to in Framework Manager?
- A.
Query subject data type
- B.
Query item data type
- C.
Package data type
- D.
Measure dimension data type
Correct Answer
B. Query item data type -
- 28.
Where does the Column length Attribute map to in Framework Manager?
- A.
Query item size
- B.
Query subject size
- C.
Regular dimension size
- D.
Does not map.
Correct Answer
A. Query item size -
- 29.
Where does the Column short name Attribute map to in Framework Manager?
- A.
Does note map
- B.
Custom property
- C.
Query item short name
- D.
Query item description
Correct Answer
B. Custom property -
- 30.
Where does the Column business name Attribute map to in Framework Manager?
- A.
Custom property
- B.
Does not map
- C.
Query subject description
- D.
Query item description
Correct Answer
A. Custom property -
- 31.
Where does the Column description Attribute map to in Framework Manager?
- A.
Custom property
- B.
Does not map
- C.
Query subject description
- D.
Query item description
Correct Answer
D. Query item description -
- 32.
Where does the Column type Attribute map to in Framework Manager?
- A.
Query item description
- B.
Query item caption
- C.
Query item usage
- D.
Custom property
Correct Answer
C. Query item usage -
- 33.
Where does the Table keys Attribute map to in Framework Manager?
- A.
Determinants
- B.
Unique Keys
- C.
Regular Dimensional Attributes
- D.
Measure Dimensional Attributes
Correct Answer
A. Determinants -
- 34.
Where does the Data source Attribute connection short name map to in Framework Manager?
- A.
Custom property
- B.
Does not map
- C.
Data source description
- D.
Data source expression
Correct Answer
A. Custom property -
- 35.
Where does the Data source Attribute connection business name map to in Framework Manager?
- A.
Data source name
- B.
Custom property
- C.
Does not map
- D.
Data source short name
Correct Answer
A. Data source name -
- 36.
Where does the Data source Attribute connection description map to in Framework Manager?
- A.
Data source name
- B.
Data source short name
- C.
Data source description
- D.
Data source expression
Correct Answer
C. Data source description -
- 37.
Where does the Data source Attribute Connectivity map to in Framework Manager?
- A.
Custom property
- B.
Type.interface property
- C.
Does not map
- D.
Type.interface.description
Correct Answer
B. Type.interface property -
- 38.
Where does the Data source Attribute Connection string map to in Framework Manager?
- A.
Does not map
- B.
Data source connection string
- C.
Data source description string
- D.
Custom property
Correct Answer
D. Custom property -
- 39.
Where does the conformed star Attribute Star short name map to in Framework Manager?
- A.
The name of the package
- B.
The name of the namespace representing the star
- C.
The name of the duplicated dimension
- D.
The name of star schema short name
Correct Answer
B. The name of the namespace representing the star -
- 40.
Where does the conformed star Attribute Star business name map to in Framework Manager?
- A.
The name of the regular dimension representing the dimension
- B.
The name of the measure dimension representing the fact
- C.
The name of the regular dimension representing the fact
- D.
The name of the measure dimension representing the fact
Correct Answer
B. The name of the measure dimension representing the fact -
- 41.
Where does the conformed star Attribute Star description map to in Framework Manager?
- A.
The description of the measure dimension representing the fact
- B.
The description of the regular dimension representing the fact
- C.
The description of the measure dimension representing the dimension
- D.
The description of the regular dimension representing the dimension
Correct Answer
A. The description of the measure dimension representing the fact -
- 42.
Where does the conformed star Attribute fact map to in Framework Manager?
- A.
Shortcuts to a regular dimension
- B.
Shortcuts to a measure dimension
- C.
Shortcuts to a regular fact
- D.
Shortcuts to a measure fact
Correct Answer
B. Shortcuts to a measure dimension -
- 43.
Where does the conformed star Attribute Dimensions map to in Framework Manager?
- A.
Shortcuts to measure dimensions
- B.
Shortcuts to regular facts
- C.
Shortcuts to regular dimensions
- D.
Shortcuts to measure facts
Correct Answer
C. Shortcuts to regular dimensions -
- 44.
Where does the conformed star Attribute Hierarchies map to in Framework Manager?
- A.
Hierarchies in the measure dimension representing the DecisionStream dimensions
- B.
Hierarchies in the measure dimension representing the DecisionStream facts
- C.
Hierarchies in the regular dimension representing the DecisionStream facts
- D.
Hierarchies in the regular dimension representing the DecisionStream dimensions
Correct Answer
D. Hierarchies in the regular dimension representing the DecisionStream dimensions -
- 45.
Where does the model Attribute Schema version map to in Framework Manager?
- A.
Custom property
- B.
Does not map
- C.
Namespace description
- D.
Namespace shortcut
Correct Answer
B. Does not map -
- 46.
Where does the model Attribute Catalog version map to in Framework Manager?
- A.
Custom property
- B.
Does not map
- C.
Namespace description
- D.
Namespace expression
Correct Answer
A. Custom property -
- 47.
Where does the model Attribute Model short name map to in Framework Manager?
- A.
The description property of the namespace representing the top-level model object
- B.
The name of the package representing the top-level model object
- C.
The name of the namespace representing the top-level model object
- D.
Does not map
Correct Answer
C. The name of the namespace representing the top-level model object -
- 48.
Where does the model Attribute Model business name map to in Framework Manager?
- A.
Custom property
- B.
Does not map
- C.
Namespace business name
- D.
Namespace description
Correct Answer
A. Custom property -
- 49.
Where does the model Attribute Model description map to in Framework Manager?
- A.
The short name of the namespace representing the top-level model object
- B.
The description of the namespace representing the top-level model object
- C.
The description of the package representing the top-level model object
- D.
The expression of the package representing the top-level model object
Correct Answer
B. The description of the namespace representing the top-level model object -
- 50.
In Logical/Physical representations, how are integrated objects represented?
- A.
Only logical objects as one integrated object
- B.
The logical and physical objects as two integrated object
- C.
The logical and physical objects as one integrated object
- D.
Only physical objects as one integrated object
Correct Answer
C. The logical and physical objects as one integrated object -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Feb 22, 2013Quiz Edited by
ProProfs Editorial Team -
Sep 06, 2012Quiz Created by
Drewc555
Back to top