200+ TOP COGNOS Online Quiz Questions – Exam Test

Cognos Multiple Choice Questions :-

These are very useful & Most Asked Questions in your certification Exam. Read all Online Mock Test Exam Question Bank for Beginners Freshers & Experienced.

1.Which of the following is NOT a usage property in Framework Manager?
A.Fact
B.Dimension
C.Attribute
D.Identifier
E.Unknown
Answer: B

2.When working with dimensional data in Report Studio, an intersection is useful for obtaining a value from the combination of two or more members that you specify. This intersection is called:
A.A Singleton
B.A X Axis Measurement
C.A Visual Angle
D.A Position
E.A Tuple
Answer: E

3.In Oracle 11i, which of the following objects does not physically store data?
A.Views
B.Tables
C.Materialized Views
Answer: A

4.When creating a package in Framework Manager, the following setting allows the data within an object to be used in other objects without the original object itself being available to report users.
A.Select
B.Traverse
C.Unselect
D.Hide
Answer: D

5.Without using aggregation (Group By), is it possible to determine the minimum or maximum value of a data set using Oracle SQL?
A.Yes
B.No
Answer: A

6.In Report Studio, what function would be useful in implementing alternate line shading within a list box?
A.Char_length
B.currentMember
C.mod
D.exp
E.Order
Answer: C

7.In Cognos Connection, RSS news feeds may be specified by a URL address.
A.True
B.False
Answer: A

8.In Transformer, alternate drill-down paths / alternate hierarchies must have the a convergence level that is:
A.Unique
B.Ordered
C.Open
D.Set
Answer: A

9.Are Metric Studio metrics part of the Content Store?
A.Yes
B.No
Answer: B

10.Within Cognos Connection, these objects are used to control the display of one or more reports in a single portal page or in a dashboard.
A.Calculations
B.Global Filters
C.NewsItems
D.Policies
Answer: B

11.In Report Studio, which of the following is not a valid prompt button?
A.Execute
B.Back
C.Cancel
D.Reprompt
E.Next
Answer: A

12.Within the expression editor of Framework Manager, a quality of service indicator on functions gives a visual clue about the behavior of the function.  What quality of service indicator reflects the danger of poor performance on some data sources?
A.X
B.!!
C.!
D.&
E.no symbol
Answer: C

13.In Report Studio, at what level must the query be specified?
A.List
B.List Cell
C.List Column
D.List Column Body
E.List Header
Answer: A

14.Within Framework Manager, what objects are used to store key-value pairs which create conditional query subjects that allow for substitutions when the report is run?
A.Packages
B.Parameters
C.Filters
D.Query Subjects
E.Namespaces
Answer: B

15.When tuning performance, one should remember that the following setting takes precedence over the other two settings:
A.Advanced Routing Settings
B.Affinity Settings
C.Balance Request Settings
Answer: B

16.In Analysis Studio, what functionality would cause subtotals or totals to result in more than the sum of the rows or columns?
A.Custom Set
B.Nested Rows
C.Hidden Rows
D.Custom Filters
Answer: C

17.In Oracle 11i, what type of index is used to index low cardinality columns in a warehouse environment?
A.Function-based
B.Bitmap
C.Optimized
D.Normal
Answer: B

18.In Report Studio, what property may be set to prevent the object from being rendered and prevent its space from being reserved in the report?
A.Box Type
B.Visible
C.No Data Object
D.Contents Height
Answer: A

19.What is the Cognos 8 service that manages the storage of customer applications, including application-specific security, configuration data, models, metrics, reports, and report output?
A.Gateway
B.Package
C.Namespace
D.Content Manager
Answer: D

20.What feature allows reports to run based upon the package at the time the report was last saved?
A.Deployment
B.Verify
C.Versioning
D.Preserve
Answer: C

21.For what purpose are custom views used in Transformer?
A.Point-In-Time Reporting
B.Security
C.Manage Languages
D.Performance Optimization
Answer: B

22.Within Framework Manger, this type of SQL does not process query subjects as subqueries.
A.Pass-Through SQL
B.Cognos SQL
C.Native SQL
D.PL SQL
Answer: A

