CS614 Quiz No.4 Shared by Israr (Solved)

Question # 1 of 10 ( Start time: 08:38:58 PM ) Total Marks: 1
“What means What”. The phrase refers to:
Select correct option:
Meta data     (CORRECT)
External data
Transformed data
Internal representations


Question # 2 of 10 ( Start time: 08:39:24 PM ) Total Marks: 1
In context of requirement definition phase of Kimball’s DWH development approach, ________ is positioned as a findings review and prioritization meeting.
Select correct option:
System analysis
Scope definition
Requirement configuration
Requirements wrap-up presentation     (CORRECT)


Question # 3 of 10 ( Start time: 08:40:06 PM ) Total Marks: 1
Vertically wide data means:
Select correct option:
Dataset has large no. of attributes
Dataset has large no. of records
Dataset has attribute skews
Dataset has partitioning skews


Question # 4 of 10 ( Start time: 08:40:48 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


Question # 5 of 10 ( Start time: 08:41:18 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(CORRECT)
None of the given options


Question # 6 of 10 ( Start time: 08:42:15 PM ) Total Marks: 1
Which of the following is/are example(s) of static attributes?
Select correct option:
Employee Name
Employee Date of Birth
Employee blood Group
All of the given options(CORRECT)


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


Question # 8 of 10 ( Start time: 08:43:45 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(CORRECT)
Planning system resources
Finding system scope
Data acquisition and cleansing


Question # 9 of 10 ( Start time: 08:44:23 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 # 10 of 10 ( Start time: 08:45:20 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(CORRECT)