COMPUTER FUNDAMENTALS

Detailed explanation-1: -Answer: The heart of a data warehouse is its current detail. It is the place where the bulk of data resides. Current detail comes directly from operational systems and may be stored as raw data or as an aggregation of raw data.

Detailed explanation-2: -The reports created from complex queries within a data warehouse are used to make business decisions. A data warehouse stores historical data about your business so that you can analyze and extract insights from it. It does not store current information, nor is it updated in real-time.

Detailed explanation-3: -A data warehouse typically contains several years of historical data. The amount of data that you decide to make available depends on available disk space and the types of analysis that you want to support. This data can come from your transactional database archives or other sources.

Detailed explanation-4: -A data warehouse is specially designed for data analytics, which involves reading large amounts of data to understand relationships and trends across the data. A database is used to capture and store data, such as recording details of a transaction.