Exam PL-300 topic 2 question 89 discussion

Actual exam question from Microsoft's PL-300

Question #: 89
Topic #: 2

HOTSPOT
-

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.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by rcaliandro at Sept. 5, 2024, 2:23 p.m.

Comments

Submit Cancel

rcaliandro

Highly Voted 7 months, 3 weeks ago

The answer is correct. It is a snowflakeschema and DimOrgSubVertical is the only table that supports a hierarchy model for DimOrgVertical

upvoted 8 times

MonikaStop

7 months, 1 week ago

I agree

upvoted 2 times

...

LuluSkyy

Highly Voted 6 months, 2 weeks ago

can someone please explain why DimOrgSubVertical supports a hierarchy for the model?

upvoted 6 times

0ab376f

5 months ago

co ask

upvoted 1 times

...

jaume

Most Recent 5 months, 1 week ago

A degenerate dimension refers to a dimension key in a fact table that does not have its own dimension table. Junk Dimension is a dimension table in a data warehouse that combines several low cardinality flags and indicators to improve the efficiency of queries. A role-playing dimension refers to a single dimension table that is utilized multiple times within a fact table, each time representing a different logical role or perspective. The one in the exhibit is a SNOWFLAKE SCHEMA (not dimension) as the fact table is related to dim tables which can be linked to other dim tables. DimOrgSubVertical is the only table supporting hierarchy model for DimOrgVertical (DimOrganization could support hierarchy for DimSubVrtical)