Question

A data warehouse differs from an operational database in which of the following ways?Select one:a. Data in a data warehouse are not stored in tablesb. Data warehouses do not use primary key / foreign key relationshipsc. Data warehouse data are often stored in a dimensional databased. Both b and c are correct

Answer 1

Answer:

The second last point i.e "Data warehouse data are often stored in a dimensional databased " is the correct answer to the given question .

Explanation:

The main objective of the operation applications is implemented and enable the handling of large volumes transactions where as the data warehouses objective of the applications is implemented and enable the handling of large volumes of analytical transactions.

• The operational database is deal with the current data where as the data warehouse are deal with the historical data .
• The operational database  is deal with the business of real time where as the data warehouse is deal with analysis processing .
• All the other options are not correct for the data warehouse difference from the operational database that's why these options are incorrect .