Cognos Intermediate Quiz
Cognos Intermediate Quiz contains set of 51 Cognos MCQ Questions With Answers which will help you to clear Intermediate level quiz.
1) A qualifying container for objects that provides a unique name to prevent naming conflicts
- namespace
- Package
- model
- parameter map
2) How can we restrict the no of rows per page in list report ?
- no of rows per page in list report cannot be restricted
- columns can be restricted and not the rows in list report
- In Page properties – rows per page
- In list properties – rows per page
3) How do you handle Database Schema changes in Framework manager model to automatically update meta data ?
- Delete Database schema and create new Schema
- Update automatically
- Update object every time Database schema changes
- None of the above
4) How to reprompt a set of prompts in a report.
- Refresh the page
- Refresh the prompt section.
- Add a reprompt button to report
- None of the above
5) In Report Studio, which variable in Condition Explorer requires the author to create Values?
- Style
- String
- Boolean
- Language
6) Which Report Run option will minimize processing time ?
- HTML
- Excel
- None of the above
7) This represents the many-to-many relationship
- .1 to 1..n
- 1..n to 1..n
- .1 to 1..1
- .1 to 1..n
8) To explore correlations between different sets of data what kind of charts are useful ?
- Bubble Charts
- Scatter chart
- point Charts
- Combination charts
9) When you add a measure to a report, the measure has a default ___ function property
- Aggregate
- Drilldown
- Drill up
- None
10) When you add a prompt item directly onto a report page, what happens when you run the report?
- the prompt page appears
- the report appears with a prompt on the page letting you narrow your focus
- you will be prompted to specify a value for that item before the report is displayed
- none of the above
11) Where can connection information for data sources listed in the Framework Manager Metadata Wizard be edited?
- Cognos Administration
- Framework Manager Metadata Wizard
- Content store resource in Cognos Configuration
- Data Sources folder in the Framework Manager Project Viewer
12) Which of the following is NOT a valid section of a report specification?
- specification header
- query(ies)
- layout(s)
- database(s)
13) Can we import a store procedure in FM for list report
- No
- Yes, store procedure with out parameter
- Yes, procedure which returns cursor
- All store procedure
14) In report studio , why would an user unlock a report?
- To open a report saved locally in xml
- To add objects to existing cells or blocks in report
- To apply conditional formatting
- All of the above
15) Which of the following functionality can be applied to a list report ?
- Filter
- summary
- calculation
- All the above
16) Report studio has which types of variables
- Render variable
- Style variable
- Contional variable
- All the above
17) What are the different levels of security that can be applied in Framework Manager?
- Data & Package
- Data, Object & Package
- Object & Data
- None of the above
18) What is the name of the interface where you can schedule report?
- Cognos Administration
- Metrics Studio
- Analysis Studio
- Report Studio
19) A Query Subject named X should be accessible only by Managers, What security mode will u apply
- Data Level
- Object Level
- Model Level
- None
20) Active Reports Can be viewed on
- Desktop
- IPAD
- Andriod Phone
- ALL
21) What is the difference between an iterator and a data iterator in Active reports ?
- Anything with ‘data’ in front of the control is driven by data in a query. A non-data control can have the control values manually created by simply typing them in
- Both are same
- Anything with ‘data’ in front of the control is driven by data in a static data of control. A non-data control can have the control values manually created by simply typing them in
- None of the above
22) In a Report Studio report, to set to the Height and Width of an object which property must be set?
- Positioning
- Size & Overflow
- Padding
- Margin
23) In Report Studio, why would an author use the Page Structure view?
- To move objects in a report.
- To change the underlying query.
- To add a new page to the report.
- To drive page layout using a query.
24) Which of the following is true for 0..n cardinality?
- The cardinality is optional and a union will be performed.
- The cardinality is optional and an inner join will be performed.
- The cardinality is optional and an outer join will be performed.
- The cardinality is required and an outer join will be performed.
25) Prompt controls that are added to report pages will appear when we run the report in
- HTML
- Excel
- CSV
26) 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
27) 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
28) 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
29) Which of the following is not a type of variable in condition explorer in Report studio
- Boolean variable
- String Variable
- Numeric variable
- Language Variable
30) 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
31) 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
32) Which of the following filters is not available in Framework manager ?
- Standalone filter
- Embedded filter
- Detail Filter
- A & B
33) Which of the following filters is not available in Report studio ?
- Summary Filter
- Detail Filter
- Regular filter
- None of the above
34) 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
35) Which of the following is a type of shortcut in Framework manager ?
- Alias Shortcut
- Query Shortcut
- Model Shortcut
- DataSource shortcut
36) In Framework Manager we use the below filter when we have to use filter with only one specific query subject or model query subject.
- StandAlone
- Embedded
- Detail Filter
- Summary Filter
37) In report studio, a detail filter can be applied in the following cases
- To apply filter on individual records retrieved from database
- To filter records after data is aggregated at report level
- To filter data based on group summaries
- Both A & B
38) Which of the following is true regarding deployment of content between environments
- You can deploy entire content store between environments
- You can deploy partial content between environments
- You can include user account information when exporting entire content store
- All the above
39) Which option is best if users need to be given the option to view a report as a list, a crosstab or a chart
- String variable
- Boolean
- Report Language
- Layout calculation
40) To highlight exceptional values in reports we can use
- Conditional Blocks
- Conditional styles
- Format command
- None of the above
41) Which of the following is not true regarding Dynamic Query Mode (DQM) ?
- Available from Cognos BI 10 onwards
- DQM over relational is only supported by DMR packages
- Package published without DQM enabled will run in Compatible Query Mode
- DQM cannot be enabled at Project level
42) Query Engine used by DQM is called
- Dynamic Query Engine (DQE)
- Relational Query Engine (RQE)
- Extensible Query Engine (XQE)
- None of the above
43) Dynamic Queries are serviced by
- Query Service
- Identity Service
- Report Service
- Analytic Service
44) Do More button is Cognos Workspace is used to
- Open the component in Workspace advanced Tool
- Open the Properties Window
- Set Advanced Properties for the component
- None of the above
45) Which is the tool used to display graphical representation & Trouble shoot Dynamic queries
- Dynamic Query Debugger
- Dynamic Query Analyzer
- DQM Debugger
- None of the above
46) Which of the following is true regarding Dynamic Cubes
- Dynamic Cube is an extension of Dynamic Query
- Dynamic Cubes use In- memory cache and aggregate awareness to achieve high performance
- Require star or snow flake database schemas
- All the above
47) Can we control Life of Active report
- Yes
- No
- Yes with Limited functionality.
48) How to disable Active Reports based on User Class
- By using Capabilities options
- By removing from execute permission
- both
- None of above
49) Can we apply Global filter for all compoment in Workspace
- No
- Yes
50) Where can import external datasource e.g. excel files
- Workspace
- Workspace Advance
- Both (Workspace and Workspace Advance)
- None
51) What are delivary methods of Report Out via Cognos Schedule
- Save to N/W Drive
- All the above
52) Can we specify the values to prompt for scheduling Cognos reports
- Yes for all parameters
- No
- Yes for Compalsury prompts