IBM Cognos BI Professional - C2020-180 Exam Practice Test

Question 1

A user makes the following request:"I need to see the number of flights throughout the year that arrived or departed more than 15 minutes early or late by origin and destination airport, by carrier, and by time of day. I want to see if the number of flights delayed is greater for large carriers or small carriers."This request requires clarification to make the user's intention clear. Which of the following will NOT further clarify the user's request?

A. Determine if 15 minutes is the only significant grouping of late or early departures or arrivals.

B. Determine the definition of a large and small carrier.

C. Determine if origin and destination airports should be considered joined pairs (for example, from DFW to ORD) or as separate dimensions.

D. Determine if Date and Time of Day should be split into separate dimensions.

Correct Answer: D

Question 2

Which of the following requires additional configuration for installing Cognos 8 BI in a development and production environment?

A. The environment contains customized port and firewall settings for the default http and application server port.

B. The development and production environment will use data sources that are in Unicode.

C. The application in the development environment and in the production environment will use the Tomcat servlet container as the application server.

D. The development environment will include workstations hosting Framework Manager andCognos 8 OLAP Modeling, while the production environment will not.

Correct Answer: A

Question 3

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

A. The Iterative Approach is a series of steps defined in the Analysis and Development phases of Cognos SIM.

B. The Iterative Approach is a philosophy of development while Cognos SIM is a collection of tasks, documents, and techniques to guide development.

C. Cognos SIM is the current Cognos development standard and is intended to replace the Iterative Approach for development of BI applications.

D. The Iterative Approach is a specific technique used to iterate through the Design phase.

Correct Answer: B

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 4

In the Key Performance Indicator (KPI) process flow diagram shown below, which Cognos 8 components are normally associated with the 'Source Information' step?

A. Enterprise Planning and Report Studio

B. Analysis Studio and Metric Studio

C. Analysis Studio and Data Manager

D. Enterprise Planning and Data Manager

Correct Answer: D

Question 5

Which statement is true about the BI Bus?

A. It is a set of protocols that govern communications amongCognos 8 BI services.

B. It monitors all http traffic flowing through the gateways and dispatchers.

C. It uses a JDBC driver to connect to Content Stores in Sybase,SQLServer, Oracle and DB2.

D. It is the name of the report process that is spawned and viewed in Windows Task Manager when a report execution request is processed.

Correct Answer: A

Question 6

Which Cognos 8 BI architectural component is written in C++?

A. Monitoring service

B. Job service

C. Presentation service

D. Batch report service

Correct Answer: D

Question 7

Companies often create a collection of summary tables as their first attempt at a data warehouse. While there are several drawbacks to this approach, there are also some advantages. Which of
the following is an advantage of this approach over reporting from an operational database?

IBM Cognos BI Professional - C2020-180 Exam Practice Test

Latest Update

Useful Links

Contact Us