Cognos Beginner Quiz

Cognos Beginner Quiz




1
Following is not true about a namespace is framework manager

  1. Namespace uniquely identifies query subjects
  2. Same query subject can belong to 2 different name spaces
  3. You can create a namespace within a namespace.
  4. A namespace is the name given to query subjects

Answer : A namespace is the name given to query subjects

 
2
Which of the following is not a type of query subject in Framework manager ?

  1. Model Query Subject
  2. Package Query subject
  3. Stored Procedure Query subject
  4. Data source Query subject

Answer : Package Query subject

 
3
Which of the following is not part of a model developed in Framework manager ?

  1. Query Subject
  2. Query Item
  3. Namespace
  4. Derived table

Answer : Derived table

 
4
Reports and configuration information is stored in

  1. Content store
  2. Metadata store
  3. Object store
  4. None of the above

Answer : Content store

 
5
Which of the following tools is not part of Cognos BI 10.2 ?

  1. Cognos Connection
  2. Analysis Studio
  3. Cognos Reporter
  4. Cognos Workspace

Answer : Cognos Reporter

 
6
Which of the following is not true regarding query studio

  1. Used to create simple queries and reports
  2. You can display a list report or a crosstab report along with a chart
  3. Query studio supports maximum of 2 lists or crosstabs in a report
  4. Query studio allows you to display data as a list, chart or both

Answer : Query studio supports maximum of 2 lists or crosstabs in a report

 
7
Which of the following is not true regarding Analysis studio

  1. Analysis studio can be used for multi dimensional analysis
  2. Analysis studio can display data as a cross tab and chart
  3. Analysis studio supports drill down and roll up for multi dimensional data
  4. Analysis studio can display data in the form of list or cross tab

Answer : 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

  1. Conditional Explorer
  2. Page Explorer
  3. Query Explorer
  4. Data Explorer

Answer : Data Explorer

 
9
Which of the following is not a type of variable in conditional explorer in Report studio

  1. Boolean variable
  2. String Variable
  3. Numeric variable
  4. Language Variable

Answer : Numeric variable




10
Following option can be used to convert a list to a cross tab

  1. Crosstab option
  2. Pivot option
  3. Convert table option
  4. None of the above

Answer : Pivot option

 
11
Which of the following operator is available in Query explorer ?

  1. Except
  2. Union
  3. Intersect
  4. All the above

Answer : All the above

 
12
To render objects based on a condition in Report studio, we can use

  1. Conditional Blocks
  2. Hide option
  3. Conditional views
  4. Filters

Answer : Conditional Blocks

 
13
To highlight exceptional values in reports we can use

  1. Conditional Blocks
  2. Conditional styles
  3. Format command
  4. None of the above

Answer : Conditional styles

 
14
When you run a report in Report Studio, you can set the default format to

  1. HTML
  2. XML
  3. PDF
  4. All the above

Answer : All the above

 
15
If a report contains a prompt, what happens when you run the report ?

  1. A prompt page appears asking for a selection
  2. The report runs with prompt at the top of page letting you to change selection
  3. Report appears filtered on predefined parameter values
  4. None of the above

Answer : A prompt page appears asking for a selection

 
16
What is the role of Dispatcher in Cognos BI ?

  1. A Dispatcher is used to copy reports between two servers
  2. A Dispatcher starts all Cognos BI services configured on the computer
  3. A Dispatcher routes requests to local services configured on the system
  4. Both B & C

Answer : Both B & C

 
17
Which of the following is true regarding Cognos Connection ?

  1. Cognos Connection is the single access point for all Studios in Cognos BI
  2. Cognos Connection is used to extract data from framework manager packages using MS Office applications
  3. Cognos Connection is used to connect two reports in Cognos BI
  4. None of the above

Answer : Cognos Connection is the single access point for all Studios in Cognos BI

 
18
Which of the following is True regarding Cognos Workspace ?

  1. It is a Web based tool used to build Interactive workspaces using existing Cognos BI Content
  2. Is the work area where tables and charts are placed in Report studio
  3. Is a tool used to develop pixel perfect reports
  4. None of the above

Answer : It is a Web based tool used to build Interactive workspaces using existing Cognos BI Content

 
19
Which of the following tools is not part of Cognos BI 10.2 ?

  1. Workspace Advanced
  2. Metric Studio
  3. Query Studio
  4. Query Explorer

Answer : Query Explorer




20
Following is true regarding Determinants in Cognos BI

  1. Determinants are used to ensure correct aggregation of repeated keys and attributes
  2. Determinants are used to avoid double counting
  3. A group-by needs to be specified for non unique determinants
  4. All the above

Answer : All the above

 
21
Which of the following is not true regarding determinants

  1. Determinants are set in Framework manager
  2. Determinants are to be specified when a query subject needs to be connected at different levels of granularity.
  3. Determinants are not related to granularity of query subjects being connected
  4. None of the above

Answer : Determinants are not related to granularity of query subjects being connected

 
22
Which of the following are true regarding determinants ?

  1. When you specify a non-unique determinant you need to specify group by
  2. When you specify a unique determinant you need to specify Order by
  3. For unique determinants, both group by and order by need to be specified
  4. None of the above

