CS614-Midterm
1 / 50
In _________ system, the contents change with time. :
2 / 50
The _________ is only a small part in realizing the true business value buried within the mountain of data collected and stored within organizations business systems and operational databases.
3 / 50
_________ breaks a table into multiple tables based upon common column values.
4 / 50
Pipeline parallelism focuses on increasing throughput of task execution, NOT on __________ sub-task execution time.
5 / 50
If every key in the data file is represented in the index file then index is :
6 / 50
30.Data Warehouse is about taking / colleting data from different ________ sources:
7 / 50
Data mining derives its name from the similarities between searching for valuable business information in a large database, for example, finding linked products in gigabytes of store scanner data, and mining a mountain for a _________ of valuable ore.
8 / 50
During the application specification activity, we also must give consideration to the organization of the applications.
9 / 50
We must try to find the one access tool that will handle all the needs of their users.
10 / 50
Grain is the ________ level of data stored in the warehouse.
11 / 50
With data mining, the best way to accomplish this is by setting aside some of your data in a vault to isolate it from the mining process; once the mining is complete, the results can be tested against the isolated data to confirm the model's _______.
12 / 50
The users of data warehouse are knowledge workers in other words they are _______in the organization.
13 / 50
Horizontal splitting breaks a table into multiple tables based upon_______
14 / 50
De-Normalization normally speeds up
15 / 50
Normalization effects performance
16 / 50
Companies collect and record their own operational data, but at the same time they also use reference data obtained from _______ sources such as codes, prices etc.
17 / 50
People that design and build the data warehouse must be capable of working across the organization at all levels
18 / 50
DTS allows us to connect through any data source or destination that is supported by ____________
19 / 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.
20 / 50
_______ is an application of information and data.
21 / 50
If w is the window size and n is the size of data set, then the complexity of merging phase in BSN method is___________
22 / 50
For a given data set, to get a global view in un-supervised learning we use
23 / 50
_______________, if too big and does not fit into memory, will be expensive when used to find a record by given key.
24 / 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.
25 / 50
If someone told you that he had a good model to predict customer usage, the first thing you might try would be to ask him to apply his model to your customer _______, where you already knew the answer.
26 / 50
27 / 50
Analytical processing uses ____________ , instead of record level access.
28 / 50
29 / 50
30 / 50
Data mining is a/an ______ approach , where browsing through data using mining techniques may reveal something that might be of interest to the user as information that was unknown previously.
31 / 50
The degree of similarity between two records, often measured by a numerical value between _______, usually depends on application characteristics.
32 / 50
NUMA stands for __________
33 / 50
Collapsing tables can be done on the ___________ relationships
34 / 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:
35 / 50
Naturally Evolving architecture occurred when an organization had a _______ approach to handling the whole process of hardware and software architecture.
36 / 50
It is observed that every year the amount of data recorded in an organization :
37 / 50
A data warehouse implementation without an OLAP tool is always possible.
38 / 50
in agriculture extension is that pest population beyond which the benefit of spraying outweighs levels
39 / 50
DOLAP allows download of “cube” structures to a desktop platform with the need for shared relational or cube server.
40 / 50
Which statement is true for De-Normalization?
41 / 50
Pre-join technique is used to avoid
42 / 50
For a DWH project, the key requirement are ________ and product experience.
43 / 50
5 million bales.
44 / 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.
45 / 50
The divide & conquer cube partitioning approach helps alleviate the ____________ limitations of MOLAP implementation.
46 / 50
Multidimensional databases typically use proprietary __________ format to store pre-summarized cube structures.
47 / 50
There are many variants of the traditional nested-loop join, if there is an index is exploited, then it is called……
48 / 50
: An optimized structure which is built primarily for retrieval, with update being only a secondary consideration is
49 / 50
A dense index, if fits into memory, costs only ______ disk I/O access to locate a record by given key.
50 / 50
It is observed that every year the amount of data recorded in anorganization is
Your score is
The average score is 0%
Restart quiz
