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 on Bissoy. Bissoy App

• 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