CS614 Quiz No.4 Shared by Abdul_Mateen (Solved)

Question # 1 of 10 ( Start time: 01:03:34 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 (Page No. 336)
Planning system resources
Finding system scope
Data acquisition and cleansing


Question # 2 of 10 ( Start time: 01:04:15 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: 01:04:49 PM ) Total Marks: 1
Which of the following is NOT one of the top-10 mistakes that should be avoided during DWH development?
Select correct option:
Not interacting directly with end user
Not being an accommodating person (Page No. 316)
Isolating IT support people from business users
Training the users with dummy data and considering it success


Question # 4 of 10 ( Start time: 01:05:26 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  (Page No. 290)
Logical structure
Conceptual structure
System structure


Question # 5 of 10 ( Start time: 01:05:50 PM ) Total Marks: 1
Horizontally wide data means:
Select correct option:
Dataset has large no. of attributes  (Page No. 330) 
Dataset has large no. of records
Dataset has attribute skews
Dataset has partitioning skews


Question # 6 of 10 ( Start time: 01:06:21 PM ) Total Marks: 1
Improper documentation results the problem(s) like:
Select correct option:
Maintenance issue
New developers unable to configure already existing code
Lot of time required for enhancing the code
All of the given options


Question # 7 of 10 ( Start time: 01:06:54 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  (Page No. 290)


Question # 8 of 10 ( Start time: 01:07:31 PM ) Total Marks: 1
Normally the term “DWH face to the business user” refers to:
Select correct option:
Lifecycle technology track
Lifecycle Data track
Lifecycle Analytical Applications track
Lifecycle Maintenance track


Question # 9 of 10 ( Start time: 01:07:58 PM ) Total Marks: 1
In context of analytical applications track, the application development activity can begin after:
Select correct option:
Database design is complete
A subset of historical data has been loaded
The data access tools and metadata are installed
All of the given options (Page No. 307)


Question # 10 of 10 ( Start time: 01:08:37 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  (Page No. 309)