Discussion
Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.
Answer: B
Correct answer: False
The star schema is designed for analytical querying, not for transaction processing. Its denormalised dimensions make queries fast and updates awkward, which is exactly the wrong balance for an operational system - those use normalised designs, and an enterprise warehouse uses a normalised reconciled layer as well.
No comment is present. Be the first to comment.
Loading…
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development