02-09-2013, 04:40 PM
Question Paper Data Warehousing and Data Mining (MC332) : January 2007
Warehousing and Data.pdf (Size: 696.73 KB / Downloads: 26)
1. Which of the following forms the logical subset of the complete data warehouse?
(a)Dimensional model
(b)Fact table
©Dimensional table
(d)Operational Data Store
(e)Data Mart.
2.Which of the following is not included in Modeling Applications?
(a)Forecasting models
(b)Behavior scoring models
©Allocation models
(d)Data mining Models
(e)Metadata driven models.
3.Which of the following is a dimension that means the same thing with every possible fact table to
which it can be joined?
(a)Permissible snowflaking
(b)Confirmed Dimensions
©Degenerate dimensions
(d)Junk Dimensions
(e)Monster Dimensions.
4.Which of the following is not the managing issue in the modeling process?
(a)Content of primary units column
(b)Document each candidate data source
©Do regions report to zones
(d)Walk through business scenarios
(e)Ensure that the transaction edit flat is used for analysis.
5.Which of the following criteria is not used for selecting the data sources?
(a)Data Accessibility
(b)Platform
©Data accuracy
(d)Longevity of the feed
(e)Project scheduling.
6.Which of the following does not relate to the data modeling tool?
(a)Link to the dimension table designs
(b)Business user Documentation
©Helps assure consistency in naming
(d)Length of the logical column.
(e)Generates physical object DDL.
7.Which of the following is true on building a Matrix for Data warehouse bus architecture?
(a)Data marts as columns and dimensions as rows
(b)Dimensions as rows and facts as columns
©Data marts as rows and dimensions as columns
(d)Data marts as rows and facts as columns
(e)Facts as rows and data marts as columns.
8.Which of the following should not be considered for each dimension attribute?
(a)Attribute name
(b)Rapid changing dimension policy
©Attribute definition
(d)Sample data
(e)Cardinality.
9.Which of following form the set of data created to support a specific short lived business situation?
(a)Personal Data Marts
(b)Application Models
©Downstream systems
(d)Disposable Data Marts
(e)Data mining models.