CS614 Data Warehousing Solved Quiz By MMA(Awi)

CS614 Data Warehousing Solved Quiz By MMA(Awi)

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) 

Question # 1 of 10
“What means What”. The phrase refers to: 
Select correct option: 
Meta data 
External data 
Transformed data 
Internal representations

Question # 2 of 10
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 # 3 of 10
Horizontally 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
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
      Isolating IT support people from business users
      Training the users with dummy data and considering it success
     
Question # 5 of 10
Which of the following is NOT one of the examples of dynamic attributes?
Select correct option:
      Daily Sale
      Date of Birth cnfim not
      Air pressure
      None of the given options
     
Question # 6 of 10
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
     
Question # 7 of 10 ( Start time: 12:30:29 AM )      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 # 8 of 10
Which of the following activity executes parallel with all other activities in Kimball’s DWH development approach?
Select correct option:
      Requirement elicitation
      Project Planning
      Project management
      Deployment

Question # 9 of 10
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 # 10 of 10 ( Start time: 12:33:02 AM )   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 # 1 of 10 ( Start time: 09:16:07 PM ) Total Marks: 1
As opposed to the outcome of classification, estimation deals with __________ valued outcome.
Select correct option:
Discrete  (Correct)
Isolated
Continuous
Distinct


Question # 2 of 10 ( Start time: 09:17:12 PM ) Total Marks: 1
In ________learning you don’t know the number of clusters and no idea about their attributes.
Select correct option:
Supervised learning
Unsupervised learning  (Correct)
Multi Dimension modeling
None of the given options


Question # 3 of 10 ( Start time: 09:18:06 PM ) Total Marks: 1
Identify the TRUE statement:
Select correct option:
Clustering is unsupervised learning and classification is supervised learning  (Correct)
Clustering is supervised learning and classification is unsupervised learning
Both clustering and classification are unsupervised learning
Both clustering and classification are supervised learning


Question # 4 of 10 ( Start time: 09:19:17 PM ) Total Marks: 1
Waterfall model is appropriate when
Select correct option:
When the budget is low
When the deadline is strict
When resources are limited
Requirements are clearly defined  (Correct)


Question # 5 of 10 ( Start time: 09:19:45 PM ) Total Marks: 1
Spiral model is ________
Select correct option:
Sequence of waterfall model
Risk oriented model
An iterative model
All of the given options  (Correct)


Question # 6 of 10 ( Start time: 09:20:19 PM ) Total Marks: 1
As per Bill Inmon, a data warehouse, in contrast with classical applications is:
Select correct option:
Data driven  (Correct)
Resource driven 
Requirement driven
Time sensitive


Question # 7 of 10 ( Start time: 09:21:13 PM ) Total Marks: 1
In ______ phase of a fundamental data warehouse life cycle model, a working model of data warehouse is deployed for a selective set of users
Select correct option:
Design
Prototype  (Correct)
Deployment
Operation


Question # 8 of 10 ( Start time: 09:22:23 PM ) Total Marks: 1
Which of the following is the most ignored step during data warehouse development
Select correct option:
The requirement verification
The vision definition
Schema validation
Success criteria development


Question # 9 of 10 ( Start time: 09:23:53 PM ) Total Marks: 1
In data mining, initially you _____ what you are lo(Correct)ing for.
Select correct option:
Know
Don’t know  (Correct)
May or may not know
None of the given options


Question # 10 of 10 ( Start time: 09:24:59 PM ) Total Marks: 1
A top down implementation approach is useful when
Select correct option:
Technology is mature and well understood  (Correct)
Organization cannot implement latest technologies
Business objectives are unclear
Problem to be solved are not well documented

Question # 1 of 10 ( Start time: 09:41:54 PM ) Total Marks: 1
________ is the technique in which existing heterogeneous segments are reshuffled, relocated into homogeneous segments.
Select correct option:
Clustering  (Correct)
Aggregation
Segmentation
Partitioning


Question # 2 of 10 ( Start time: 09:42:16 PM ) Total Marks: 1
Waterfall is a/an ______ model
Select correct option:
Iterative
Simple linear sequential  (Correct)
Object Oriented
Rapid development


Question # 3 of 10 ( Start time: 09:42:43 PM ) Total Marks: 1
________ refers to the overall process of discovering useful knowledge from data and data mining refers to a particular step in this process.
Select correct option:
Statistics
Knowledge discovery in database  (Correct)
Clustering


Question # 4 of 10 ( Start time: 09:43:20 PM ) Total Marks: 1
In contrast to data mining, statistics is ______ driven.
Select correct option:
Assumption  (Correct)
Knowledge
Discovery


Question # 5 of 10 ( Start time: 09:43:42 PM ) Total Marks: 1
Bill Inmon argues that requirements are well understood only after
Select correct option:
They are documented
They extracted and verified  (Correct)
Data warehouse is populated
All the schemas are defined


Question # 6 of 10 ( Start time: 09:44:18 PM ) Total Marks: 1
Spiral model is ________
Select correct option:
Sequence of waterfall model
Risk oriented model
An iterative model
All of the given options  (Correct)


Question # 7 of 10 ( Start time: 09:44:38 PM ) Total Marks: 1
One of the drawbacks of waterfall model is that:
Select correct option:
Customers can not review the product during development
It does not work when the resources are limited
It does not define the project timeline/schedule
All of the given options  (Correct)


Question # 8 of 10 ( Start time: 09:45:04 PM ) Total Marks: 1
Which of the following is NOT one of the methodologies for Data Warehouse project development?
Select correct option:
Goal Driven
Data Driven
User Driven
System Driven  (Correct)


Question # 9 of 10 ( Start time: 09:45:26 PM ) Total Marks: 1
In context of clustering, the term “distance” means:
Select correct option:
Similarity/dissimilarly of records  (Correct)
The difference between the primary keys of two records
The relation of a record with corresponding record in child table


Question # 10 of 10 ( Start time: 09:45:46 PM ) Total Marks: 1
Identify the TRUE statement:
Select correct option:
Clustering is unsupervised learning and classification is supervised learning  (Correct)
Clustering is supervised learning and classification is unsupervised learning
Both clustering and classification are unsupervised learning
Both clustering and classification are supervised learning