Data warehouse Objective type Questions & Answers

Questions
1 Data scrubbing is which of the following?
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

Answer: A process to upgrade the quality of data before it is moved into a data warehouse
2 The @active data warehouse architecture includes which of the following?
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

Answer: All of the above

⭐ Make GKSeries Your Preferred Source on Google

Add GKSeries as Preferred Source
3 A goal of data mining includes which of the following?
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

Answer: To explain some observed event or condition
4 An operational system is which of the following?
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.

Answer: A system that is used to run the business in real time and is based on current data.
5 A data warehouse is which of the following?
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.

Answer: Organized around important subject areas.
6 Data scrubbing is which of the following?
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

Answer: A process to upgrade the quality of data before it is moved into a data warehouse
7 The @active data warehouse architecture includes which of the following?
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.

Answer: All of the above.
8 A goal of data mining includes which of the following?
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

Answer: To explain some observed event or condition
9 An operational system is which of the following?
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.

Answer: A system that is used to run the business in real time and is based on current data.
10 A data warehouse is which of the following?
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.

Answer: Organized around important subject areas.
11 A snowflake schema is which of the following types of tables?
A Fact
B Dimension
C Helper
D All of the above

Answer: All of the above
12 The generic two-level data warehouse architecture includes which of the following?
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.

Answer:Data that can extracted from numerous internal and external sources
13 Fact tables are which of the following?
A Completely denoralized
B Partially denoralized
C Completely normalized
D Partially normalized

Answer: Completely normalized
14 Data transformation includes which of the following?
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

Answer: A process to change data from a detailed level to a summary level
15 Reconciled data is which of the following?
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.

Answer: Current data intended to be the single source for all decision support systems.
16 The load and index is which of the following?
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

Answer: A process to load the data in the data warehouse and to create the necessary indexes
17 The extract process is which of the following?
A Capturing all of the data contained in various operational systems
B Capturing a subset of the data contained in various operational systems
C Capturing all of the data contained in various decision support systems
D Capturing a subset of the data contained in various decision support

Answer: Capturing a subset of the data contained in various operational systems
18 A star schema has what type of relationship between a dimension and fact table?
A Many-to-many
B One-to-one
C One-to-many
D All of the above.

Answer: One-to-many
19 Transient data is which of the following?
A Data in which changes to existing records cause the previous version of the records to be eliminated
B Data in which changes to existing records do not cause the previous version of the records to be eliminated
C Data that are never altered or deleted once they have been added
D Data that are never deleted once they have been added

Answer: Data in which changes to existing records cause the previous version of the records to be eliminated
20 A multifield transformation does which of the following?
A Converts data from one field into multiple fields
B Converts data from multiple fields into one field
C Converts data from multiple fields into multiple fields
D All of the above

Answer: All of the above
ADRE 3.0 Complete Study Material