
Data mining and warehousing mcq
1. What is the type of relationship in star schema?
- many-to-many.
- one-to-one
- many-to-one
- one-to-many
one-to-many
2. Fact tables are _______.
- completely demoralized.
- partially demoralized.
- completely normalized.
- partially normalized.
completely normalized.
3. Data warehouse is volatile, because obsolete data are discarded
- TRUE
- FALSE
FALSE
4. Which is NOT a basic conceptual schema in Data Modeling of Data Warehouses?
- Star schema
- Tree schema
- Snowflake schema
- Fact constellations b
Tree schema
5. Which is NOT a valid OLAP Rule by E.F.Codd?
- Accessibility
- Transparency
- Flexible reporting
- Reliability
Reliability
6. Which is NOT a valid layer in Three-layer Data Warehouse Architecture in Conceptual View?
- Processed data layer
- Real-time data layer
- Derived data layer
- Reconciled data layer
Processed data layer
7. Among the types of fact tables which is not a correct type ?
- Fact-less fact table
- Transaction fact tables
- Integration fact tables
- Aggregate fact tables
Integration fact tables
8. Among the followings which is not a characteristic of Data Warehouse?
- Integrated
- Volatile
- Time-variant
- Subject oriented
Volatile
Machine Learning mcq with answers
9. what is not considered as isssues in data warehousing?
- optimization
- data transformation
- extraction
- inter mediation
inter mediation
10. which one is NOT considering as a standard query technique?
- Drill-up
- Drill-across
- DSS
- Pivoting
DSS
Data mining and warehousing mcq sppu
11. Among the following which is not a type of business data ?
- Real time data
- Application data
- Reconciled data
- Derived data
Application data
12. A data warehouse is which of the following?
- Can be updated by end users.
- Contains numerous naming conventions and formats.
- Organized around important subject areas.
- Contains only current data.
Organized around important subject areas.
13. A snowflake schema is which of the following types of tables?
- Fact
- Dimension
- Helper
- All of the above
All of the above
14. The extract process is which of the following?
- Capturing all of the data contained in various operational systems
- Capturing a subset of the data contained in various operational systems
- Capturing all of the data contained in various decision support systems .
- Capturing a subset of the data contained in various decision support systems
Capturing a subset of the data contained in various operational systems
Data mining and Warehousing mcq
15. The generic two-level data warehouse architecture includes which of the following?
- At least one data mart
- Data that can extracted from numerous internal and external sources
- Near real-time updates
- All of the above.
Data that can extracted from numerous internal and external sources
16. Which one is correct regarding MOLAP ?
- Data is stored and fetched from the main data warehouse.
- Use complex SQL queries to fetch data from the main warehouse
- Large volume of data is used.
- All are incorrect
- A and B is correct.
Data is stored and fetched from the main data warehouse.
17.In terms of data warehouse,metadata can be define as,
- Metadata is a road-map to data warehouse
- Metadata in data warehouse defines the warehouse objects.
- Metadata acts as a directory.
- All are incorrect
All are incorrect
18. In terms of RLOP model, choose the most suitable answer
- The warehouse stores atomic data.
- The application layer generates SQL for the two dimensional view
- The presentation layer provides the multidimensional view.
- All are incorrect
All are incorrect
19. In the OLAP model, the _ provides the multidimensional view.
- Data layer
- Data link layer
- Presentation layer
- Application layer
Data layer
data mining and warehousing mcq sppu
20. Which of the following is not true regarding characteristics of warehoused data?
- Changed data will be added as new data
- Data warehouse can contains historical data
- Obsolete data are discarded
- Users can change data once entered into the data warehouse
Users can change data once entered into the data warehouse
21. ETL is an abbreviation for Elevation, Transformation and Loading
- TRUE
- FALSE
FALSE
22. which is the core of the multidimensional model that consists of a large set of facts and a number of dimensions?
- Multidimensional cube
- Data model
- Data cube
- None of the above
Data cube
23. Which of the following statements is incorrect
- ROLAPs have large data volumes
- Data form of ROLAP is large multidimentional array made of cubes
- MOLAP uses sparse matrix technology to manage data sparcity
- Access for MOLAP is faster than ROLAP
Data form of ROLAP is large multidimentional array made of cubes
24. Which of the following standard query techniques increase the granularity
- roll-up
- dril-down
- slicing
- dicing
dril-down
25. The full form of OLAP is
- Online Analytical Processing
- Online Advanced Processing
- Online Analytical Performance
- Online Advanced Preparation
Online Analytical Processing
26. Which of the following statements is/are incorrect about ROLAP
- ROLAP fetched data from data warehouse.
- ROLAP data store as data cubes.
- ROLAP use sparse matrix to manage data sparsity.
B and C
27. __ is a standard query technique that can be used within OLAP to zoom in to more detailed data by changing dimensions.
- Drill-up
- Drill-down
- Pivoting
- Drill-across
Drill-down
28. Which of the following statements is/are correct about Fact constellation
- Fact constellation schema can be seen as a combination of many star schemas.
- It is possible to create fact constellation schema, for each star schema or snowflake schema.
- Can be identified as a flexible schema for implementation.
All are correct
29. How to describe the data contained in the data warehouse?.
- Relational data
- Operational data
- Meta data
- Informational data
Meta data
30. The output of an OLAP query is displayed as a
- Pivot
- Matrix
- Excel
- both B and C
both B and C : Matrix and Excel
data mining and warehousing mcq questions
31. One can perform Query operations in the data present in Data Warahouse
- TRUE
- FALSE
TRUE
32. A __ combines facts from multiple processes into a single fact table and eases the analytic burden on BI applications.
- Aggregate fact table
- Consolidated fact table
- Transaction fact table
- Accumulating snapshot fact table
Consolidated fact table
33. In OLAP operations, Slicing is the technique of ____
- Selecting one particular dimension from a given cube and providing a new sub-cube
- Selecting two or more dimensions from a given cube and providing a new sub-cube
- Rotating the data axes in order to provide an alternative presentation of data
- Performing aggregation on a data cube
Selecting one particular dimension from a given cube and providing a new sub-cube
34. Standalone data marts built by drawing data directly from operational or external sources of data or both are known as independent data marts
- TRUE
- FALSE
TRUE
35. Focusing on the modeling and analysis of data for decision makers, not on daily operations or transaction processing is known
- Integrated
- Time-variant
- Subject oriented
- Non-volatile
Subject oriented
36. Most of the time data warehouse is
- Read
- Write
- Both
Read
37. Data granularity is ——————- of details of data ?
- summarization
- transformation
- level
level
38. Which one is not a type of fact?
- Fully Addictive
- Cumulative addictive
- Semi Addictive
- Non Addictive
Semi Addictive
39. When the level of details of data is reducing the data granularity goes higher
- True
- False
False
40. Data Warehouses are having summarized and reconciled data which can be used by decision makers
- True
- False
True
41. _____ refers to the currency and lineage of data in a data warehouse
- Operational metadata
- Business metadata
- Technical metadata
- End-User meatdata
Operational metadata
MORE DATA MINING AND WAREHOUSING MCQ :
Data mining mcq questions | dmw mcqs sppu
Data mining and warehousing mcq questions
Data mining and warehousing mcq unit 1
Data mining and warehousing mcq unit 2
Data Mining and Warehousing mcq sppu unit 4
Data Analytics sppu mcq
data mining and warehousing mcq, data mining and warehousing mcq sppu, data mining and warehousing mcq questions, data mining and data warehousing mcq, data mining and warehouse mcq, dmw mcq, data mining and warehousing multiple choice questions, data mining and warehousing mcq pdf, data warehouse mcq questions and answers, data mining quiz