The following statement applies to data warehouses: Data warehouses are typicall
ID: 3910033 • Letter: T
Question
The following statement applies to data warehouses:
Data warehouses are typically constrained to a single application.
Data warehouses are optimized for performing read-write operations of single point transactions.
Data warehouses integrate copies of transaction data from disparate source systems.
Data warehouses are linked to the front-end application.
The following is an example of integrated:
a. Each sales representative's sales are tracked over time.
b. The data warehouse is designed to track sales.
c. Sales representatives' information is only stored once.
d. Revenue is calculated by sales, region, etc.
e. Revenue data is extracted from the data warehouse.
Which of the following statements is true in multidimensional structures:
The fact table is referred to as a cube
The columns within the fact table are referred to as measures.
The cube has edges which are referred to as dimensions.
Cubes, measures and dimensions interact with each other for reporting
All of the above.
None of the above.
Explanation / Answer
Answer is as follows :
a) Data Warehouse are the technique for collecting and managing the data from various sources to a single application or unit. These are read only systems and they are not transaction processing systems i.e. OLTP. Data warehouse collect the data from different sources and make copies of transaction data.
So the correct option is C
b) Data Warehouse are constructed by integrating data from heterogeneous sources
So correct option is D. because revenue is calculated from different types of data..
c) The correct option is D i.e. all of the above.
if there is any query please ask in comments...