70-463 · Question #227
Reporting from a Star schema is simpler than reporting from a normalized online transactional processing (OLTP) schema. What are the reasons for wanting simpler reporting? (Choose all that apply.)
The correct answer is A. A Star schema typically has fewer tables than a normalized schema. D. A Star schema is standardized and narrative; you can find the information you need for a. Star schemas simplify reporting because they reduce the number of joins needed and use a standardized, self-describing structure that makes data discovery intuitive.
Question
Reporting from a Star schema is simpler than reporting from a normalized online transactional processing (OLTP) schema. What are the reasons for wanting simpler reporting? (Choose all that apply.)
Options
- AA Star schema typically has fewer tables than a normalized schema.
- BA Star schema has better support for numeric data types than a normalized relational
- CThere are specific Transact-SQL expressions that deal with Star schemas.
- DA Star schema is standardized and narrative; you can find the information you need for a
How the community answered
(45 responses)- A91% (41)
- B2% (1)
- C7% (3)
Why each option
Star schemas simplify reporting because they reduce the number of joins needed and use a standardized, self-describing structure that makes data discovery intuitive.
A Star schema consolidates normalized tables into fewer dimension and fact tables, which reduces join complexity and makes queries easier to write and understand.
SQL Server supports the same numeric data types regardless of schema design; Star schemas have no special advantage over normalized schemas for numeric type support.
There are no Transact-SQL expressions or syntax constructs specifically designed for or exclusive to Star schema structures.
A Star schema follows a well-known standardized pattern where dimension names and fact table relationships are descriptive, allowing analysts to navigate and find needed data more easily.
Concept tested: Star schema design advantages over normalized OLTP schemas
Source: https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
Topics
Community Discussion
No community discussion yet for this question.