23.In Framework Manager, what object is required to enable drilling up and down in a hierarchy used in Analysis Studio reports?
A.Identifier
B.Fact
C.Dimension
D.Attribute
Answer: C

24.Which of the following is NOT a valid Oracle SQL statement?
A.SELECT column1, SUM(column2) “column2” FROM table1 GROUP BY column1 ORDER BY column1
B.SELECT column1, SUM(column2) “column2” FROM table1 HAVING SUM(column2) = 0 GROUP BY column1 ORDER BY column1
C.SELECT column1, SUM(column2) “column2” FROM table1 GROUP BY column1 HAVING SUM(column2) = 0 ORDER BY column1
D.SELECT column1, SUM(column2) “column2” FROM table1 ORDER BY column1 GROUP BY column1
Answer: D

25.In Oracle SQL, what is the command that returns the first non-null value in a list of values?
A.NVL
B.DECODE
C.COALESCE
D.INSTR
E.ISNOTNULL
Answer: C

26.In Cognos Connection, which of the following is a valid permission to be granted at the report level?
A.Run
B.View
C.Traverse
D.Edit
Answer: C

27.If the user desires to retrieve all rows from Table A and all rows from Table B based on a join criteria, what type of join would be necessary?
A.Left Outer Join
B.Inner Join
C.Cross Join
D.Cluster Join
E.Cartesian Join
Answer: E

28.In an Oracle SQL insert statement, is it necessary to designate the column names?
A.Yes
B.No
Answer: B

29.What is the regular aggregate property of a calculated fact object within Framework Manager?
A.Sum
B.Total
C.Average
D.Automatic
E.Unsupported
Answer: D

30.Can SQL code be added directly into a Report Studio report?
A.Yes
B.No
Answer: A

31. What can an administrator use to transfer security data from one location to another using Series 7 namespaces?
A. Settings (.csa) file
B. Local authentication cache (.lac) file
C. Local authentication export (.lae) file
D. Configuration specification (.ccs) file
Answer:  C

32. What is the minimum requirement for configuring Cognos Office Connection using Smart Client technology with Microsoft Office components?
A. Excel with MS Office 2003 Professional
B. Excel with MS Office 2003 Standard
C. PowerPoint with MS Office 2003 Standard
D. PowerPoint with MS Office 2003 Professional
Answer:  A

33. What is created after the administrator initializes the metric store?
A. a metric extract
B. an object extract
C. a metric package
D. a relational database
Answer:  C

34. What is stored in the Cognos 8 content store?
A. Log files
B. Metric packages
C. Report specifications
D. Metric Designer extracts
Answer:  C

35. Which type of logging indication can show user calls that are made from Cognos 8 components?
A. audit logging
B. trace logging
C. event logging
D. performance logging
Answer:  A

36. How can an administrator ensure that users who are logged on to Cognos 8 are not prompted to log on again when they access PowerCube data?
A. Have Cognos 8 and PowerPlay point to the same local authentication export (.lae) file.
B. Have Cognos 8 and PowerPlay point to the same local authentication cache (.lac) file.
C. Have Cognos 8 and PowerPlay use, as their authentication source, the same NTLM namespace.
D. Have Cognos 8 and PowerPlay use, as their authentication source, the same Series 7 namespace.
Answer:  D

37. Which model type enables users to drill down in Analysis Studio?
A. Architect model
B. Relational model
C. Dimensional model
D. Data Manager model
Answer:  C

38. Why would an administrator want to copy a user profile?
A. The user was deleted using a third-party authentication provider.
B. The administrator wants to copy trusted credentials for multiple users.
C. The user has changed names and the administrator is setting up an account in the new name.
D. The user requires enhanced security permissions before logging on to Cognos 8 for the first time.
Answer:  C

39. Under what circumstances would full logging level be most appropriately used?
A. Whenever users cannot access the data.
B. Whenever detailed troubleshooting is required.
C. Whenever more than one dispatcher has been configured.
D. Whenever the default configuration for logging has been changed.
Answer:  B

40. At what level should the logging be set to capture the following set of details?
user account management and runtime usage of Cognos 8,
use requests, and
service requests and responses.
A. trace
B. basic
C. request
D. minimal
Answer:  C

COGNOS