Microsoft
70-463 · Question #227
70-463 Question #227: Real Exam Question with Answer & Explanation
The correct answer is A: A Star schema typically has fewer tables than a normalized schema.. 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
Explanation
Star schemas simplify reporting because they reduce the number of joins needed and use a standardized, self-describing structure that makes data discovery intuitive.
Common mistakes.
- B. 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.
- C. There are no Transact-SQL expressions or syntax constructs specifically designed for or exclusive to Star schema structures.
Concept tested. Star schema design advantages over normalized OLTP schemas
Reference. https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
Community Discussion
No community discussion yet for this question.