Data Mining And Warehouse Set 2
On This Page
This set of Data Mining and Data Warehouse Multiple Choice Questions & Answers (MCQs) focuses on Data Mining And Warehouse Set 2
Q1 | Detail data in single fact table is otherwise known as__________.
- monoatomic data.
- diatomic data.
- atomic data.
- multiatomic data.
Q2 | _______test is used in an online transactional processing environment.
- mega.
- micro.
- macro.
- acid.
Q3 | ___________ is a good alternative to the star schema.
- star schema.
- snowflake schema.
- fact constellation.
- star-snowflake schema.
Q4 | The biggest drawback of the level indicator in the classic star-schema is that it limits_________.
- quantify.
- qualify.
- flexibility.
- ability.
Q5 | A data warehouse is _____________.
- updated by end users.
- contains numerous naming conventions and formats
- organized around important subject areas.
- contains only current data.
Q6 | An operational system is _____________.
- used to run the business in real time and is based on historical data.
- used to run the business in real time and is based on current data.
- used to support decision making and is based on current data.
- used to support decision making and is based on historical data.
Q7 | The generic two-level data warehouse architecture includes __________.
- at least one data mart.
- data that can extracted from numerous internal and external sources.
- near real-time updates.
- far real-time updates.
Q8 | The active data warehouse architecture includes __________
- at least one data mart.
- data that can extracted from numerous internal and external sources.
- near real-time updates.
- all of the above.
Q9 | Reconciled data is ___________.
- data stored in the various operational systems throughout the organization.
- current data intended to be the single source for all decision support systems.
- data stored in one operational system in the organization.
- data that has been selected and formatted for end-user support applications.
Q10 | The extract process is ______.
- 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.
Q11 | Data scrubbing is _____________.
- a process to reject data from the data warehouse and to create the necessary indexes.
- a process to load the data in the data warehouse and to create the necessary indexes.
- a process to upgrade the quality of data after it is moved into a data warehouse.
- a process to upgrade the quality of data before it is moved into a data warehouse
Q12 | The load and index is ______________.
- a process to reject data from the data warehouse and to create the necessary indexes.
- a process to load the data in the data warehouse and to create the necessary indexes.
- a process to upgrade the quality of data after it is moved into a data warehouse.
- a process to upgrade the quality of data before it is moved into a data warehouse.
Q13 | Data transformation includes __________.
- a process to change data from a detailed level to a summary level.
- a process to change data from a summary level to a detailed level.
- joining data from one source into various sources of data.
- separating data from one source into various sources of data.
Q14 | ____________ is called a multifield transformation.
- converting data from one field into multiple fields.
- converting data from fields into field.
- converting data from double fields into multiple fields.
- converting data from one field to one field.
Q15 | The type of relationship in star schema is __________________.
- many-to-many.
- one-to-one.
- one-to-many.
- many-to-one.
Q16 | Fact tables are ___________.
- completely demoralized.
- partially demoralized.
- completely normalized.
- partially normalized.
Q17 | _______________ is the goal of data mining.
- to explain some observed event or condition.
- to confirm that data exists.
- to analyze data for expected relationships.
- to create a new data warehouse.
Q18 | Business Intelligence and data warehousing is used for ________.
- forecasting.
- data mining.
- analysis of large volumes of product sales data.
- all of the above.
Q19 | The data administration subsystem helps you perform all of the following, except__________.
- backups and recovery.
- query optimization.
- security management.
- create, change, and delete information.
Q20 | The most common source of change data in refreshing a data warehouse is _______.
- queryable change data.
- cooperative change data.
- logged change data.
- snapshot change data.
Q21 | ________ are responsible for running queries and reports against data warehouse tables.
- hardware.
- software.
- end users.
- middle ware.
Q22 | Query tool is meant for __________.
- data acquisition.
- information delivery.
- information exchange.
- communication.
Q23 | Classification rules are extracted from _____________.
- root node.
- decision tree.
- siblings.
- branches.
Q24 | Dimensionality reduction reduces the data set size by removing ____________.
- relevant attributes.
- irrelevant attributes.
- derived attributes.
- composite attributes.
Q25 | ___________ is a method of incremental conceptual clustering.
- corba.
- olap.
- cobweb.
- sting.