Cognos Online Test
Settings
Total 25 Questions,each one carry 1 mark and duration is 30 min.
- 1.The sales department require a report that numerically compares the gross profit genereated for all products lines in each territory.In Report Studio,which is the most appropriate report type?
- A.
List
- B.
Chart
- C.
Crosstab
- D.
Repeater
- 2.In Report Studio, which chart lets the report author plot a third measure?
- A.
Area
- B.
Bubble
- C.
Scatter
- D.
Progressive column
- 3.In Report Studio, When Creating a list report, What is the differnce between creating a section and creating a header?
- A.
Headers appear outside the list
- B.
Sections appear outside the list
- C.
Headers appear once at the top of the list
- D.
Sections appear once at the top of the list
- 4.Which statement is true about using burst key to burst reports?
- A.
A burst key can be added to a crosstab report.
- B.
A burst key can be added to a list report.
- C.
A burst key can be added to a chart report.
- D.
A burst key can be added to a Map report.
- 5.In Report Studio, why would an author unlock a report?
- A.
To open a report saved locally in XML.
- B.
To insert an object inside a list column.
- C.
To apply conditional formatting.
- D.
To view data that has been restricted in Framework
- 6.In Event Studio, which definition best describes the event key?
- A.
. The object that is created in Event Studio. DreamBig Technologies
- B.
Specific occurrence of data items that an agent must detect.
- C.
One or more data items that uniquely define an event instance
- D.
The set of detected event instances that satisfy the task execution rules
- 7.What is the format in which a report specification is saved in cognos connection?
- A.
HTML
- B.
XML
- C.
.XLS
- D.
PDF
- 8.Which of the following is not a prompt type in report studio?
- A.
Date and time prompt
- B.
Time prompt
- C.
Evaluate prompt
- D.
Date prompt
- 9.In a report studio report,which of the following properties must be set,to add white space around text within a box?
- A.
Size Overflow
- B.
Positioning
- C.
Margin
- D.
Padding
- 10.Which of the following options is the correct steps for a report in report studio?
- A.
A. specifying the data package, choosing a basic report layout, adding data, validating the report, saving the report, running the report
- B.
B. specifying the data package, adding data, validating the report, saving the report, running the report, choosing a basic report layout
- C.
C. specifying the data package, validating the report, saving the report, running the report, choosing a basic report layout, adding data
- D.
D. specifying the data package, validating the report, saving the report, choosing a basic report layout, adding data, , running the report
- 11.Which object will be used to create following report? “You are a report author at The Great Outdoors Company, which sells sporting equipment. You are requested to create mailing labels for all of the company's retailers.”
- A.
Singleton
- B.
List
- C.
Crosstab
- D.
Repeater
- 12.Which of the following statement is true about detail filter?
- A.
Detail filter is applied to summary data item in a report.
- B.
Applied only to detail items from the data source
- C.
A & B both
- D.
None of A and B
- 13.The sales department require a report that numerically compares the gross profit generated for all products lines in each territory. In Report Studio, which is the most appropriate report type?
- A.
List
- B.
Chart
- C.
Crosstab
- D.
Repeater
- 14.Which of the following is true of an OLAP data structure?
- A.
Comprised of normalized dimension and fact structures
- B.
Organizes dimension tables into hierarchies and levels.
- C.
.Allows "real time" analysis against disparate data sources.
- D.
Cardinality must be defined.
- 15.What does a star schema database structure typically consist of?
- A.
De-normalized hierarchy of dimension tables and fact tables.
- B.
Normalized dimension tables and detailed fact tables.
- C.
Normalized dimension tables and summarized fact tables.
- D.
De-normalized dimension tables and fact tables
- 16.Which of the following objects in the Framework Manager environment acts as a container and provides a unique name for objects?
- A.
Model
- B.
Folder
- C.
Namespace
- D.
Query subject folder
- 17.What is the extension of a project file created in Framework Manager?
- A.
Pdf
- B.
Mdf
- C.
Cpf
- D.
Xml
- 18.Which is not a type of filter in Framework manager?
- A.
Standalone Filter
- B.
Detail Filter
- C.
Embedded Filter
- D.
None
- 19.Which of the following cognos component is window based?
- A.
Report Studio
- B.
Event Studio
- C.
Framework Manager
- D.
Analysis Studio
- 20.In Report Studio what is the baseline?
- A.
A value in a list report that other values are compared against.
- B.
A border in a crosstab that seperates measures from aggregate totals.
- C.
A constant value drawn on a chart to indicate major divisions in the data.
- D.
A break point that lets you keep part of a report stationary while you scroll.
- 21.In Report Studio, which chart lets the report author plot a third measure?
- A.
Area
- B.
Bubble
- C.
Scatter
- D.
Progressive column
- 22.Which of the following security is not applied in framework manager?
- A.
Row level security
- B.
Report level security
- C.
Object level security
- D.
Package level security
- 23.Which statement is true about using burst key to burst reports?
- A.
A burst key can be added to a crosstab report.
- B.
A burst key can be added to a list report.
- C.
A burst key can be added to a chart report.
- D.
A burst key can be added to a Map
- 24.Which is not a type of relationship in framework manager?
- A.
One-to-one
- B.
One-to many or zero-to-many
- C.
Zero-to-zero
- D.
Many-to-many
- 25.In Report Studio, Why would an author use the Page Structure View?
- A.
To move object in a report
- B.
To change the underlying query
- C.
To add a new page to the report.
- D.
To drive page layout using a query.
Back to top