/
Lifecycle Track
Save to my account
Sign up
Report Bug
Lifecycle Track
View
Lecture 3_ Kimball Lifecycle and Dimensional Modelling_DWM.pptx_removed.pdf Flashcards
Study
Question
What is the aim of the SDLC?
Answer
The SDLC aims to produce a high-quality software that meets or exceeds customer expectations, reaches completion within time and cost estimates.
Question
What is the purpose of the technical architecture in the SDLC?
Answer
The technical architecture is the blueprint for the DWBI environments, technical services, and infrastructure.
Question
What are the steps involved in establishing the architecture?
Answer
1. Establish Architecture Task Force 2. Collect Architecture-related Requirements 3. Document Architecture Requirements 4. Create the Architecture Model 5. Determine Architecture Implementation Phases 6. Design and Specify Subsystems 7. Create the Architecture Plan 8. Finalize and Review Technical Architecture.
Question
What is the architecture plan similar to?
Answer
The architecture plan is similar to a shopping list for selecting products that fit into the plans framework.
Question
What are the steps to product selection and installation in the SDLC?
Answer
1. Understand Corporate Purchasing Process 2. Develop Product Evaluation Matrix 3. Conduct Market Research 4. Evaluate a Shortlist of Options 5. If Necessary, Conduct a Prototype 6. Select Product 7. Install Trial and Negotiate.
Question
What does the Physical Design phase involve in the Kimball Lifecycle?
Answer
The Physical Design phase involves translating dimensional models into a physical database and includes the following activities: 1. Develop Naming and Database Standards 2. Develop Physical Database Model 3. Develop Initial Index Plan 4. Design Aggregations including OLAP Database 5. Finalize Physical Storage Details.
Question
What is the focus during the BI Application Specification phase?
Answer
During the BI Application Specification phase, it is helpful to establish standards such as common pulldown menus and consistent output look and feel.
Question
What should be revisited during BI Application Development?
Answer
The BI application template specifications should be revisited to account for changes to the model since the specifications were completed.
Question
What is involved in the Deployment phase of the BI Application Track?
Answer
Deployment refers to the process of making the application work on a target device, whether it be a test server, production environment, or a user's computer or mobile device.
Question
What are the key aspects of Maintenance and Growth after deployment?
Answer
a. User support is crucial following deployment. b. A continuing education program for the DW BI system must be provided. c. Technical support should treat the DWBI system as a production environment with service level agreements. d. The DWBI program continues beyond the implementation of a single phase.
Question
What are some pitfalls to avoid in the Kimball Lifecycle?
Answer
The document does not specify the pitfalls to avoid in the Kimball Lifecycle.
