CS614-Midterm
1 / 50
To identify the __________________ required we need to perform data profiling
2 / 50
As apposed to the out come of classification, estimation deal with ____________ valued outcome.
3 / 50
30.Data Warehouse is about taking / colleting data from different ________ sources:
4 / 50
: The goal of ___________ is to look at as few blocks as possible to find the matching records(s).
5 / 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.
6 / 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.
7 / 50
The growth of master files and magnetic tapes exploded around the mid- _______. :
8 / 50
DTS allows us to connect through any data source or destination that is supported by ____________
9 / 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.
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 degree of similarity between two records, often measured by a numerical value between _______, usually depends on application characteristics.
12 / 50
Data warehousing and on-line analytical processing (OLAP) are _______ elements of decision support system.
13 / 50
For a given data set, to get a global view in un-supervised learning we use
14 / 50
There are many variants of the traditional nested-loop join, if there is an index is exploited, then it is called……
15 / 50
Data Warehouse provides the best support for analysis while OLAP carries out the _________ task.
16 / 50
Normalization effects performance
17 / 50
In _________ system, the contents change with time. :
18 / 50
Virtual cube is used to query two similar cubes by creating a third “virtual” cube by a join between two cubes.
19 / 50
For a DWH project, the key requirement are ________ and product experience.
20 / 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.
21 / 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.
22 / 50
Analytical processing uses ____________ , instead of record level access.
23 / 50
Node of a B-Tree is stored in memory block and traversing a B-Tree involves ______ page faults.
24 / 50
A data warehouse implementation without an OLAP tool is always possible.
25 / 50
Transactional fact tables do not have records for events that do not occur. These are called
26 / 50
A single database, couldn‟t serve both operational high performance transaction processing and DSS, analytical processing, all at the same time.
27 / 50
The goal of star schema design is to simplify ________
28 / 50
NUMA stands for __________
29 / 50
In horizontal splitting, we split a relation into multiple tables on the basis of
30 / 50
Cube is a __________ entity containing values of a certain fact at a certain aggregation level at an intersection of a combination of dimensions.
31 / 50
_____________ is a process which involves gathering of information about column through execution of certain queries with intention to identify erroneous records.
32 / 50
The Kimball s iterative data warehouse development approach drew on decades of experience to develop the _________.
33 / 50
_____________, if fits into memory , costs only one disk I/O access to locate a record by given key.
34 / 50
For a smooth DWH implementation we must be a technologist.
35 / 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 ___________
36 / 50
To measure or quantify the similarity or dissimilarity, different techniques are available. Which of the following option represent the name of available techniques?
37 / 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___________
38 / 50
It is observed that every year the amount of data recorded in anorganization is
39 / 50
.______ is class of Decision Support Environment.
40 / 50
Focusing on data warehouse delivery only often end up _________.
41 / 50
The divide & conquer cube partitioning approach helps alleviate the ____________ limitations of MOLAP implementation.
42 / 50
Change Data Capture is one of the challenging technical issues in _____________
43 / 50
________ gives total view of an organization
44 / 50
_____modeling technique is more appropriate for data warehouses.
45 / 50
46 / 50
In DWH project, it is assured that ___________ environment is similar to the production environment
47 / 50
Pre-join technique is used to avoid
48 / 50
B-Tree is used as an index to provide access to records
49 / 50
50 / 50
Slice and Dice is changing the view of the data.
Your score is
The average score is 0%
Restart quiz
