cs614-mid term paper 8 dec 2010 solved

[Xpert]

Imrangee
[FONT=&quot]MIDTERM EXAMINATION[/FONT]
[FONT=&quot]Fall 2010 (8 Dec 2010)[/FONT]
[FONT=&quot]CS614- Data Warehousing[/FONT]
[FONT=&quot]Question No: 1 (Marks: 1 ) - Please choose one[/FONT]
Data Warehouse is about taking / colleting data from different sources:
► Harmonized
► Identical
► Homogeneous
►[FONT=&quot]Heterogeneous[/FONT]
[FONT=&quot]Question No: 2 (Marks: 1 ) - Please choose one[/FONT]
is class of Decision Support Environment.
► OLTP
[FONT=&quot]► OLAP[/FONT]
► DBMS
► Network
[FONT=&quot]Question No: 3 (Marks: 1 ) - Please choose one[/FONT]
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:
► Owner’s Perspective
► Customer’s Perspective
[FONT=&quot]► Decision Maker’s Perspective[/FONT]
► Employee's Perspective
[FONT=&quot]Question No: 4 (Marks: 1 ) - Please choose one[/FONT]
For a relation to be in 4NF it must be:-
► In 2NF if and only if it is in first normal form and all nonkey attributes are fully
functionally dependent on the key.
► In 3NF and every non-key column is non-transitively dependent upon its primary key.
► In 3NF and every non-key column is non-transitively dependent upon its Foreign key.
[FONT=&quot]► In 3NF and It does not have multi valued dependencies[/FONT]
[FONT=&quot]Question No: 5 (Marks: 1 ) - Please choose one[/FONT]
Horizontal splitting breaks a table into multiple tables based upon
► Common Row values
► Range of Data.
► Redundant data.
[FONT=&quot]► Common column values.[/FONT]
[FONT=&quot]Question No: 6 (Marks: 1 ) - Please choose one[/FONT]
D-Normalization speeds up
[FONT=&quot]► Data Retrieval[/FONT]
► Data Duplication
► Data Extraction
► Data Loading
[FONT=&quot]Question No: 7 (Marks: 1 ) - Please choose one[/FONT]
The most common use of range partitioning is on .
[FONT=&quot]► Date[/FONT]
► Rows
► DSS
[FONT=&quot]► None of these[/FONT]
[FONT=&quot]Question No: 8 (Marks: 1 ) - Please choose one[/FONT]
The fact table is a way of [FONT=&quot]visualizing as [/FONT]an cube
► Rolled Up
[FONT=&quot]► Un-rolled[/FONT]
Imrangee
► Rolled Down
► None of these
[FONT=&quot]Question No: 9 (Marks: 1 ) - Please choose one[/FONT]
High Granularity, more .
[FONT=&quot]► Details[/FONT]
► Dimensions
► Aggregates
► Cubes
[FONT=&quot]Question No: 10 (Marks: 1 ) - Please choose one[/FONT]
Transactional fact tables do not have records for events that do not occur. These are called
[FONT=&quot]► Not Recording Facts[/FONT]
► Fact-less Facts
► Null Facts
► None of these
[FONT=&quot]Question No: 11 (Marks: 1 ) - Please choose one[/FONT]
Cubes not drilled down is, It is a .
[FONT=&quot]► Data Mart[/FONT]
► DWH
► DOLAP
► None of these
[FONT=&quot]Question No: 12 (Marks: 1 ) - Please choose one[/FONT]
During ETL process of an organization, suppose you have data which can be transformed using
any of the transformation method. Which of the following strategy will be your choice for least
complexity?
[FONT=&quot]► One-to-One Scalar Transformation[/FONT]
► One-to-Many Element Transformation
► Many-to-Many Element Transformation
► Many-to-One Element Transformation
[FONT=&quot]Question No: 13 (Marks: 1 ) - Please choose one[/FONT]
Full & Incremental Extraction are the types of Extraction
[FONT=&quot]► Logical[/FONT]
► Physical
► Both Logical & Physical
► None of Above
[FONT=&quot]Question No: 14 (Marks: 1 ) - Please choose one[/FONT]
Selectivity is low in environment.
[FONT=&quot]► DWH[/FONT]
► DBMS
► OLTP
► None of Above
[FONT=&quot]Question No: 15 (Marks: 1 ) - Please choose one[/FONT]
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?
[FONT=&quot]► Simple Ratio, Min or Max Operation, Weighted Average[/FONT]
► Only Complex Ratio, Min Operation, Max Operation
► Only Simple Ratio, Min or Max Operation
► Only Min or Max Operation, Weighted Average
[FONT=&quot]Question No: 16 (Marks: 1 ) - Please choose one[/FONT]
The input to the data warehouse can come from OLTP or transactional system but not from other
third party database.
Imrangee
► True
[FONT=&quot]► False[/FONT]
[FONT=&quot]Question No: 17 (Marks: 1 ) - Please choose one[/FONT]
Normalization effects performance
► True
[FONT=&quot]► False[/FONT]
[FONT=&quot]Question No: 18 (Marks: 1 ) - Please choose one[/FONT]
MOLAP physically builds “cubes” for direct access in a multi-dimensional database (MDD)
Therefore is not supported. ► One-to-One
► Facts
[FONT=&quot]► ANSI SQL[/FONT]
► Dimensions
► None of these
[FONT=&quot]Question No: 19 (Marks: 1 ) - Please choose one[/FONT]
[FONT=&quot]The users of data warehouse are knowledge workers in other words they are in[/FONT]
[FONT=&quot]the organization.[/FONT]
► [FONT=&quot]Decision maker[/FONT]
► Manager
► Database Administrator
► DWH Analyst
[FONT=&quot]Question No: 20 (Marks: 1 ) - Please choose one[/FONT]
If w is the window size and n is the size of data set, then the complexity of merging phase in
BSN method is
► O (n)
► O (w)
[FONT=&quot]► O (w n)[/FONT]
► O (w log n)
[FONT=&quot]Question No: 21 (Marks: 2 )[/FONT]
[FONT=&quot]Briefly describe features of MOLAP.[/FONT]
[FONT=&quot]Question No: 22 (Marks: 2 )[/FONT]
[FONT=&quot]Name the steps involved in cleansing of data?[/FONT]
[FONT=&quot]Question No: 23 (Marks: 3 )[/FONT]
[FONT=&quot]Briefly describe the features of Star Schema?[/FONT]
[FONT=&quot]Question No: 24 (Marks: 3 )[/FONT]
[FONT=&quot]Briefly describe, what is multi-pass BSN Approach?[/FONT]
[FONT=&quot]Question No: 25 (Marks: 5 )[/FONT]
[FONT=&quot]What are the benefits of HOLAP & DOLAP over MOLAP & ROLAP[/FONT]?
[FONT=&quot]Question No: 26 (Marks: 5 )[/FONT]
[FONT=&quot]What is the relationship between Data quality and the value of a particular application?[/FONT]
[FONT=&quot]When efforts for data quality are logical?[/FONT]