CS614-Midterm
1 / 50
A data warehouse implementation without an OLAP tool is always possible.
2 / 50
30.Data Warehouse is about taking / colleting data from different ________ sources:
3 / 50
Multidimensional databases typically use proprietary __________ format to store pre-summarized cube structures.
4 / 50
Data mining uses _________ algorithms to discover patterns and regularities in data.
5 / 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 ___________
6 / 50
_______ is an application of information and data.
7 / 50
We must try to find the one access tool that will handle all the needs of their users.
8 / 50
Transactional fact tables do not have records for events that do not occur. These are called
9 / 50
The automated, prospective analyses offered by data mining move beyond the analyses of past events provided by _____________ tools typical of decision support systems.
10 / 50
Pre-computed _______ can solve performance problems
11 / 50
: An optimized structure which is built primarily for retrieval, with update being only a secondary consideration is
12 / 50
People that design and build the data warehouse must be capable of working across the organization at all levels
13 / 50
In _________ system, the contents change with time. :
14 / 50
Investing years in architecture and forgetting the primary purpose of solving business problems, results in inefficient application. This is the example of _________ mistake.
15 / 50
Pipeline parallelism focuses on increasing throughput of task execution, NOT on __________ sub-task execution time.
16 / 50
Horizontal splitting breaks a table into multiple tables based upon_______
17 / 50
18 / 50
All data is ______________ of something real. I An Abstraction II A Representation Which of the following option is true?
19 / 50
If every key in the data file is represented in the index file then index is :
20 / 50
DOLAP allows download of “cube” structures to a desktop platform with the need for shared relational or cube server.
21 / 50
A single database, couldn‟t serve both operational high performance transaction processing and DSS, analytical processing, all at the same time.
22 / 50
Focusing on data warehouse delivery only often end up _________.
23 / 50
24 / 50
Many data warehouse project teams waste enormous amounts of time searching in vain for a _______.
25 / 50
Which statement is true for De-Normalization?
26 / 50
The STAR schema used for data design is a __________ consisting of fact and dimension tables. :
27 / 50
in agriculture extension is that pest population beyond which the benefit of spraying outweighs levels
28 / 50
The goal of star schema design is to simplify ________
29 / 50
It is observed that every year the amount of data recorded in an organization :
30 / 50
31 / 50
For a smooth DWH implementation we must be a technologist.
32 / 50
Cube is a __________ entity containing values of a certain fact at a certain aggregation level at an intersection of a combination of dimensions.
33 / 50
To measure or quantify the similarity or dissimilarity, different techniques are available. Which of the following option represent the name of available techniques?
34 / 50
In horizontal splitting, we split a relation into multiple tables on the basis of
35 / 50
The users of data warehouse are knowledge workers in other words they are _______in the organization.
36 / 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.
37 / 50
In DWH project, it is assured that ___________ environment is similar to the production environment
38 / 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...
39 / 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:
40 / 50
Pakistan is one of the five major ________ countries in the world.
41 / 50
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.
42 / 50
The degree of similarity between two records, often measured by a numerical value between _______, usually depends on application characteristics.
43 / 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___________
44 / 50
45 / 50
It is observed that every year the amount of data recorded in anorganization is
46 / 50
To judge effectiveness we perform data profiling twice.
47 / 50
NUMA stands for __________
48 / 50
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?
49 / 50
B-Tree is used as an index to provide access to records
50 / 50
Naturally Evolving architecture occurred when an organization had a _______ approach to handling the whole process of hardware and software architecture.
Your score is
The average score is 0%
Restart quiz
