1Z0-515 · Question #62
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?
The correct answer is D. OLAP. 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…
Question
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?
Options
- AStar schema
- BSnowflake schema
- CThird normal form schema
- DOLAP
How the community answered
(20 responses)- A15% (3)
- B10% (2)
- C5% (1)
- D70% (14)
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.
Topics
Community Discussion
No community discussion yet for this question.