Exambible

1.Which of the following is a significant cause of failure when using the technology-focused approach to BI Application development?
A. Users often have difficulty understanding new technology.
B. New technology often contains internal flaws and errors that affect the delivered solution.
C. The solution is focused on a single subject area.
D. Developers often focus on just the data.
Answer: D


2.Which of the following BEST describes the relationship or differences between Iterative Approach and Cognos SIM?
A. The Iterative Approach is a specific technique used to iterate through the Design phase.
B. The Iterative Approach is a series of steps defined in the Analysis and Development phases of Cognos SIM.
C. The Iterative Approach is a philosophy of development while Cognos SIM is a collection of tasks, documents, and techniques to guide development.
D. Cognos SIM is the current Cognos development standard and is intended to replace the Iterative Approach for development of BI applications.
Answer: C


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


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


5.Which of the following MOST clearly states the value of using a methodology?
A. It provides a philosophy of development that maximizes return on investment.
B. It helps consultants progress in a systematic way to insure all critical steps are addressed.
C. It helps project managers estimate the cost and effort in developing a solution.
D. It ensures that early mistakes are avoided in developing a solution.
Answer: B


6.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 understand their business processes but they don't usually understand application development.
C. No developed solution will satisfy all users equally.
D. Users often feel that IT does not understand the business.
Answer: A


7.Which of the following statements best describes the Iterative Approach of application development?
A. A prototype solution is developed after the initial user interviews. This prototype is then used as a basis for refining specific design requirements.
B. The design step is repeated multiple times before proceeding to the development step. Each pass through the design step further refines the eventual solution.
C. The solution is developed and delivered to the users. After approximately 2 weeks, the users are interviewed for any missing requirements and any new requirements form the basis for the next iteration.
D. A prototype is created that addresses 80 to 90% of the business requirements. This is demonstrated to the users and their feedback is used to refine the prototype in subsequent iterations.
Answer: D


8. 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 columns
B. Tables with the greatest number of rows
C. Tables with the greatest number of foreign keys
D. Tables with the fewest number of foreign keys
Answer: B