vu cs614 Final Term - Quiz No.4
vu cs614 Data Warehousing Quiz
This quiz belongs to book/course code vu cs614 Data Warehousing of vu organization. We have 13 quizzes available related to the book/course Data Warehousing. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Final Term. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 2: The Kimball s iterative data warehouse development approach drew on decades of experience to develop the __________.
Business Dimensional Lifecycle
Data Warehouse Dimension
Business Definition Lifecycle
OLAP Dimension
Question 3: __________ contributes to an under-utilization of valuable and expensive historical data, and inevitably results in a limitedcapability to provide decision support and analysis.
The lack of data integration and standardization
Missing Data
Data Stored in Heterogeneous Sources
Question 4: D-Normalization speeds up __________
Data Retrieval
Data Duplication
Data Extraction
Data Loading
Question 5: It is observed that every year the amount of data recorded in anorganization is
Doubles
Triples
Quartiles
Remains same as previous year
Question 6: For good decision making, data should be integrated across the organization to cross the LoB (Line of Business). This is to give the total view of organization from:
Owner's Perspective
Customer's Perspective
Decision Maker's Perspective
Employee's Perspective
Question 7: __________ is class of Decision Support Environment.
OLTP
OLAP
DBMS
Network
Question 8: A data warehouse may include
Legacy systems
Only internal data sources
Privacy restrictions
Small data mart
Question 9: Node of a B-Tree is stored in memory block and traversing a B-Tree involves __________ page faults.
O (n lg n)
O (lg n)
O (n)
O (n2)
Question 10: The need to synchronize data upon update is called
Data Manipulation
Data Replication
Data Coherency
Data Imitation
