CS614-Midterm
1 / 50
The degree of similarity between two records, often measured by a numerical value between _______, usually depends on application characteristics.
2 / 50
During ETL process of an organization, suppose you have data which can be transformed using any of the transformation method. Which of the following strategy will be your choice for least complexity?
3 / 50
Suppose the amount of data recorded in an organization is doubled every year. This increase is __________ .
4 / 50
The purpose of the House of Quality technique is to reduce ______ types of risk.
5 / 50
Slice and Dice is changing the view of the data.
6 / 50
Pipeline parallelism focuses on increasing throughput of task execution, NOT on __________ sub-task execution time.
7 / 50
Analytical processing uses ____________ , instead of record level access.
8 / 50
Data mining evolve as a mechanism to cater the limitations of ________ systems to deal massive data sets with high dimensionality, new data types, multiple heterogeneous data resources etc.
9 / 50
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
10 / 50
________ gives total view of an organization
11 / 50
During the application specification activity, we also must give consideration to the organization of the applications.
12 / 50
The key idea behind ___________ is to take a big task and break it into subtasks that can be processed concurrently on a stream of data inputs in multiple, overlapping stages of execution.
13 / 50
The goal of star schema design is to simplify ________
14 / 50
Multidimensional databases typically use proprietary __________ format to store pre-summarized cube structures.
15 / 50
: An optimized structure which is built primarily for retrieval, with update being only a secondary consideration is
16 / 50
DTS allows us to connect through any data source or destination that is supported by ____________
17 / 50
18 / 50
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.
19 / 50
20 / 50
For a given data set, to get a global view in un-supervised learning we use
21 / 50
22 / 50
Many data warehouse project teams waste enormous amounts of time searching in vain for a _______.
23 / 50
Data Warehouse provides the best support for analysis while OLAP carries out the _________ task.
24 / 50
_________ breaks a table into multiple tables based upon common column values.
25 / 50
To identify the __________________ required we need to perform data profiling
26 / 50
27 / 50
It is observed that every year the amount of data recorded in an organization :
28 / 50
For a DWH project, the key requirement are ________ and product experience.
29 / 50
Multi-dimensional databases (MDDs) typically use ___________ formats to store pre-summarized cube structures.
30 / 50
To judge effectiveness we perform data profiling twice.
31 / 50
Cube is a __________ entity containing values of a certain fact at a certain aggregation level at an intersection of a combination of dimensions.
32 / 50
________ is the technique in which existing heterogeneous segments are reshuffled, relocated into homogeneous segments.
33 / 50
When performing objective assessments, companies follow a set of principles to develop metrics specific to their needs, there is hard to have “one size fits all” approach. Which of the following statement represents the pervasive functional forms?
34 / 50
The need to synchronize data upon update is called
35 / 50
The goal of ______is to look at as few block as possible to find the matching records.
36 / 50
37 / 50
Change Data Capture is one of the challenging technical issues in _____________
38 / 50
Naturally Evolving architecture occurred when an organization had a _______ approach to handling the whole process of hardware and software architecture.
39 / 50
To measure or quantify the similarity or dissimilarity, different techniques are available. Which of the following option represent the name of available techniques?
40 / 50
Data Transformation Services (DTS) provide a set of _____ that lets you extract, transform, and consolidate data from disparate sources into single or multiple destinations supported by DTS connectivity.
41 / 50
_______________, if too big and does not fit into memory, will be expensive when used to find a record by given key.
42 / 50
The technique that is used to perform these feats in data mining modeling, and this act of model building is something that people have been doing for long time, certainly before the _______ of computers or data mining technology.
43 / 50
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:
44 / 50
In a traditional MIS system, there is an almost linear sequence of queries.
45 / 50
For a relation to be in 4NF it must be:-
46 / 50
Execution can be completed successfully or it may be stopped due to some error. In case of successful completion of execution all the transactions will be ___________
47 / 50
Pre-computed _______ can solve performance problems
48 / 50
49 / 50
50 / 50
Pakistan is one of the five major ________ countries in the world.
Your score is
The average score is 0%
Restart quiz