Answer : When you specify a non-unique determinant you need to specify group by

 
23
Following is not a part of DMR model in Framework Manager

  1. Hierarchies
  2. Levels
  3. Dimensions
  4. None of the above

Answer : None of the above

 
24
Following is not a dimension type in Framework manager

  1. Measure Dimension
  2. Regular Dimension
  3. Fact Dimension
  4. None of the above

Answer : Fact Dimension

 
25
Which of the following is not one of the properties to be set for Regular Dimensions in Framework manager ?

  1. MemberCaption
  2. BusinessKey
  3. MemberDescription
  4. LevelKey

Answer : LevelKey

 
26
What is a Unique Level in Regular Dimension ?

  1. A level having a business key which uniquely identifies the row
  2. A level with no duplicate keys
  3. A level which uniquely identifies a parent level
  4. A level having unique attributes

Answer : A level having a business key which uniquely identifies the row

 
27
Which of the following is not true regarding macros in Framework manager

  1. Macros are small piece of code which can be inserted in objects
  2. Macros can include references to Parameter maps
  3. Macros can include references to users’s session parameters
  4. None of the above

Answer : None of the above

 
28
Which of the following does not apply to Parameter maps in Framework manager ?

  1. Parameter maps are key value pairs
  2. Parameter maps are 2-column lookup tables defined in framework manager
  3. Parameter maps can be used in macros to Filter objects at run time based on session parameters in Query subjects
  4. All the above

Answer : All the above

 
29
Which of the following is not a valid session parameter

  1. DefaultName
  2. runLocale
  3. current_timestamp
  4. account.systemName

Answer : account.systemName




30
Which of the following cannot be achieved using Governers

  1. Max number of report tables
  2. Set a limit on on query execution time
  3. Allow / Deny outer joins
  4. None of the above

Answer : None of the above

 
31
Following is not a Tier of 3-Tier design In Framework Manager

  1. Database View
  2. Presentation View
  3. Logical View
  4. Business View

Answer : Logical View

 
32
Which of the following is true regarding measure dimensions ?

  1. Measure dimensions do not have hierarchies or levels
  2. Measure dimensions have numeric measurements or facts
  3. Regular dimensions provide context to measures in measure dimensions
  4. All the above

Answer : All the above

 
33
Which of the following is true regarding scope relationships ?

  1. Scope relationship can be set in dimension map
  2. Scope Relationship defines which measures are in scope for which dimensions and at which levels for a hierarchy
  3. Scope relationships defines scope of query item in a query subject
  4. A & B

Answer : A & B

 
34
Which of the following filters is not available in Framework manager ?

  1. Standalone filter
  2. Embedded filter
  3. Detail Filter
  4. A & B

Answer : Detail Filter

 
35
Which of the following filters is not available in Report studio ?

  1. Summary Filter
  2. Detail Filter
  3. Regular filter
  4. None of the above

Answer : Regular filter

 
36
Which of the following tools can be used to schedule a report ?

  1. Cognos Connection
  2. Report Studio
  3. Cognos Administration
  4. Framework Manager

Answer : Cognos Connection

 
37
Which of the following tools can be used to create data source connections ?

  1. Cognos Administration
  2. Framework Manager
  3. Report Studio
  4. A & B

Answer : A & B

 
38
Datasource Query Subjects can be created in which of the following ways ?

  1. Right click on namespace or folder and click on Create
  2. Click on menu item Actions and click on Create
  3. Using Metadata wizard
  4. All the above

Answer : All the above

 
39
Which of the following is true regarding query subjects ?

  1. A model query subject can be created by merging more than one data source query subjects ?
  2. Type of query subject cannot be changed once it is created
  3. A stored procedure query subject is based on an existing data source query subject
  4. A & B

Answer : A & B




40
Which of the following is true regarding Model Query Subjects ?

  1. Model Query subjects reflect point of view of business users
  2. Model Query subjects are based on Data source query subjects
  3. Filters & Calculations can be added to Model Query Subjects
  4. All the above

Answer : All the above

 
41
Which of the following is true regarding testing of Query Subjects ?

  1. Click on Test sample in Test tab of query subject to display sample data
  2. Number of sample rows returned can be set using Options link
  3. Test tab has a option to return row count for the query subject
  4. All the above

Answer : All the above

 
42
Relationship between query subjects can be created in following ways

  1. Righ Click on Query subject and click on Create Relationship
  2. Create relationship in context explorer by selecting the related columns and clicking on Create relationship
  3. Using Metadata wizard
  4. All the above

Answer : All the above

 
43
Which of the following cardinalities represent a Outer Join ?

  1. 1..n
  2. 1..1
  3. 0..n
  4. None of the above

Answer : 0..n

 
44
Which of the following is true regarding stitch queries ?

  1. A stitch query is created when query retrieves data from 2 star schema groupings and includes data from atleast one common dimension
  2. When two query subjects are joined together in a report, it is called a stitch query
  3. A stitch query is used to eleminate duplicate rows when two query subjects are joined
  4. None of the above

Answer : A stitch query is created when query retrieves data from 2 star schema groupings and includes data from atleast one common dimension

 
45
Which of the following is a type of shortcut in Framework manager ?

  1. Alias Shortcut
  2. Query Shortcut
  3. Model Shortcut
  4. DataSource shortcut

Answer : Alias Shortcut