Cognos Development Set 3

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Free Online Best Cognos Development MCQ Questions for improve your basic knowledge of Cognos Development. This Cognos Development set 3 test that contains 25 Multiple Choice Questions with 4 options. You have to select the right answer to a question.

Start

Congratulations - you have completed Cognos Development Set 3.

You scored %%SCORE%% out of %%TOTAL%%.

Your performance has been rated as %%RATING%%

Your answers are highlighted below.

Question 1

What Are Products Of Cognos?

A	Cognos 6.6 7.0
B	ReportNet1.0
C	ReportNet 8.0
D	All of the Above

Question 2

Which of the following are true regarding determinants ?

A	None of the above
B	When you specify a non-unique determinant you need to specify group by
C	When you specify a unique determinant you need to specify Order by
D	For unique determinants, both group by and order by need to be specified

Question 3

Can we specify the values to prompt for scheduling Cognos reports

A	Yes for all parameters
B	No
C	Yes for Compalsury prompts
D	None of the above

Question 4

Cognos Dynamic Cube solution consists of what elements?

A	IBM Cognos Cube Designer
B	IBM Cognos Dynamic Cubes Server
C	Aggregate Advisor (part of IBM Cognos Dynamic Query Analyzer)
D	All of the Above

Question 5

Define dimensions?

A	dimensions defines the structure of a cube
B	dimensions is a development tool which is used to create the end-user layer used by authors to build their BI objects
C	dimensions is a database with approximately 25 million or more fact table rows
D	dimensions contains the miscellaneous attributes such as flags , which does belong to the main dimension table

Question 6

Which of the following functionality can be applied to a list report ?

A	Filter
B	summary
C	calculation
D	All the above

Question 7

How do you handle Database Schema changes in Framework manager model to automatically update meta data ?

A	Delete Database schema and create new Schema
B	Update automatically
C	Update object every time Database schema changes
D	None of the above

Question 8

What is the difference between an iterator and a data iterator in Active reports ?

A	Anything with ‘data’ in front of the control is driven by data in a query
B	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
C	A non-data control can have the control values manually created by simply typing them in
D	None of the above

Question 9

Which of the following is not a type of variable in condition explorer in Report studio?

A	Boolean variable
B	String Variable
C	Numeric variable
D	Language Variable

Question 10

Which of the following is NOT a valid section of a report specification?

A	specification
B	header query(ies)
C	layout(s)
D	database(s)

Question 11

A qualifying container for objects that provides a unique name to prevent naming conflicts

A	namespace
B	Package
C	model
D	parameter map

Question 12

What is the name of the interface where you can schedule report?

A	Cognos Administration
B	Metrics Studio
C	Analysis Studio
D	Report Studio

Question 13

Define framework manager?

A	framework manager is a development tool which is used to create the end-user layer used by authors to build their BI objects
B	framework manager defines the structure of a cube
C	framework manager is a database with approximately 25 million or more fact table rows
D	framework manager contains the miscellaneous attributes such as flags , which does belong to the main dimension table

Question 14

Active Reports Can be viewed on_____

A	Desktop
B	IPAD
C	Andriod Phone
D	All of the above

Question 15

Report studio has which types of variables_____

A	Render variable
B	Style variable
C	Contional variable
D	All the above

Question 16

In report studio , why would an user unlock a report?

A	To open a report saved locally in xml
B	To add objects to existing cells or blocks in report
C	To apply conditional formatting
D	All of the above

Question 17

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

A	A prompt page appears asking for a selection
B	The report runs with prompt at the top of page letting you to change selection
C	Report appears filtered on predefined parameter values
D	None of the above

Question 18

In Report Studio, why would an author use the Page Structure view?

A	To move objects 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

Question 19

In a Report Studio report, to set to the Height and Width of an object which property must be set?

A	Positioning
B	Size & Overflow
C	Padding
D	Margin

Question 20

What is the size of the cube?

A	2.0GB
B	depends on the project
C	both A and B
D	3.0GB

Question 21

Can we import a store procedure in FM for list report_____

A	No
B	Yes, store procedure with out parameter
C	Yes, procedure which returns cursor
D	All store procedure

Question 22

When to use Cognos Dynamic Cubes?

A	A server with adequate memory
B	A database with approximately 25 million or more fact table rows
C	both A and B
D	None of Above

Question 23

To highlight exceptional values in reports we can use ______

A	Conditional Blocks
B	Conditional styles
C	Format command
D	None of the above

Question 24

What is a Cube?

A	Cube divided into different parts and sending these different parts of report to different users
B	Cube is set to be multi-dimensional view of dimension and measures and it is used to analyze the data in various forms like Slicing and Dicing
C	Cube Contains database with approximately 25 million or more fact table rows
D	All of the Above

Question 25

When you add a measure to a report, the measure has a default ___ function property

A	Aggregate
B	Drilldown
C	Drill up
D	None of the above

Once you are finished, click the button below. Any items you have not completed will be marked incorrect. Get Results

There are 25 questions to complete.

←

List

→

Return

Shaded items are complete.

1	2	3	4	5
6	7	8	9	10
11	12	13	14	15
16	17	18	19	20
21	22	23	24	25
End

Return

BACK SET 2

NEXT SET 4

Study Zone

MCQ » Cognos Development Set 3

Cognos Development Set 3

Important Links