IBM COG-180 問題集

質問 1：
A company records when customers check into a service center. If there are too many customers waiting for the number of service representatives on hand, a manager wishes to be notified by an e-mail that contains a report showing the current condition. Which of the following Cognos 8 Components would BEST address their needs?
A. Event Management and Report Studio
B. Data Manager, Event Management, and Office Connection
C. Office Connection and Report Studio
D. Office Connection and Query Studio
正解：A

質問 2：
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?
A. It is easy to leverage many new reports from the summary tables.
B. It is easier to understand because there are fewer summary tables.
C. Specific reports for which the summary tables were created will run faster.
D. Over time summary tables often naturally group into business subject areas.
正解：C

質問 3：
You are tasked with administering the Cognos 8 BI system to perform batch reporting in a way that maximizes the use of available system resources. Given the following information, how many jobs should be created to perform this task? 480 reports must run 6 report processes are available Each process is configured to use 4 low affinity connections
A. 48
B. 12
C. 24
D. 20
正解：D

質問 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."Based on this request, the following metrics have been identified: Flight count, and minutes early or late. Large carriers operate signifigantly more flights than small carriers. Which of the following additional metrics or calculations would provide the MOST value to the user?
A. Average minutes early or late
B. Percentage of flights 15 minutes early or late
C. Average number of flights 15 minutes early or late
D. Origin/Departure airport count
正解：B

質問 5：
A company wishes to coordinate the anticipated hiring activities of all of the departments in a given division of the organization. The CEO has mandated a limit of 50 total new hires for the coming fiscal year. The various departments must coordinate future hiring. The CEO would also like to see reports comparing the projected hiring vs. the actual number of new hires by department. Which set of Cognos 8 components BEST supports the company's needs?
A. Planning and Data Manager
B. Report Studio and Analysis Studio
C. Planning and Report Studio
D. Event Studio and Report Studio
正解：C

質問 6：
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 the definition of a large and small carrier.
D. Determine if Date and Time of Day should be split into separate dimensions.
正解：D

質問 7：
All of the following describe design intent of an operational database EXCEPT:
A. record the day to day operations of the company
B. enhance reporting through foreign keys and indexes
C. maximize the speed of inserts and updates to the database
D. facilitate performing specific functional tasks
正解：B