CS614 Quiz 2 Solution by MCS

CS614 - Data Warehousing · Quiz # 2 February 2021 · If found any correction needed do it accordingly

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

1. They are documented
2. They extracted and verified
3. Data warehouse is populated page 285
4. All the schemas are defined

Correct answer: Data warehouse is populated page 285

Q2. Spiral model is ________

1. Sequence of waterfall model page 284
2. Risk oriented model
3. An iterative model
4. All of the given options

Correct answer: Sequence of waterfall model page 284

Q3. Waterfall is a/an _______ model

1. Iterative
2. Simple linear sequential page 284
3. Object oriented
4. Rapid development

Correct answer: Simple linear sequential page 284

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
4. All of the given options

Correct answer: All of the given options

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
4. All of the given options

Correct answer: All of the given options

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

1. Data driven page 285
2. Resource driven
3. Requirement driven
4. Time sensitive

Correct answer: Data driven page 285

Q7. Horizontally wide data means:

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

Correct answer: Dataset has large no. of attributes

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. Requirements wrap-up presentation

Correct answer: 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
4. All of the given options page 307

Correct answer: All of the given options page 307

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

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

Correct answer: Physical structure page 290

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) page 300

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

Q12. A top down implementation approach is useful when

1. Technology is mature and well understood page 283
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 page 283

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. None of the given options page 312, 313, 314

Correct answer: None of the given options page 312, 313, 314

Q14. Goal driven approach of data warehouse development was result of _______ work.

1. Bill Inmon
2. Ralph Kimball
3. Bohnlein and Ulbrich-vom page 285
4. Westerman

Correct answer: Bohnlein and Ulbrich-vom page 285

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. Assign significant resources for ETL
3. Be a diplomat NOT a technologist
4. All of the given options page 318, 319

Correct answer: All of the given options page 318, 319

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

1. Production -> QA -> Development
2. Development -> QA -> Production page 314
3. Development -> Production-> QA
4. Production-> Development -> QA

Correct answer: Development -> QA -> Production page 314

Q17. 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. Prototype page 287
3. Deployment
4. Operation

Correct answer: Prototype page 287

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. Post collection page 294
4. None of the given options

Correct answer: Post collection page 294