CS614 Quiz No.4 Shared by Jea (UnSolved)

Question # 1 of 10 ( Start time: 09:18:31 PM ) Total Marks: 1
Which of the following activity/activities is/are part of project planning phase in Kimballs DWH development approach?
Select correct option:
Obtain resources
Establish the preliminary scope and justification
Assess organization's readiness for a data warehouse initiative
All of the given options


Question # 2 of 10 ( Start time: 09:19:20 PM ) Total Marks: 1
Users do not care, how advance the front end of your DWH is, what they care is that:
Select correct option:
Tables should be properly denormalized
Proper partitioning technique should be used
At least star or snow flake schema should be implemented
They should get information in timely manner and the way they want


Question # 3 of 10 ( Start time: 09:19:50 PM ) Total Marks: 1
In analytical application development phase, we follow standards for:
Select correct option:
Naming conventions
Standard for calculations
Standards for libraries
All of the given options


Question # 4 of 10 ( Start time: 09:20:22 PM ) Total Marks: 1
Goal driven approach of data warehouse development was result of ______ work
Select correct option:
Bill Inmon
Ralph Kimball
Böhnlein and Ulbrich-vom
Westerman


Question # 5 of 10 ( Start time: 09:20:57 PM ) Total Marks: 1
Which of the following is NOT one of the possible pitfalls in DWH Life Cycle & Development?
Select correct option:
Not having multiple servers
Low priority for OLAP Cube Construction
Improper documentation
None of the given options


Question # 6 of 10 ( Start time: 09:22:00 PM ) Total Marks: 1
Which of the following is NOT one of the activities of “Maintenance and Growth” phase in Kimball’s DWH development approach?
Select correct option:
Education
Technical Education
Program Support
Interface Deployment


Question # 7 of 10 ( Start time: 09:22:19 PM ) Total Marks: 1
The first step of the “12-steps data warehouse implementation approach” of Shaku Atre is:
Select correct option:
Finding user needs
Planning system resources
Finding system scope
Data acquisition and cleansing


Question # 8 of 10 ( Start time: 09:23:27 PM ) Total Marks: 1
In lifecycle data track, we begin with translating the requirements into dimensional model, which then transforms into ______
Select correct option:
Physical structure
Logical structure
Conceptual structure
System structure


Question # 9 of 10 ( Start time: 09:23:53 PM ) Total Marks: 1
An effective user education program includes, among others, the following guideline(s):
Select correct option:
Understand the audience, don’t overwhelm
Train after delivery of data and analytic applications
Postpone education, if DWH not ready
All of the given options


Question # 10 of 10 ( Start time: 09:24:14 PM ) Total Marks: 1
The phase-3 i.e. “Rollout and Maintenance” phase in “12-steps data warehouse implementation approach” of Shaku Atre comprises of _______ activity.
Select correct option:
On Line Analytical Processing
Construct Metadata Repository
Deployment & System Management
None of the given options