CS614-Midterm
1 / 50
NUMA stands for __________
2 / 50
Pre-computed _______ can solve performance problems
3 / 50
If every key in the data file is represented in the index file then index is :
4 / 50
De-Normalization normally speeds up
5 / 50
Data warehousing and on-line analytical processing (OLAP) are _______ elements of decision support system.
6 / 50
_________ breaks a table into multiple tables based upon common column values.
7 / 50
Naturally Evolving architecture occurred when an organization had a _______ approach to handling the whole process of hardware and software architecture.
8 / 50
There are many variants of the traditional nested-loop join, if there is an index is exploited, then it is called……
9 / 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___________
10 / 50
_____ contributes to an under-utilization of valuable and expensive historical data, and inevitably results in a limitedcapability to provide decision support and analysis.
11 / 50
The automated, prospective analyses offered by data mining move beyond the analyses of past events provided by _____________ tools typical of decision support systems.
12 / 50
Multidimensional databases typically use proprietary __________ format to store pre-summarized cube structures.
13 / 50
: An optimized structure which is built primarily for retrieval, with update being only a secondary consideration is
14 / 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.
15 / 50
Many data warehouse project teams waste enormous amounts of time searching in vain for a _______.
16 / 50
17 / 50
_____________, if fits into memory , costs only one disk I/O access to locate a record by given key.
18 / 50
We must try to find the one access tool that will handle all the needs of their users.
19 / 50
20 / 50
If some error occurs, execution will be terminated abnormally and all transactions will be rolled back. In this case when we will access the database we will find it in the state that was before the ____________.
21 / 50
Collapsing tables can be done on the ___________ relationships
22 / 50
The users of data warehouse are knowledge workers in other words they are _______in the organization.
23 / 50
The automated, prospective analyses offered by data mining move beyond the analysis of past events provided by respective tools typical of ___________.
24 / 50
The purpose of the House of Quality technique is to reduce ______ types of risk.
25 / 50
DTS allows us to connect through any data source or destination that is supported by ____________
26 / 50
People that design and build the data warehouse must be capable of working across the organization at all levels
27 / 50
Relational databases allow you to navigate the data in ____________ that is appropriate using the primary, foreign key structure within the data model.
28 / 50
The divide & conquer cube partitioning approach helps alleviate the ____________ limitations of MOLAP implementation.
29 / 50
The STAR schema used for data design is a __________ consisting of fact and dimension tables. :
30 / 50
For a DWH project, the key requirement are ________ and product experience.
31 / 50
_______ is an application of information and data.
32 / 50
Transactional fact tables do not have records for events that do not occur. These are called
33 / 50
For a given data set, to get a global view in un-supervised learning we use
34 / 50
Pipeline parallelism focuses on increasing throughput of task execution, NOT on __________ sub-task execution time.
35 / 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:
36 / 50
_______________, if too big and does not fit into memory, will be expensive when used to find a record by given key.
37 / 50
To identify the __________________ required we need to perform data profiling
38 / 50
It is observed that every year the amount of data recorded in anorganization is
39 / 50
Focusing on data warehouse delivery only often end up _________.
40 / 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.
41 / 50
For a relation to be in 4NF it must be:-
42 / 50
The growth of master files and magnetic tapes exploded around the mid- _______. :
43 / 50
A dense index, if fits into memory, costs only ______ disk I/O access to locate a record by given key.
44 / 50
Grain is the ________ level of data stored in the warehouse.
45 / 50
The goal of ______is to look at as few block as possible to find the matching records.
46 / 50
Pre-join technique is used to avoid
47 / 50
Node of a B-Tree is stored in memory block and traversing a B-Tree involves ______ page faults.
48 / 50
A data warehouse implementation without an OLAP tool is always possible.
49 / 50
30.Data Warehouse is about taking / colleting data from different ________ sources:
50 / 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.
Your score is
The average score is 0%
Restart quiz
