Your customer is looking to implement ad-hoc analysis in a data warehouse. Which approach is
least likely to be used assuming that the customer does not want the expense of managing view?
A.
Star schema
B.
Snowflake schema
C.
Third normal form schema
D.
OLAP
Explanation:
Data warehouses often use denormalized or partially denormalized schemas (such
as a star schema) to optimize query performance. On the other hand OLTP (Online Transaction
Processing) systems often use fully normalized schemas to optimize update/insert/delete
performance, and to guarantee data consistency.
Reference: Oracle Database Data Warehousing Guide, 11g Release 1 (11.1)
Silly question, What does it mean does not want the expense of managing view?
Star schema is Third normal form schema.
Star schema is Third normal form schema.
I think correct answer is D