Learn how to identify dimension types and hierarchy models in data relationships for the Microsoft PL-300 certification exam. Understand the snowflake dimension and the hierarchy model in the provided table structure.
Table of Contents
Question
You have an organization dimension named DimOrganizations.
You have four related tables as shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
The tables represent a _________ dimension.
- degenerate
- junk
- role-playing
- snowflake
__________ is the only table that supports a hierarchy model for DimOrgVertical.
- DimOrganizations
- DimOrgSubVertical
- FactSales
Answer
The tables represent a snowflake dimension.
DimOrgSubVertical is the only table that supports a hierarchy model for DimOrgVertical.
Explanation
Dimension Type:
From the provided image, we can observe a snowflake schema. This is evident because the DimOrganizations table is normalized into multiple related tables (DimOrgVertical, DimOrgSubVertical, and DimOrganizations) that represent different levels of the dimension. A snowflake dimension extends beyond a star schema by further breaking down dimensions into sub-dimensions, which is the case here.
Correct answer: snowflake dimension
Hierarchy Model:
Looking at the relationship between the tables, DimOrgVertical and DimOrgSubVertical are organized in a way that suggests a hierarchical structure. DimOrgSubVertical serves as a child table to DimOrgVertical, indicating a hierarchy between vertical categories and subcategories.
Correct answer: DimOrgSubVertical supports the hierarchy for DimOrgVertical
Microsoft PL-300 certification exam assessment practice question and answer (Q&A) dump including multiple choice questions (MCQ) and objective type questions, with detail explanation and reference available free, helpful to pass the Microsoft PL-300 exam and earn Microsoft PL-300 certification.