Data Warehousing - General Questions Online Exam Quiz
Data Warehousing - General Questions GK Quiz. Question and Answers related to Data Warehousing - General Questions. MCQ (Multiple Choice Questions with answers about Data Warehousing - General Questions
Data scrubbing is which of the following?
Options
A : A process to reject data from the data warehouse and to create the necessary indexes
B : A process to load the data in the data warehouse and to create the necessary indexes
C : A process to upgrade the quality of data after it is moved into a data warehouse
D : A process to upgrade the quality of data before it is moved into a data warehouse
The @active data warehouse architecture includes which of the following?
Options
A : At least one data mart
B : Data that can extracted from numerous internal and external sources
C : Near real-time updates
D : All of the above.
A goal of data mining includes which of the following?
Options
A : To explain some observed event or condition
B : To confirm that data exists
C : To analyze data for expected relationships
D : To create a new data warehouse
An operational system is which of the following?
Options
A : A system that is used to run the business in real time and is based on historical data.
B : A system that is used to run the business in real time and is based on current data.
C : A system that is used to support decision making and is based on current data.
D : A system that is used to support decision making and is based on historical data.
A data warehouse is which of the following?
Options
A : Can be updated by end users.
B : Contains numerous naming conventions and formats.
C : Organized around important subject areas.
D : Contains only current data.
A snowflake schema is which of the following types of tables?
Options
A : Fact
B : Dimension
C : Helper
D : All of the above
The generic two-level data warehouse architecture includes which of the following?
Options
A : At least one data mart
B : Data that can extracted from numerous internal and external sources
C : Near real-time updates
D : All of the above.
Fact tables are which of the following?
Options
A : Completely denoralized
B : Partially denoralized
C : Completely normalized
D : Partially normalized
Data transformation includes which of the following?
Options
A : A process to change data from a detailed level to a summary level
B : A process to change data from a summary level to a detailed level
C : Joining data from one source into various sources of data
D : Separating data from one source into various sources of data
Reconciled data is which of the following?
Options
A : Data stored in the various operational systems throughout the organization.
B : Current data intended to be the single source for all decision support systems.
C : Data stored in one operational system in the organization.
D : Data that has been selected and formatted for end-user support applications.
Advanced SQL - General Questions more Online Exam Quiz
Data and Database Administration - General Questions
Database Design Using Normalization - General Questions
Database Processing for BIS - General Questions
Database Redesign - General Questions
Data Modeling with ER Model - General Questions
Distributed Databases - General Questions
Introduction to Database - General Questions
Introduction to SQL - General Questions