COGNOS Multiple Choice Questions and Answers
1.Which of the following is NOT a usage property in Framework Manager?
A.Fact
B.Dimension
C.Attribute
D.Identifier
E.Unknown
Ans: 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
Ans: E
3.In Oracle 11i, which of the following objects does not physically store data?
A.Views
B.Tables
C.Materialized Views
Ans: 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
Ans: 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
Ans: 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
Ans: C
7.In Cognos Connection, RSS news feeds may be specified by a URL address.
A.True
B.False
Ans: 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
Ans: A
9.Are Metric Studio metrics part of the Content Store?
A.Yes
B.No
Ans: 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
Ans: 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
Ans: 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
Ans: 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
Ans: 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
Ans: 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
Ans: 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
Ans: 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
Ans: 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
Ans: 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
Ans: 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
Ans: C
21.For what purpose are custom views used in Transformer?
A.Point-In-Time Reporting
B.Security
C.Manage Languages
D.Performance Optimization
Ans: 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
Ans: 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
Ans: 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
Ans: 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
Ans: 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
Ans: 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
Ans: E
28.In an Oracle SQL insert statement, is it necessary to designate the column names?
A.Yes
B.No
Ans: 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
Ans: D
30.Can SQL code be added directly into a Report Studio report?
A.Yes
B.No
Ans: 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
Ans: 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
Ans: 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
Ans: C
34. What is stored in the Cognos 8 content store?
A. Log files
B. Metric packages
C. Report specifications
D. Metric Designer extracts
Ans: 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
Ans: 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.
Ans: 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
Ans: 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.
Ans: 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.
Ans: 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
Ans: C
1.Which of the following is NOT a usage property in Framework Manager?
A.Fact
B.Dimension
C.Attribute
D.Identifier
E.Unknown
Ans: 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
Ans: E
3.In Oracle 11i, which of the following objects does not physically store data?
A.Views
B.Tables
C.Materialized Views
Ans: 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
Ans: 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
Ans: 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
Ans: C
7.In Cognos Connection, RSS news feeds may be specified by a URL address.
A.True
B.False
Ans: 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
Ans: A
9.Are Metric Studio metrics part of the Content Store?
A.Yes
B.No
Ans: 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
Ans: 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
Ans: 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
Ans: 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
Ans: 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
Ans: 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
Ans: 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
Ans: 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
Ans: 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
Ans: 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
Ans: 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
Ans: C
21.For what purpose are custom views used in Transformer?
A.Point-In-Time Reporting
B.Security
C.Manage Languages
D.Performance Optimization
Ans: 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
Ans: 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
Ans: 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
Ans: 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
Ans: 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
Ans: 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
Ans: E
28.In an Oracle SQL insert statement, is it necessary to designate the column names?
A.Yes
B.No
Ans: 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
Ans: D
30.Can SQL code be added directly into a Report Studio report?
A.Yes
B.No
Ans: 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
Ans: 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
Ans: 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
Ans: C
34. What is stored in the Cognos 8 content store?
A. Log files
B. Metric packages
C. Report specifications
D. Metric Designer extracts
Ans: 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
Ans: 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.
Ans: 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
Ans: 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.
Ans: 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.
Ans: 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
Ans: C
No comments:
Post a Comment