Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 2 question 89 discussion

Actual exam question from Microsoft's PL-300
Question #: 89
Topic #: 2
[All PL-300 Questions]

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 Hide Answer
Suggested Answer:
by rcaliandro at Sept. 5, 2024, 2:23 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
rcaliandro
Highly Voted 2 months, 2 weeks ago
The answer is correct. It is a snowflakeschema and DimOrgSubVertical is the only table that supports a hierarchy model for DimOrgVertical
upvoted 6 times
MonikaStop
2 months ago
I agree
upvoted 2 times
...
...
jaume
Most Recent 1 day, 10 hours 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)
upvoted 1 times
...
LuluSkyy
1 month, 1 week ago
can someone please explain why DimOrgSubVertical supports a hierarchy for the model?
upvoted 3 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel