Are you looking for dwdm lab viva questions with answers ?
Type your request / requirement / comment about dwdm lab viva questions with answers in to the right box for getting free material and support from us/dedicated premium members...
Posts: 14,118
Threads: 61
Joined: Oct 2014
1. Which of the following forms the logical subset of the entire data store?
(a) Dimensional model (b) Table of facts © Dimensional table (d) Data warehouse (e) Data Mart.
2. Which of the following is not included in the Modeling Applications?
(a) Prediction models (b) Behaviour rating models © Allocation models (d) Data mining models (e) Metadata based models.
3. Which of the following is a dimension that means the same with each possible table of facts to which you can join?
(a) Permissible snow flocculation (b) Dimensions confirmed © Degenerate dimensions (d) Dimensions of waste (e) Dimensions of the monster.
4. Which of the following is not the management problem in the modeling process?
(a) Content of primary units column (b) Document each candidate data source © Regions report to zones (d) Examine business scenarios (e) Ensure that the flat editing transaction is used for analysis .
5. Which of the following criteria is not used to select data sources?
(a) Accessibility of data (b) Platform © Accuracy of data
(d) Food longevity (e) Project programming.
6. Which of the following is not related to the data modeling tool?
(d) Length of the logical column (e) Generates physical object DDL (d) Length of the logical column.
7. Which of the following statements is true when constructing an array for the data warehouse bus architecture?
(d) Data marks as rows and facts as columns (e) Data as rows and data as columns (e) Data as rows and data as columns Data marts as columns.
8. Which of the following should not be considered for each dimension attribute?
(a) Attribute name (b) Rapid dimension change policy © Attribute definition (d) Sample data (e) Cardinality.
9. Which of the following form the set of data created to support a concrete situation of short duration?
(a) Personal data Marts (b) Application models © Downstream systems (d) Disposable data marts (e) Data mining models.
10. Which of the following does not form access services in the future?
(a) Authentication (b) List of links © Drive to centralized services (d) Supplier consolidation (e) Web based client access.
11. What is the special type of grouping that identifies events or transactions occurring simultaneously?
(a) Affinity grouping (b) Classification © Grouping (d) Estimation (e) Prediction.
12. Of the following team members, who are not audiences for Data Warehousing?
(a) Data architects
(b) DBAs © Business Intelligence Experts (d) Managers (e) Customers / users.
13. Precalculated summary values are referred to as
(a) Assertions (b) Triggers © Aggregates (d) Schemes (e) Indices.
14.OLAP stands for
(a) Online analytical processing (b) Online attribute processing © Online assertion processing (d) Online association processing (e) Online assignment processing.
15. Which of the following uses data mining techniques to analyze the intent of a user query, providing additional generalized or associated information relevant to the query?
(a) Iceberg query method (b) Data analyzer © Smart query response (d) DBA (e) Query analyzer.
16. Since the following clustering algorithm, what is the method that initially creates a hierarchical decomposition of the given set of data objects?
(a) Partition method (b) Hierarchical method © Density-based method (d) Grid-based method (e) Model-based method.
17. Which of the following can be done using attribute-oriented induction in a manner similar to the characterization of the concept?
(a) Analytical characterization (b) Concept Description © OLAP-based approach (d) Comparison of concepts (e) Data Mining
