IBM C2090 180 Cognos BI Professional Set 1

1.

A multi-server installation of Cognos BI must be performed. Which of the following is a valid strategy for installing across multiple servers?

Separate the gateway component from other server components to restrict report request processing to the Web server tier. Enable dedicated request processing, by installing a dispatcher in the Web server tier toact as a primary dispatcher for routing requests to other dispatchers. Scale the system vertically by installing one instance of all Cognos 8 services on a largercomputer capable of managing more concurrent request threads. Enable load balancing of requests for content management services by installing multipleinstances of Content Manager.

2.

Which of the following is a critical component in delivering Corporate Performance Management throughout an enterprise?

Drill down from summary to detailed information within individual subject areas. Drill across from one subject area to another through conformed dimensions. Star schema data marts designed to facilitate analysis and reporting. Event management designed to monitor the status of Key Performance Indicators.

3.

A company has several operational data stores. They wish to compare data from the various data stores against one another. The data in the various stores must be manipulated to match. Eventual report performance is more important than development time. Which of the Cognos 8 components would BEST address their requirements?

Report Studio and Query Studio Analysis Studio and Report Studio Data Manager and Analysis Studio Planning, Data Manager, and Report Studio

4.

Why should an application's performance be monitored on an ongoing basis after it goes into production?

Initial performance tests are usually too optimistic. There is little value in performance tests before a system goes into production. Usage patterns on applications tend to change over time. New releases of system and application software usually degrade performance.

5.

Which of the following describes common methods for enriching an initial dimension map?

Add exception and range band dimensions and include additional metrics and calculations. Merge dimensions and include additional metrics and calculations. Include additional metrics and calculations and core metrics and dimensions from relatedbusiness areas. Include additional metrics, calculations, and hierarchy levels, and dimensions fromrelated subject areas.

6.

Which of the following describes a disadvantage of using the dimensionally modeled relational (DMR) technique to access a normalized data structure?

does not allow access to all relational items in Query and Report Studio may increase the time needed to fetch required data does not allow access to member functions may bypass aggregate aware tables

7.

Which of the following is a key difference between MDX and SQL?

MDX is used for dimensional style reporting while SQL is incapable of dimensional style reporting. MDX has built in functions to support relative date calculations while SQL cannotperform relative date calculations. Dimensionally Modeled Relational (DMR) retrieves data using MDX, not SQL. MDX can reference metadata that SQL cannot.

8.

A table is in Third Normal Form if it is already in Second Normal Form, plus:

All attributes are determined only by the primary key All attributes are determined by all segments of the primary key All foreign keys are determined by the primary key All surrogate keys are determined by the primary key

9.

Which of the following BEST describes the relationship or differences between Iterative Approach and Cognos SIM?

The Iterative Approach is a specific technique used to iterate through the Design phase. The Iterative Approach is a series of steps defined in the Analysis and Developmentphases of Cognos SIM. The Iterative Approach is a philosophy of development while Cognos SIM is a collectionof tasks, documents, and techniques to guide development. Cognos SIM is the current Cognos development standard and is intended to replace theIterative Approach for development of BI applications.

10.

Which of the following is a valid strategy for addressing failover for the content store?

Install active and passive instances of the content store. Install active and passive instances of the Content Manager service. Take advantage of failover protection in the Applications tier by installing the contentstore on a server that hosts multiple instances of the report service. Take advantage of database backup and failover strategies and policies already in placein the environment.

IBM C2090 180 Cognos BI Professional Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

IBM C2090 180 Cognos BI Professional Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner