IBM COG-180 問題集

質問 1：
Which of the following statements is true about the Waterfall Approach?
A. It is designed so that requirements that are not discovered in the Analysis step will cascade out during the design phase.
B. Each step is performed in sequence but you return to previous steps at specific points in the development cycle.
C. Project management tools no longer encourage the Waterfall Approach.
D. The five steps in the process are considered valid for BI software development projects.
正解：D

質問 2：
Which of the following is a common mistake made by designers when creating dimension models?
A. Including alternate hierarchies.
B. Adding dimensions and measures from other subject areas.
C. Splitting a single dimension into multiple dimensions.
D. Including multiple date/time hierarchies.
正解：B

質問 3：
Which of the following issues is Iterative Development specifically designed to address?
A. The very act of developing a system or solution will change the business requirements.
B. Users often feel that IT does not understand the business.
C. No developed solution will satisfy all users equally.
D. Users understand their business processes but they don't usually understand application development.
正解：A

質問 4：
When a user requests a certain piece of information, the interviewer may ask what the user would do with that information. From the techniques described in the BI Professional Workshop, why is the interviewer asking this particular question?
A. To determine if the information is an actionable item for the user and therefore part of a business requirement.
B. To determine if the information is a security concern and should therefore be made unavailable to other users.
C. To determine if the user is allowed access to that particular information and therefore should not be included in his subject area.
D. To determine if the user understands how the information is functionally used within the organization.
正解：A

質問 5：
Which of the following is true regarding hierarchies and dimensions?
A. Hierarchies help users understand the data through rollup levels within dimensions.
B. All hierarchies are defined by the inherent nature of their dimensional data.
C. It is considered poor design to split a hierarchy across multiple dimensions.
D. All dimensions must have hierarchies.
正解：A

質問 6：
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 following Cognos 8 components would BEST address their requirements?
A. Analysis Studio and Report Studio
B. Report Studio and Query Studio
C. Planning, Data Manager, and Report Studio
D. Data Manager and Analysis Studio
正解：D

質問 7：
Which of the following is a key difference between MDX and SQL?
A. MDX can reference metadata that SQL cannot.
B. MDX is used for dimensional style reporting while SQL is incapable of dimensional style reporting.
C. MDX has built in functions to support relative date calculations while SQL cannot perform relative date calculations.
D. Dimensionally Modeled Relational (DMR) retrieves data using MDX, not SQL.
正解：A