CS614 Midterm Online Quiz

For a DWH project, the key requirement are ________ and product experience.

5 million bales.

Pre-computed _______ can solve performance problems

_______________, if fits into memory, costs only one disk I/O access to locate a record by given key.

________ is the technique in which existing heterogeneous segments are reshuffled, relocated into homogeneous segments.

in agriculture extension is that pest population beyond which the benefit of spraying outweighs levels

DTS allows us to connect through any data source or destination that is supported by ____________

The Kimball s iterative data warehouse development approach drew on decades of experience to develop the _________.

The performance in a MOLAP cube comes from the O(1) look-up time for the array data structure.

_______ is an application of information and data.

Pakistan is one of the five major ________ countries in the world.

The goal of ______is to look at as few block as possible to find the matching records.

Cube is a __________ entity containing values of a certain fact at a certain aggregation level at an intersection of a combination of dimensions.

Horizontal splitting breaks a table into multiple tables based upon_______

Multidimensional databases typically use proprietary __________ format to store pre-summarized cube structures.

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...

: An optimized structure which is built primarily for retrieval, with update being only a secondary consideration is

De-Normalization normally speeds up

There are many variants of the traditional nested-loop join, if there is an index is exploited, then it is called……

Virtual cube is used to query two similar cubes by creating a third “virtual” cube by a join between two cubes.

All data is ______________ of something real. I An Abstraction II A Representation Which of the following option is true?

Companies collect and record their own operational data, but at the same time they also use reference data obtained from _______ sources such as codes, prices etc.

DOLAP allows download of “cube” structures to a desktop platform with the need for shared relational or cube server.

_________ breaks a table into multiple tables based upon common column values.

De-Normalization normally speeds up

: The goal of ___________ is to look at as few blocks as possible to find the matching records(s).

_____________, if fits into memory , costs only one disk I/O access to locate a record by given key.

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:

 ________ gives total view of an organization

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 ____________.

The goal of star schema design is to simplify ________

For a DWH project, the key requirement are ________ and product experience.

The _________ is only a small part in realizing the true business value buried within the mountain of data collected and stored within organizations business systems and operational databases.

_____________ is a process which involves gathering of information about column through execution of certain queries with intention to identify erroneous records.

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.

We must try to find the one access tool that will handle all the needs of their users.

The need to synchronize data upon update is called

Data warehousing and on-line analytical processing (OLAP) are _______ elements of decision support system.

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 ___________

Pipeline parallelism focuses on increasing throughput of task execution, NOT on __________ sub-task execution time.

Collapsing tables can be done on the ___________ relationships

Pakistan is one of the five major ________ countries in the world.

Investing years in architecture and forgetting the primary purpose of solving business problems, results in inefficient application. This is the example of _________ mistake.

The purpose of the House of Quality technique is to reduce ______ types of risk.

It is observed that every year the amount of data recorded in an organization :

Slice and Dice is changing the view of the data.

The degree of similarity between two records, often measured by a numerical value between _______, usually depends on application characteristics.

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 _______.

Data mining uses _________ algorithms to discover patterns and regularities in data.

_______________, if too big and does not fit into memory, will be expensive when used to find a record by given key.