CS614 Quiz No.4 Shared by MT Khan (Solved)

Question # 1 of 10 ( Start time: 09:04:39 PM ) Total Marks: 1
A typical cycle of implementing the change in DWH comprises of the sequence:
Select correct option:
Production -> QA -> Development
Development-> QA -> Production(CORRECT)
Development -> Production -> QA
Production -> Development -> QA


Question # 2 of 10 ( Start time: 09:05:16 PM ) Total Marks: 1
Vertically wide data means:
Select correct option:
Dataset has large no. of attributes
Dataset has large no. of records(CORRECT)
Dataset has attribute skews
Dataset has partitioning skews


Question # 3 of 10 ( Start time: 09:05:43 PM ) Total Marks: 1
In ___________ phase of kimballs approach, we identify the components needed now and in future.
Select correct option:
Requirement definition
Architectural design
Product development
Analytical application development


Question # 4 of 10 ( Start time: 09:06:56 PM ) Total Marks: 1
Technical architecture design supports the communication about technical requirements: I) Within the team II) Upward to management III) Outward to vendors
Select correct option:
(I) only
(II) Only
(III) Only
(I), (II) and (III)(CORRECT)


Question # 5 of 10 ( Start time: 09:07:28 PM ) Total Marks: 1
Implementation of a data warehouse requires ________ activities
Select correct option:
Highly integrated
Loosely integrated
Tightly decoupled(CORRECT)
None of the given


Question # 6 of 10 ( Start time: 09:07:54 PM ) Total Marks: 1
In Four Cell Quadrant Technique, The quadrant's vertical axis refers to:
Select correct option:
Scope
Feasibility
Resources available
The potential impact or value to the business(CORRECT)


Question # 7 of 10 ( Start time: 09:08:22 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(CORRECT)


Question # 8 of 10 ( Start time: 09:09:25 PM ) Total Marks: 1
Which of the following is NOT one of the examples of dynamic attributes?
Select correct option:
Daily Sale
Date of Birth
Air pressure
None of the given options


Question # 9 of 10 ( Start time: 09:10: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    (CORRECT)


Question # 10 of 10 ( Start time: 09:10:52 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(CORRECT)
Isolating IT support people from business users
Training the users with dummy data and considering it success