Multiple choice technology

why we need data ware housing?

  1. In OLTP approach, historical data was archived to update the recent information in the system and even it is bit difficult to update that information everywhere in OLTP. Unlike OLTP; DW stores historical data to compare trends over period of time.

  2. As it has one DB at the end, number of sources can be used to transfer data and sources cab be relational DB, Flat File, Unix file. ETL tool handles these source files to transfer data from source to target.

  3. DW stores the necessary data for specific analysis; not jus all data.

  4. DW is commonly used by organizations to analyze trends over time.
Reveal answer Fill a bubble to check yourself
A,B,C,D Correct answer
Explanation

Data warehousing addresses four key needs: (A) preserving historical data for trend comparison unlike OLTP which archives, (B) consolidating data from multiple sources via ETL tools, (C) storing only relevant data for analysis rather than everything, and (D) enabling trend analysis over time. All four options correctly describe data warehouse benefits.

Keep practicing — related questions