CS614 Final Term Solved MCQs Set 4 by Junaid

Q1. Bill Inmon argues that requirements are well understood only after

1. They are documented
2. They extracted and verified
3. All the schemas are defined

Q2. Spiral model is

1. Risk oriented model
2. An iterative model
3. All of the given options
4. Waterfall is a/an model

1. Iterative
2. Object oriented
3. Rapid development

Q4. An effective user education program includes, among others, the following guideline(s);

1. Understand the audience, don’t overwhelm
2. Train after delivery of data and analytic applications
3. Postpone education, if DWH not ready

Q5. One of the drawbacks of waterfall model is that:

1. Customers can not review the product during development
2. It does not work when the resources are limited
3. It does not define the project timeline/schedule

Q6. As per Bill Inmon, a data warehouse, in contrast with classical applications is:

1. Resource driven
2. Requirement driven
3. Time sensitive

Q7. Horizontally wide data means:

1. Dataset has large no. of records
2. Dataset has attribute skews
3. Dataset has partitioning skews

Q8. In context of requirement definition phase of Kimball’s DWH development approach, is positioned as a findings review and prioritization meeting.

1. System analysis
2. Scope definition
3. Requirement configuration
4. Data driven
5. Data warehouse is populated
6. Sequence of waterfall model
7. Simple linear sequential
8. All of the given options
9. All of the given options
10. Dataset has large no. of attributes
11. Requirements wrap-up presentation

Q9. In analytical application development phase, we follow standards for:

1. Naming conventions
2. Standard for calculations
3. Standard for libraries

Q10. In lifecycle data track, we begin with translating the requirements into dimensional model, which then transforms into

1. Physical structure
2. Logical structure
3. Conceptual structure
4. System structure

Correct answer: Physical structure

11. Technical architecture design supports the communication about technical requirements: I. Within the team II. Upward to management III. Outward to vendors

1. (I) Only
2. (II) Only
3. (III) Only
4. (I), (II) and (III)

Correct answer: (I), (II) and (III)

Q12. A top down implementation approach is useful when

1. Technology is mature and well understood
2. Organization can not implement latest technologies
3. Business objectives are unclear
4. Problem to be solved are not well documented

Correct answer: Technology is mature and well understood

Q13. Which of the following is NOT one of the possible pitfalls in DWH Life Cycle & Development?

1. Not having multiple servers
2. Low priority OLAP Cube Construction
3. Improper documentation
4. Goal driven approach of data warehouse development was result of work.

1. Bill Inmon
2. Ralph Kimball
3. Westerman

Q15. Which of the following is/are included in the list of Top-7 key steps for smooth DWH implementation?

1. Consider handing-off project management
2. All of the given options
3. None of the given options

page 312, 313, 314

c. Bohnlein and Ulbrich-vom

b. Assign significant resources for ETL c. Be a diplomat NOT a technologist

Q16. A typical cycle of implementing the change in DWH comprises of the sequence:

1. Production -> QA -> Development
2. Development -> Production-> QA
3. Production-> Development -> QA
4. In phase of a fundamental data warehouse life cycle model, a working model of data warehouse is deployed for a selective set of users

1. Design
2. Deployment
3. Operation

Q18. In context of requirement definition phase in Kimball's DWH development approach, activities like debriefing, documentation, and prioritization are considered to be the part of

1. Requirement preplanning
2. Business requirements collection
3. None of the given options

Q19. Which of the following is NOT one of the three parallel tracks in Kimballs approach?

1. Lifecycle technology track
2. Lifecycle data track

e. Lifecycle analytical applications track

Q19. Normally the term “DWH face to the business user” refers to:

1. Lifecycle technology track
2. Lifecycle data track
3. Lifecycle maintenance track

Q20. In Four Cell Quadrant Technique. The quadrant’s vertical axis refers to:

1. Scope
2. Feasibility
3. Resources available

Q21. Improper documentation results the problem(s) like:

1. Maintenance issue
2. New developers unable to configure already existing code
3. Lot of time required for enhancing the code
4. All of the given options

Correct answer: All of the given options

Q22. A bottom-up implementation approach is useful when

1. All of the given options

page 318, 319 · b. Development -> QA -> Production · b. Prototype · c. Post collection · d. Lifecycle maintenance track · c. Lifecycle analytical applications track · d. The potential impact or value to the business