Cognos Online Test
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
Correct Answer
C. Crosstab -
- 2.
In Report Studio, which chart lets the report author plot a third measure?
- A.
Area
- B.
Bubble
- C.
Scatter
- D.
Progressive column
Correct Answer
B. Bubble -
- 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
Correct Answer
B. Sections appear outside 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.
Correct Answer
B. A burst key can be added to a list 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
Correct Answer
B. To insert an object inside a list column. -
- 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
Correct Answer
C. One or more data items that uniquely define an event instance -
- 7.
What is the format in which a report specification is saved in cognos connection?
- A.
HTML
- B.
XML
- C.
.XLS
- D.
PDF
Correct Answer
B. XML -
- 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
Correct Answer
C. Evaluate 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
Correct Answer
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
Correct Answer
A. A. specifying the data package, choosing a basic report layout, adding data, validating the report, saving the report, 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
Correct Answer
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
Correct Answer
B. Applied only to detail items from the data source -
- 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
Correct Answer
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.
Correct Answer
B. Organizes dimension tables into hierarchies and levels. -
- 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
Correct Answer
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
Correct Answer
C. Namespace -
- 17.
What is the extension of a project file created in Framework Manager?
- A.
Pdf
- B.
Mdf
- C.
Cpf
- D.
Xml
Correct Answer
D. Xml -
- 18.
Which is not a type of filter in Framework manager?
- A.
Standalone Filter
- B.
Detail Filter
- C.
Embedded Filter
- D.
None
Correct Answer
B. Detail Filter -
- 19.
Which of the following cognos component is window based?
- A.
Report Studio
- B.
Event Studio
- C.
Framework Manager
- D.
Analysis Studio
Correct Answer
C. Framework Manager -
- 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.
Correct Answer
C. A constant value drawn on a chart to indicate major divisions in the data. -
- 21.
In Report Studio, which chart lets the report author plot a third measure?
- A.
Area
- B.
Bubble
- C.
Scatter
- D.
Progressive column
Correct Answer
B. Bubble -
- 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
Correct Answer
B. Report 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
Correct Answer
B. A burst key can be added to a list report. -
- 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
Correct Answer
C. Zero-to-zero -
- 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.
Correct Answer
A. To move object in a report -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Jul 02, 2015Quiz Edited by
ProProfs Editorial Team -
Jul 02, 2015Quiz Created by
Vinay200khool
Back to top