Multiple choice technology databases

The load and index is which of the following?

  1. A process to reject data from the data warehouse and to create the necessary indexes

  2. A process to load the data in the data warehouse and to create the necessary indexes

  3. A process to upgrade the quality of data after it is moved into a data warehouse

  4. A process to upgrade the quality of data before it is moved into a data warehouse
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The load and index process involves importing data into the data warehouse (loading) and building the indexes required for query performance. Data quality upgrades are part of cleansing and transformation processes that occur before or during the staging phase rather than the loading phase.

Keep practicing — related questions