CS614-Midterm
1 / 50
: An optimized structure which is built primarily for retrieval, with update being only a secondary consideration is
2 / 50
Pipeline parallelism focuses on increasing throughput of task execution, NOT on __________ sub-task execution time.
3 / 50
For a given data set, to get a global view in un-supervised learning we use
4 / 50
The goal of ideal parallel execution is to completely parallelize those parts of a computation that are not constrained by data dependencies. The smaller the portion of the program that must be executed __________, the greater the scalability of the computation.
5 / 50
For a smooth DWH implementation we must be a technologist.
6 / 50
Analytical processing uses ____________ , instead of record level access.
7 / 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
8 / 50
Collapsing tables can be done on the ___________ relationships
9 / 50
________ gives total view of an organization
10 / 50
NUMA stands for __________
11 / 50
DTS allows us to connect through any data source or destination that is supported by ____________
12 / 50
In DWH project, it is assured that ___________ environment is similar to the production environment
13 / 50
As apposed to the out come of classification, estimation deal with ____________ valued outcome.
14 / 50
Virtual cube is used to query two similar cubes by creating a third “virtual” cube by a join between two cubes.
15 / 50
5 million bales.
16 / 50
For a DWH project, the key requirement are ________ and product experience.
17 / 50
Multidimensional databases typically use proprietary __________ format to store pre-summarized cube structures.
18 / 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.
19 / 50
Pakistan is one of the five major ________ countries in the world.
20 / 50
21 / 50
All data is ______________ of something real. I An Abstraction II A Representation Which of the following option is true?
22 / 50
A single database, couldn‟t serve both operational high performance transaction processing and DSS, analytical processing, all at the same time.
23 / 50
If every key in the data file is represented in the index file then index is :
24 / 50
We must try to find the one access tool that will handle all the needs of their users.
25 / 50
Focusing on data warehouse delivery only often end up _________.
26 / 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?
27 / 50
30.Data Warehouse is about taking / colleting data from different ________ sources:
28 / 50
The Kimball s iterative data warehouse development approach drew on decades of experience to develop the _________.
29 / 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.
30 / 50
31 / 50
In horizontal splitting, we split a relation into multiple tables on the basis of
32 / 50
33 / 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.
34 / 50
Data Warehouse provides the best support for analysis while OLAP carries out the _________ task.
35 / 50
Node of a B-Tree is stored in memory block and traversing a B-Tree involves ______ page faults.
36 / 50
To identify the __________________ required we need to perform data profiling
37 / 50
_____ contributes to an under-utilization of valuable and expensive historical data, and inevitably results in a limitedcapability to provide decision support and analysis.
38 / 50
The goal of star schema design is to simplify ________
39 / 50
Pre-join technique is used to avoid
40 / 50
The STAR schema used for data design is a __________ consisting of fact and dimension tables. :
41 / 50
Naturally Evolving architecture occurred when an organization had a _______ approach to handling the whole process of hardware and software architecture.
42 / 50
43 / 50
During the application specification activity, we also must give consideration to the organization of the applications.
44 / 50
Data mining uses _________ algorithms to discover patterns and regularities in data.
45 / 50
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 ____________.
46 / 50
Horizontal splitting breaks a table into multiple tables based upon_______
47 / 50
The degree of similarity between two records, often measured by a numerical value between _______, usually depends on application characteristics.
48 / 50
In _________ system, the contents change with time. :
49 / 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 ___________
50 / 50
____________ in agriculture extension is that pest population beyond which the benefit of spraying outweighs its cost.
Your score is
The average score is 0%
Restart quiz