CS614-Midterm
1 / 50
Many data warehouse project teams waste enormous amounts of time searching in vain for a _______.
2 / 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 ___________
3 / 50
Pakistan is one of the five major ________ countries in the world.
4 / 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.
5 / 50
For a DWH project, the key requirement are ________ and product experience.
6 / 50
In DWH project, it is assured that ___________ environment is similar to the production environment
7 / 50
Pipeline parallelism focuses on increasing throughput of task execution, NOT on __________ sub-task execution time.
8 / 50
Data mining evolve as mechanism to cater the limitations of _____ systems to deal massive data sets with high dimensionality, new data types, multiple heterogeneous data resources etc...
9 / 50
Node of a B-Tree is stored in memory block and traversing a B-Tree involves ______ page faults.
10 / 50
People that design and build the data warehouse must be capable of working across the organization at all levels
11 / 50
_______________, if fits into memory, costs only one disk I/O access to locate a record by given key.
12 / 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.
13 / 50
A dense index, if fits into memory, costs only ______ disk I/O access to locate a record by given key.
14 / 50
The automated, prospective analyses offered by data mining move beyond the analysis of past events provided by respective tools typical of ___________.
15 / 50
The need to synchronize data upon update is called
16 / 50
17 / 50
18 / 50
Collapsing tables can be done on the ___________ relationships
19 / 50
: An optimized structure which is built primarily for retrieval, with update being only a secondary consideration is
20 / 50
30.Data Warehouse is about taking / colleting data from different ________ sources:
21 / 50
It is observed that every year the amount of data recorded in anorganization is
22 / 50
For a relation to be in 4NF it must be:-
23 / 50
Cube is a __________ entity containing values of a certain fact at a certain aggregation level at an intersection of a combination of dimensions.
24 / 50
De-Normalization normally speeds up
25 / 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.
26 / 50
27 / 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.
28 / 50
A data warehouse implementation without an OLAP tool is always possible.
29 / 50
5 million bales.
30 / 50
There are many variants of the traditional nested-loop join. If the index is built as part of the query plan and subsequently dropped, it is called
31 / 50
There are many variants of the traditional nested-loop join, if there is an index is exploited, then it is called……
32 / 50
B-Tree is used as an index to provide access to records
33 / 50
34 / 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.
35 / 50
Virtual cube is used to query two similar cubes by creating a third “virtual” cube by a join between two cubes.
36 / 50
To judge effectiveness we perform data profiling twice.
37 / 50
Multidimensional databases typically use proprietary __________ format to store pre-summarized cube structures.
38 / 50
39 / 50
The Kimball s iterative data warehouse development approach drew on decades of experience to develop the _________.
40 / 50
41 / 50
Non uniform distribution, when the data is distributed across the processors, is called ______.
42 / 50
In _________ system, the contents change with time. :
43 / 50
44 / 50
The degree of similarity between two records, often measured by a numerical value between _______, usually depends on application characteristics.
45 / 50
DSS queries do not involve a primary key
46 / 50
Transactional fact tables do not have records for events that do not occur. These are called
47 / 50
Horizontal splitting breaks a table into multiple tables based upon_______
48 / 50
49 / 50
The goal of star schema design is to simplify ________
50 / 50
To identify the __________________ required we need to perform data profiling
Your score is
The average score is 0%
Restart quiz
