COG-180 by IBM Valid Free Exam Practice Test

Question 1

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

A. Job service B. Batch report service C. Monitoring service D. Presentation service

Correct Answer: B

Question 2

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

A. The request is automatically queued and is processed by the first available low affinity connection in the system. B. The request is given priority and is always processed by the same process that served up the originating low affinity request. C. The request is load-balanced and is sent to any available dispatcher in the system. D. 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.

Correct Answer: D

Question 3

When examining an operational (transactional) database, which of the following is considered a good indicator as to which tables contain fact data?

A. Tables with the fewest number of foreign keys B. Tables with the greatest number of rows C. Tables with the greatest number of foreign keys D. Tables with the fewest number of columns

Correct Answer: B

Question 4

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 origin and destination airports should be considered joined pairs (for example, from DFW to ORD) or as separate dimensions. B. Determine if 15 minutes is the only significant grouping of late or early departures or arrivals. C. Determine if Date and Time of Day should be split into separate dimensions. D. Determine the definition of a large and small carrier.

Correct Answer: C

Question 5

Which of the following BEST describes the group of users who would typically use these Cognos 8 components: Metric Studio, Analysis Studio, and Query Studio?

A. Executives B. Analysts and Authors C. Information Consumers D. Knowledge workers and decision makers

Correct Answer: D

Question 6

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

A. Scale the system vertically by installing one instance of allCognos 8 services on a larger computer capable of managing more concurrent request threads. B. Separate the gateway component from other server components to restrict report request processing to the Web server tier. C. Enable load balancing of requests for content management services by installing multiple instances of Content Manager. D. Enable dedicated request processing, by installing a dispatcher in the Web server tier to act as a primary dispatcher for routing requests to other dispatchers.

Correct Answer: D

Question 7

A user makes the following request:"I need to see actual sales compared with projected sales, and margin range for branches within each division, by product line, sales rep by sales manager, and cost center over time." Based on the user's request, Actual Sales and Projected Sales have been identified as required measures. Which of the following other measures would be included in an initial dimension map?

A. Average Sales B. Unit Cost C. Discount Amount D. Sales Variance

Correct Answer: D

IBM Cognos BI Professional - COG-180 Exam Practice Test