IBM C2020-180 Actual Free Exam Questions & Community Discussion

Exam Code/Number: C2020-180
Exam Name/Title: IBM Cognos BI Professional
Certification Provider: IBM
Corresponding Certification: IBM Cognos

Exam Questions: 66
Updated On: May 27, 2026

Question #8

Which of the following is correct regarding the processing of a PageDown high affinity request?

A. The request is routed to the same process that served up the originating low affinity request if the process is available and if there is an available high affinity connection.

B. The request is load-balanced and is sent to any available dispatcher in the system.

C. The request is given priority and is always processed by the same process that served up the originating low affinity request.

D. The request is automatically queued and is processed by the first available low affinity connection in the system.

Discussion 0

Correct Answer: A Vote an answer

Question #9

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

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

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

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

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

Discussion 0

Correct Answer: B Vote an answer

Question #10

Which service is required when a user views saved report output?

A. batch report service

B. presentation service

C. report service

D. report data service

Discussion 0

Correct Answer: B Vote an answer

Question #11

A company has a manufacturing database they wish to interrogate. They know there are issues that have affected production quality over the last year but they are unsure exactly what factors are contributing to the problem. They would like to be able to quickly examine manufactured batches from multiple perspectives and, if there are any anomalies or any unusual trends over time, they would then like to focus on specific batches to understand the details. Which of the following Cognos 8 Components would BEST address their needs?

A. Event Studio and Report Studio

B. Report Studio and Query Studio

C. Analysis Studio and Metric Studio

D. Analysis Studio and Report Studio

Discussion 0

Correct Answer: D Vote an answer

Question #12

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 Date and Time of Day should be split into separate dimensions.

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

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

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

Discussion 0

Correct Answer: A Vote an answer

Question #13

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

A. Drill across from one subject area to another through conformed dimensions.

B. Drill down from summary to detailed information within individual subject areas.

C. Event management designed to monitor the status of Key Performance Indicators.

D. Star schema data marts designed to facilitate analysis and reporting.

Discussion 0

Correct Answer: A Vote an answer

Question #14

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

A. All foreign keys are determined by the primary key

B. All attributes are determined by all segments of the primary key

C. All surrogate keys are determined by the primary key

D. All attributes are determined only by the primary key

Discussion 0

Correct Answer: D Vote an answer

Download Free IBM C2020-180 Demo

Simply submit your e-mail address below to get started with our free demo of your IBM C2020-180 exam.