Which two statements are true about the advantages of using a data warehouse?
A.
A data warehouse uses fewer database structures, so access to answers is faster and easier
B.
A data warehouse is typically implemented with a different design, making access faster.
C.
A data warehouse is optimized for ongoing write activity, making response faster.
D.
A data warehouse uses specialized features of the Oracle database, like materialized views
and star transformations, making response faster.
Explanation:
Data warehouses often use denormalized or partially denormalized schemas (such
as a star schema) to optimize query performance.Note: A materialized view is a pre-computed table comprising aggregated or joined data from fact
and possibly dimension tables. Also known as a summary or aggregate table.
Reference: Oracle Database Data Warehousing Guide, 11g Release 1 (11.1)