CS614 Quiz No.4 Shared by Zameer (UnSolved)

Question # 1 of 10 ( Start time: 09:46:34 PM ) Total Marks: 1
Three parallel tracks in kimbal’s DWH development approach converge at _______ Phase
Select correct option:
Project planning
Business requirement definition
Deployment
Maintenance and growth


Question # 2 of 10 ( Start time: 09:46:57 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 # 3 of 10 ( Start time: 09:47: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 # 3 of 10 ( Start time: 09:47:25 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 # 5 of 10 ( Start time: 09:48:10 PM ) Total Marks: 1
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:
Select correct option:
Requirement preplanning
Business requirements collection
Post collection
None of the given options


Question # 6 of 10 ( Start time: 09:48:31 PM ) Total Marks: 1
Which of the following is/are included in the list of Top-7 key steps for smooth DWH implementation?
Select correct option:
Consider handing-off project management
Assign significant resources for ETL
Be a diplomat NOT a technologist
All of the given options


Question # 7 of 10 ( Start time: 09:48:47 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 # 8 of 10 ( Start time: 09:49:02 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:49:15 PM ) Total Marks: 1
Implementation of a data warehouse requires ________ activities
Select correct option:
Highly integrated
Loosely integrated
Tightly decoupled
None of the given


Question # 10 of 10 ( Start time: 09:49:27 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