CS614 Final Term Solved MCQs by VU Malik

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 applicationsis:

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 developmentapproach, 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

d.

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

1. Naming conventions
2. Standard for calculations
3. Standard for libraries
4. In lifecycle data track, we begin with translating the requirements into dimensional model, which then transforms into a.

1. Logical structure
2. Conceptual structure
3. System structure
4. 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

d.

12. A top down implementation approach is useful when a. b. Organization can not implement latest technologies c. Business objectives are unclear d. Problem to be solved are not well documented

Q13. Which of the following is NOT one of the possible pitfalls in DWH LifeCycle & 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 forsmooth DWH implementation?

1. Consider handing-off project management

Technology is mature and well understood · (I), (II) and (III) · Physical structure · Requirements wrap-up presentation · d. All of the given options · d. 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

typical cycle of implementing the change in DWH comprises of thesequence: a. Production -> QA -> Development

c. Development -> Production-> QA d. Production-> Development -> QA

17. In phase of a fundamental data warehouse life cycle model, a working model of data warehouse is deployed for a selective set of users a. Design

c. Deployment d. Operation

Q18. In context of requirement definition phase in Kimball's DWH developmentapproach, 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 Kimballsapproach?

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

bottom up implementation approach is useful when

d. 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