Cognos Beginner Quiz
1
Following is not true about a namespace is framework manager
- Namespace uniquely identifies query subjects
- Same query subject can belong to 2 different name spaces
- You can create a namespace within a namespace.
- A namespace is the name given to query subjects
2
Which of the following is not a type of query subject in Framework manager ?
- Model Query Subject
- Package Query subject
- Stored Procedure Query subject
- Data source Query subject
3
Which of the following is not part of a model developed in Framework manager ?
- Query Subject
- Query Item
- Namespace
- Derived table
4
Reports and configuration information is stored in
- Content store
- Metadata store
- Object store
- None of the above
5
Which of the following tools is not part of Cognos BI 10.2 ?
- Cognos Connection
- Analysis Studio
- Cognos Reporter
- Cognos Workspace
6
Which of the following is not true regarding query studio
- Used to create simple queries and reports
- You can display a list report or a crosstab report along with a chart
- Query studio supports maximum of 2 lists or crosstabs in a report
- Query studio allows you to display data as a list, chart or both
7
Which of the following is not true regarding Analysis studio
- Analysis studio can be used for multi dimensional analysis
- Analysis studio can display data as a cross tab and chart
- Analysis studio supports drill down and roll up for multi dimensional data
- Analysis studio can display data in the form of list or cross tab
8
Following is not one of the explorers available in Report studio
- Conditional Explorer
- Page Explorer
- Query Explorer
- Data Explorer
9
Which of the following is not a type of variable in conditional explorer in Report studio
- Boolean variable
- String Variable
- Numeric variable
- Language Variable
10
Following option can be used to convert a list to a cross tab
- Crosstab option
- Pivot option
- Convert table option
- None of the above
11
Which of the following operator is available in Query explorer ?
- Except
- Union
- Intersect
- All the above
12
To render objects based on a condition in Report studio, we can use
- Conditional Blocks
- Hide option
- Conditional views
- Filters
13
To highlight exceptional values in reports we can use
- Conditional Blocks
- Conditional styles
- Format command
- None of the above
14
When you run a report in Report Studio, you can set the default format to
- HTML
- XML
- All the above
15
If a report contains a prompt, what happens when you run the report ?
- A prompt page appears asking for a selection
- The report runs with prompt at the top of page letting you to change selection
- Report appears filtered on predefined parameter values
- None of the above
16
What is the role of Dispatcher in Cognos BI ?
- A Dispatcher is used to copy reports between two servers
- A Dispatcher starts all Cognos BI services configured on the computer
- A Dispatcher routes requests to local services configured on the system
- Both B & C
17
Which of the following is true regarding Cognos Connection ?
- Cognos Connection is the single access point for all Studios in Cognos BI
- Cognos Connection is used to extract data from framework manager packages using MS Office applications
- Cognos Connection is used to connect two reports in Cognos BI
- None of the above
18
Which of the following is True regarding Cognos Workspace ?
- It is a Web based tool used to build Interactive workspaces using existing Cognos BI Content
- Is the work area where tables and charts are placed in Report studio
- Is a tool used to develop pixel perfect reports
- None of the above
19
Which of the following tools is not part of Cognos BI 10.2 ?
- Workspace Advanced
- Metric Studio
- Query Studio
- Query Explorer
20
Following is true regarding Determinants in Cognos BI
- Determinants are used to ensure correct aggregation of repeated keys and attributes
- Determinants are used to avoid double counting
- A group-by needs to be specified for non unique determinants
- All the above
21
Which of the following is not true regarding determinants
- Determinants are set in Framework manager
- Determinants are to be specified when a query subject needs to be connected at different levels of granularity.
- Determinants are not related to granularity of query subjects being connected
- None of the above
22
Which of the following are true regarding determinants ?
- When you specify a non-unique determinant you need to specify group by
- When you specify a unique determinant you need to specify Order by
- For unique determinants, both group by and order by need to be specified
- None of the above
23
Following is not a part of DMR model in Framework Manager
- Hierarchies
- Levels
- Dimensions
- None of the above
24
Following is not a dimension type in Framework manager
- Measure Dimension
- Regular Dimension
- Fact Dimension
- None of the above
25
Which of the following is not one of the properties to be set for Regular Dimensions in Framework manager ?
- MemberCaption
- BusinessKey
- MemberDescription
- LevelKey
26
What is a Unique Level in Regular Dimension ?
- A level having a business key which uniquely identifies the row
- A level with no duplicate keys
- A level which uniquely identifies a parent level
- A level having unique attributes
27
Which of the following is not true regarding macros in Framework manager
- Macros are small piece of code which can be inserted in objects
- Macros can include references to Parameter maps
- Macros can include references to users’s session parameters
- None of the above
28
Which of the following does not apply to Parameter maps in Framework manager ?
- Parameter maps are key value pairs
- Parameter maps are 2-column lookup tables defined in framework manager
- Parameter maps can be used in macros to Filter objects at run time based on session parameters in Query subjects
- All the above
29
Which of the following is not a valid session parameter
- DefaultName
- runLocale
- current_timestamp
- account.systemName
30
Which of the following cannot be achieved using Governers
- Max number of report tables
- Set a limit on on query execution time
- Allow / Deny outer joins
- None of the above
31
Following is not a Tier of 3-Tier design In Framework Manager
- Database View
- Presentation View
- Logical View
- Business View
32
Which of the following is true regarding measure dimensions ?
- Measure dimensions do not have hierarchies or levels
- Measure dimensions have numeric measurements or facts
- Regular dimensions provide context to measures in measure dimensions
- All the above
33
Which of the following is true regarding scope relationships ?
- Scope relationship can be set in dimension map
- Scope Relationship defines which measures are in scope for which dimensions and at which levels for a hierarchy
- Scope relationships defines scope of query item in a query subject
- A & B
34
Which of the following filters is not available in Framework manager ?
- Standalone filter
- Embedded filter
- Detail Filter
- A & B
35
Which of the following filters is not available in Report studio ?
- Summary Filter
- Detail Filter
- Regular filter
- None of the above
36
Which of the following tools can be used to schedule a report ?
- Cognos Connection
- Report Studio
- Cognos Administration
- Framework Manager
37
Which of the following tools can be used to create data source connections ?
- Cognos Administration
- Framework Manager
- Report Studio
- A & B
38
Datasource Query Subjects can be created in which of the following ways ?
- Right click on namespace or folder and click on Create
- Click on menu item Actions and click on Create
- Using Metadata wizard
- All the above
39
Which of the following is true regarding query subjects ?
- A model query subject can be created by merging more than one data source query subjects ?
- Type of query subject cannot be changed once it is created
- A stored procedure query subject is based on an existing data source query subject
- A & B
40
Which of the following is true regarding Model Query Subjects ?
- Model Query subjects reflect point of view of business users
- Model Query subjects are based on Data source query subjects
- Filters & Calculations can be added to Model Query Subjects
- All the above
41
Which of the following is true regarding testing of Query Subjects ?
- Click on Test sample in Test tab of query subject to display sample data
- Number of sample rows returned can be set using Options link
- Test tab has a option to return row count for the query subject
- All the above
42
Relationship between query subjects can be created in following ways
- Righ Click on Query subject and click on Create Relationship
- Create relationship in context explorer by selecting the related columns and clicking on Create relationship
- Using Metadata wizard
- All the above
43
Which of the following cardinalities represent a Outer Join ?
- 1..n
- 1..1
- 0..n
- None of the above
44
Which of the following is true regarding stitch queries ?
- A stitch query is created when query retrieves data from 2 star schema groupings and includes data from atleast one common dimension
- When two query subjects are joined together in a report, it is called a stitch query
- A stitch query is used to eleminate duplicate rows when two query subjects are joined
- None of the above
45
Which of the following is a type of shortcut in Framework manager ?
- Alias Shortcut
- Query Shortcut
- Model Shortcut
- DataSource shortcut