Curioustab
Aptitude
General Knowledge
Verbal Reasoning
Computer Science
Interview
Aptitude
General Knowledge
Verbal Reasoning
Computer Science
Interview
Home
»
Database
»
Data Warehousing
The load and index 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
Correct Answer:
A process to load the data in the data warehouse and to create the necessary indexes
← Previous Question
Next Question→
More Questions from
Data Warehousing
A multifield transformation does which of the following?
The role of the ETL process is to identify erroneous data and to fix them.
A data mart is designed to optimize the performance for well-defined and predicable uses.
Data in operational systems are typically fragmented and inconsistent.
Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.
Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.
Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.
Data in the data warehouse are loaded and refreshed from operational systems.
Every key used to join the fact table with a dimensional table should be a surrogate key.
Both status data and event data can be stored in a database.
Discussion & Comments
No comments yet. Be the first to comment!
Name:
Comment:
Post Comment
Join Discussion
Discussion & Comments