On This Page
This set of Data Warehouse Multiple Choice Questions & Answers (MCQs) focuses on Data Warehouse Set 1
Q1 | The data Warehouse is__________.
- read only.
- write only.
- read write only.
- none.
Q2 | The important aspect of the data warehouse environment is that data found within the data warehouse is___________.
- subject-oriented.
- time-variant.
- integrated.
- All of the above.
Q3 | __________ is the heart of the warehouse.
- Data mining database servers.
- Data warehouse database servers.
- Data mart database servers.
- Relational data base servers.
Q4 | The biggest drawback of the level indicator in the classic star-schema is that itlimits_________.
- 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 | Transient data is _____________.
- data in which changes to existing records cause the previous version of the records to be eliminated.
- data in which changes to existing records do not cause the previous version of the records to be eliminated.
- data that are never altered or deleted once they have been added.
- data that are never deleted once they have been added.
Q11 | 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.
Q12 | 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
Q13 | 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.
Q14 | 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.
Q15 | ____________ 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.
Q16 | The type of relationship in star schema is __________________.
- many-to-many.
- one-to-one.
- one-to-many.
- many-to-one.
Q17 | Fact tables are ___________.
- completely demoralized.
- partially demoralized.
- completely normalized.
- partially normalized.
Q18 | _______________ 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.
Q19 | Business Intelligence and data warehousing is used for ________.
- Forecasting.
- Data Mining.
- Analysis of large volumes of product sales data.
- All of the above.
Q20 | The data administration subsystem helps you perform all of the following,except__________.
- backups and recovery.
- query optimization.
- security management.
- create, change, and delete information.
Q21 | 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.
Q22 | ________ are responsible for running queries and reports against data warehousetables.
- Hardware.
- Software.
- End users.
- Middle ware.
Q23 | Query tool is meant for __________.
- data acquisition.
- information delivery.
- information exchange.
- communication.
Q24 | Classification rules are extracted from _____________.
- root node.
- decision tree.
- siblings.
- branches.
Q25 | Dimensionality reduction reduces the data set size by removing ____________.
- relevant attributes.
- irrelevant attributes.
- derived attributes.
- composite attributes.