Data Warehousing Questions and Answers

Practice Mode
Showing 10 of 15 questions
Q11
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: Option B
Q12
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 systems
Answer: Option B
Q13
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: Option C
Q14
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: Option A
Q15
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: Option D

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test