Data Warehousing MCQ

Test your knowledge with important Data Warehousing MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Data Warehousing MCQs at Bissoy

• Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.
  ক

  True

  খ

  False
• Every key used to join the fact table with a dimensional table should be a surrogate key.
  ক

  True

  খ

  False
• Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.
  ক

  True

  খ

  False
• Static extract is used for ongoing warehouse maintenance.
  ক

  True

  খ

  False
• Both status data and event data can be stored in a database.
  ক

  True

  খ

  False
• Periodic data are data that are physically altered once added to the store.
  ক

  True

  খ

  False
• Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.
  ক

  True

  খ

  False
• Data in the data warehouse are loaded and refreshed from operational systems.
  ক

  True

  খ

  False
• The role of the ETL process is to identify erroneous data and to fix them.
  ক

  True

  খ

  False
• Joining is the process of partitioning data according to predefined criteria.
  ক

  True

  খ

  False
• Independent data marts are often created because an organization focuses on a series of short-term business objectives.
  ক

  True

  খ

  False
• Most operational systems are based on the use of transient data.
  ক

  True

  খ

  False
• Data in operational systems are typically fragmented and inconsistent.
  ক

  True

  খ

  False
• Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.
  ক

  True

  খ

  False
• A data mart is designed to optimize the performance for well-defined and predicable uses.
  ক

  True

  খ

  False
• A multifield transformation does which of the following?
  ক

  Converts data from one field into multiple fields

  খ

  Converts data from multiple fields into one field

  গ

  Converts data from multiple fields into multiple fields

  ঘ

  All of the above
• Transient data is which of the following?
  ক

  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
• A star schema has what type of relationship between a dimension and fact table?
  ক

  Many-to-many

  খ

  One-to-one

  গ

  One-to-many

  ঘ

  All of the above
• 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
• Reconciled data is which of the following?
  ক

  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.
• Data transformation includes which of the following?
  ক

  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
• Fact tables are which of the following?
  ক

  Completely denoralized

  খ

  Partially denoralized

  গ

  Completely normalized

  ঘ

  Partially normalized
• 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
• A snowflake schema is which of the following types of tables?
  ক

  Fact

  খ

  Dimension

  গ

  Helper

  ঘ

  All of the above
• 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.
• An operational system is which of the following?
  ক

  A system that is used to run the business in real time and is based on historical data.

  খ

  A system that is used to run the business in real time and is based on current data.

  গ

  A system that is used to support decision making and is based on current data.

  ঘ

  A system that is used to support decision making and is based on historical data.
• The @active 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 scrubbing is which of the following?
  ক

  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
• Which of the following is not a function of a Warehouse?
  ক

  Ensuring Profit

  খ

  Stabilisation in price

  গ

  Risk-bearing

  ঘ

  Storage