CS614-Midterm
1 / 50
DSS queries do not involve a primary key
2 / 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.
3 / 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:
4 / 50
If „M‟ rows from table-A match the conditions in the query then table-B is accessed „M‟ times. Suppose table-B has an index on the join column. If „a‟ I/Os are required to read the data block for each scan and „b‟ I/Os for each data block then the total cost of accessing table-B is _____________ logical I/Os approximately.
5 / 50
In DWH project, it is assured that ___________ environment is similar to the production environment
6 / 50
Taken jointly, the extract programs or naturally evolving systems formed a spider web, also known as
7 / 50
Pipeline parallelism focuses on increasing throughput of task execution, NOT on __________ sub-task execution time.
8 / 50
The purpose of the House of Quality technique is to reduce ______ types of risk.
9 / 50
People that design and build the data warehouse must be capable of working across the organization at all levels
10 / 50
Pre-join technique is used to avoid
11 / 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.
12 / 50
The growth of master files and magnetic tapes exploded around the mid- _______. :
13 / 50
The degree of similarity between two records, often measured by a numerical value between _______, usually depends on application characteristics.
14 / 50
For a given data set, to get a global view in un-supervised learning we use
15 / 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.
16 / 50
Collapsing tables can be done on the ___________ relationships
17 / 50
: An optimized structure which is built primarily for retrieval, with update being only a secondary consideration is
18 / 50
30.Data Warehouse is about taking / colleting data from different ________ sources:
19 / 50
_______________, if too big and does not fit into memory, will be expensive when used to find a record by given key.
20 / 50
21 / 50
Virtual cube is used to query two similar cubes by creating a third “virtual” cube by a join between two cubes.
22 / 50
_________ breaks a table into multiple tables based upon common column values.
23 / 50
Pre-computed _______ can solve performance problems
24 / 50
NUMA stands for __________
25 / 50
_____ contributes to an under-utilization of valuable and expensive historical data, and inevitably results in a limitedcapability to provide decision support and analysis.
26 / 50
De-Normalization normally speeds up
27 / 50
The automated, prospective analyses offered by data mining move beyond the analyses of past events provided by _____________ tools typical of decision support systems.
28 / 50
Node of a B-Tree is stored in memory block and traversing a B-Tree involves ______ page faults.
29 / 50
For a smooth DWH implementation we must be a technologist.
30 / 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 _______.
31 / 50
DTS allows us to connect through any data source or destination that is supported by ____________
32 / 50
Data warehousing and on-line analytical processing (OLAP) are _______ elements of decision support system.
33 / 50
In _________ system, the contents change with time. :
34 / 50
Analytical processing uses ____________ , instead of record level access.
35 / 50
Data Warehouse provides the best support for analysis while OLAP carries out the _________ task.
36 / 50
in agriculture extension is that pest population beyond which the benefit of spraying outweighs levels
37 / 50
Naturally Evolving architecture occurred when an organization had a _______ approach to handling the whole process of hardware and software architecture.
38 / 50
Suppose the amount of data recorded in an organization is doubled every year. This increase is __________ .
39 / 50
40 / 50
5 million bales.
41 / 50
____________ in agriculture extension is that pest population beyond which the benefit of spraying outweighs its cost.
42 / 50
Focusing on data warehouse delivery only often end up _________.
43 / 50
.______ is class of Decision Support Environment.
44 / 50
Non uniform distribution, when the data is distributed across the processors, is called ______.
45 / 50
In horizontal splitting, we split a relation into multiple tables on the basis of
46 / 50
As apposed to the out come of classification, estimation deal with ____________ valued outcome.
47 / 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?
48 / 50
Normalization effects performance
49 / 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.
50 / 50
Multidimensional databases typically use proprietary __________ format to store pre-summarized cube structures.
Your score is
The average score is 0%
Restart quiz