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
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.
3 / 50
In DWH project, it is assured that ___________ environment is similar to the production environment
4 / 50
Which statement is true for De-Normalization?
5 / 50
The goal of ______is to look at as few block as possible to find the matching records.
6 / 50
A dense index, if fits into memory, costs only ______ disk I/O access to locate a record by given key.
7 / 50
Data mining evolve as mechanism to cater the limitations of _____ systems to deal massive data sets with high dimensionality, new data types, multiple heterogeneous data resources etc...
8 / 50
Data Warehouse provides the best support for analysis while OLAP carries out the _________ task.
9 / 50
There are many variants of the traditional nested-loop join, if there is an index is exploited, then it is called……
10 / 50
Data mining is a/an __________ approach, where browsing through data using data mining techniques may reveal something that might be of interest to the user as information that was unknown previously.
11 / 50
As apposed to the out come of classification, estimation deal with ____________ valued outcome.
12 / 50
During the application specification activity, we also must give consideration to the organization of the applications.
13 / 50
For a given data set, to get a global view in un-supervised learning we use
14 / 50
Grain is the ________ level of data stored in the warehouse.
15 / 50
Non uniform distribution, when the data is distributed across the processors, is called ______.
16 / 50
The Kimball s iterative data warehouse development approach drew on decades of experience to develop the _________.
17 / 50
Investing years in architecture and forgetting the primary purpose of solving business problems, results in inefficient application. This is the example of _________ mistake.
18 / 50
____________ in agriculture extension is that pest population beyond which the benefit of spraying outweighs its cost.
19 / 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.
20 / 50
The users of data warehouse are knowledge workers in other words they are _______in the organization.
21 / 50
To identify the __________________ required we need to perform data profiling
22 / 50
Pipeline parallelism focuses on increasing throughput of task execution, NOT on __________ sub-task execution time.
23 / 50
The growth of master files and magnetic tapes exploded around the mid- _______. :
24 / 50
To measure or quantify the similarity or dissimilarity, different techniques are available. Which of the following option represent the name of available techniques?
25 / 50
.______ is class of Decision Support Environment.
26 / 50
The goal of star schema design is to simplify ________
27 / 50
________ is the technique in which existing heterogeneous segments are reshuffled, relocated into homogeneous segments.
28 / 50
Many data warehouse project teams waste enormous amounts of time searching in vain for a _______.
29 / 50
DTS allows us to connect through any data source or destination that is supported by ____________
30 / 50
Slice and Dice is changing the view of the data.
31 / 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:
32 / 50
If every key in the data file is represented in the index file then index is :
33 / 50
The automated, prospective analyses offered by data mining move beyond the analysis of past events provided by respective tools typical of ___________.
34 / 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.
35 / 50
36 / 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?
37 / 50
Multidimensional databases typically use proprietary __________ format to store pre-summarized cube structures.
38 / 50
It is observed that every year the amount of data recorded in anorganization is
39 / 50
Taken jointly, the extract programs or naturally evolving systems formed a spider web, also known as
40 / 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 ___________
41 / 50
In horizontal splitting, we split a relation into multiple tables on the basis of
42 / 50
in agriculture extension is that pest population beyond which the benefit of spraying outweighs levels
43 / 50
De-Normalization normally speeds up
44 / 50
Ad-hoc access means to run such queries which are known already.
45 / 50
Analytical processing uses ____________ , instead of record level access.
46 / 50
The purpose of the House of Quality technique is to reduce ______ types of risk.
47 / 50
48 / 50
_____________ is a process which involves gathering of information about column through execution of certain queries with intention to identify erroneous records.
49 / 50
Suppose the amount of data recorded in an organization is doubled every year. This increase is __________ .
50 / 50
________ gives total view of an organization
Your score is
The average score is 0%
Restart quiz
