CS614 Midterm Online Quiz

Naturally Evolving architecture occurred when an organization had a _______ approach to handling the whole process of hardware and software architecture.

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

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

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

DSS queries do not involve a primary key

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

.______ is class of Decision Support Environment.

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

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

_______ is an application of information and data.

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

Suppose the amount of data recorded in an organization is doubled every year. This increase is __________ .

To judge effectiveness we perform data profiling twice.

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

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

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

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

NUMA stands for __________

Focusing on data warehouse delivery only often end up _________.

The input to the data warehouse can come from OLTP or transactional system but not from other third party database.

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.

_____modeling technique is more appropriate for data warehouses.

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

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 ___________

Taken jointly, the extract programs or naturally evolving systems formed a spider web, also known as

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

Rearranging the grouping of source data, delivering it to the destination database, and ensuring the quality of data are crucial to the process of loading the data warehouse. Data ____________ is vitally important to the overall health of a warehouse project. 1. Cleansing 2. Cleaning 3. Scrubbing Which of the following options is true?

In horizontal splitting, we split a relation into multiple tables on the basis of

The goal of star schema design is to simplify ________

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

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.

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.

Relational databases allow you to navigate the data in ____________ that is appropriate using the primary, foreign key structure within the data model.

Transactional fact tables do not have records for events that do not occur. These are called

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

Change Data Capture is one of the challenging technical issues in _____________

To identify the __________________ required we need to perform data profiling

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:

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.

Analytical processing uses ____________ , instead of record level access.

The automated, prospective analyses offered by data mining move beyond the analyses of past events provided by _____________ tools typical of decision support systems.

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

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

A dense index, if fits into memory, costs only ______ disk I/O access to locate a record by given key.

When performing objective assessments, companies follow a set of principles to develop metrics specific to their needs, there is hard to have “one size fits all” approach. Which of the following statement represents the pervasive functional forms?

For a relation to be in 4NF it must be:-

The automated, prospective analyses offered by data mining move beyond the analysis of past events provided by respective tools typical of ___________.

Node of a B-Tree is stored in memory block and traversing a B-Tree involves ______ page faults.

If w is the window size and n is the size of data set, then the complexity of merging phase in BSN method is___________

B-Tree is used as an index to provide access to records