vu cs614 Final Term - Quiz No.8
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 1: __________ is the technique in which existing heterogeneous segments are reshuffled, relocated into homogeneous segments.
Clustering
Aggregation
Segmentation
Partitioning
Question 3: Non uniform distribution, when the data is distributed across the processors, is called __________.
Skew in Partition
Pipeline Distribution
Distributed Distribution
Uncontrolled Distribution
Question 5: For a given data set, to get a global view in un-supervised learning we use
One-way Clustering
Bi-clustering
Pearson correlation
Euclidean distance
Question 6: __________ modeling technique is more appropriate for data warehouses.
entity-relationship
dimensional
physical
None of the given
Question 7: Taken jointly, the extract programs or naturally evolving systems formed a spider web, also known as
Distributed Systems Architecture
Legacy Systems Architecture
Online Systems Architecture
Intranet Systems Architecture
Question 8: A __________ dimension is a collection of random transactional codes, flags and/text attributes that are unrelated to any particular dimension. The __________ dimension is simply a structure that provides a convenient place to store the __________ attributes.
Junk
Time
Parallel
None of these
Question 9: The STAR schema used for data design is a __________ consisting of fact and dimension tables.
Network model
Relational model
Hierarchical data model
None of the given
Question 10: There are many variants of the traditional nested-loop join. If the index is built as part of the query plan and subsequently dropped, it is called __________.
Naive nested-loop join
Index nested-loop join
Temporary index nested-loop join
None of the given
