Multiple choice technology databases

The extract process is which of the following?

  1. Capturing all of the data contained in various operational systems

  2. Capturing a subset of the data contained in various operational systems

  3. Capturing all of the data contained in various decision support systems

  4. Capturing a subset of the data contained in various decision support systems
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The extract process captures a subset of data from operational systems for loading into the data warehouse, not all data. Decision support systems are the targets, not sources, of the extract process. Selecting and extracting only relevant data is fundamental to ETL processes.

Keep practicing — related questions