CS614-Midterm
1 / 50
The purpose of the House of Quality technique is to reduce ______ types of risk.
2 / 50
The automated, prospective analyses offered by data mining move beyond the analyses of past events provided by _____________ tools typical of decision support systems.
3 / 50
Analytical processing uses ____________ , instead of record level access.
4 / 50
We must try to find the one access tool that will handle all the needs of their users.
5 / 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.
6 / 50
DOLAP allows download of “cube” structures to a desktop platform with the need for shared relational or cube server.
7 / 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:
8 / 50
Focusing on data warehouse delivery only often end up _________.
9 / 50
: An optimized structure which is built primarily for retrieval, with update being only a secondary consideration is
10 / 50
For a DWH project, the key requirement are ________ and product experience.
11 / 50
If every key in the data file is represented in the index file then index is :
12 / 50
For a smooth DWH implementation we must be a technologist.
13 / 50
De-Normalization normally speeds up
14 / 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.
15 / 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 ___________
16 / 50
The divide & conquer cube partitioning approach helps alleviate the ____________ limitations of MOLAP implementation.
17 / 50
Data Warehouse provides the best support for analysis while OLAP carries out the _________ task.
18 / 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.
19 / 50
A single database, couldn‟t serve both operational high performance transaction processing and DSS, analytical processing, all at the same time.
20 / 50
Transactional fact tables do not have records for events that do not occur. These are called
21 / 50
Data mining uses _________ algorithms to discover patterns and regularities in data.
22 / 50
________ gives total view of an organization
23 / 50
Many data warehouse project teams waste enormous amounts of time searching in vain for a _______.
24 / 50
Collapsing tables can be done on the ___________ relationships
25 / 50
in agriculture extension is that pest population beyond which the benefit of spraying outweighs levels
26 / 50
For a given data set, to get a global view in un-supervised learning we use
27 / 50
28 / 50
Slice and Dice is changing the view of the data.
29 / 50
Naturally Evolving architecture occurred when an organization had a _______ approach to handling the whole process of hardware and software architecture.
30 / 50
_________ breaks a table into multiple tables based upon common column values.
31 / 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.
32 / 50
Change Data Capture is one of the challenging technical issues in _____________
33 / 50
It is observed that every year the amount of data recorded in anorganization is
34 / 50
In DWH project, it is assured that ___________ environment is similar to the production environment
35 / 50
____________ in agriculture extension is that pest population beyond which the benefit of spraying outweighs its cost.
36 / 50
NUMA stands for __________
37 / 50
Multidimensional databases typically use proprietary __________ format to store pre-summarized cube structures.
38 / 50
DTS allows us to connect through any data source or destination that is supported by ____________
39 / 50
The growth of master files and magnetic tapes exploded around the mid- _______. :
40 / 50
The Kimball s iterative data warehouse development approach drew on decades of experience to develop the _________.
41 / 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.
42 / 50
The degree of similarity between two records, often measured by a numerical value between _______, usually depends on application characteristics.
43 / 50
44 / 50
Pipeline parallelism focuses on increasing throughput of task execution, NOT on __________ sub-task execution time.
45 / 50
To judge effectiveness we perform data profiling twice.
46 / 50
The automated, prospective analyses offered by data mining move beyond the analysis of past events provided by respective tools typical of ___________.
47 / 50
Pre-join technique is used to avoid
48 / 50
49 / 50
_______________, if too big and does not fit into memory, will be expensive when used to find a record by given key.
50 / 50
Your score is
The average score is 0%
Restart quiz
