PL-300 Ep 6 Star Schema & Relationships | 10 Exam Questions Verified on Microsoft Learn walkthrough

Episode 6 of the MSExamLab PL-300 series: Star Schema and Relationships. Ten real exam-style questions on cardinality and filter direction, relationship naming, dimension types, fact-table grain, and the multiple-dates problem - each answer worked through and verified against Microsoft Learn before recording. Every answer in this video was checked, question by question, against Microsoft's official documentation. No dump-site guesswork; where the question bank is wrong, the correction is shown on screen and explained. The idea that unlocks this topic: read the relationship from the grain. One row per customer, many rows per transaction, so the relationship runs one-to-many from the dimension to the fact, and filters flow down. Say it precisely - active, single-direction, many-to-one from the fact - and most of these questions answer themselves. What you'll practise in this episode: Matching data types before a relationship will form Reading cardinality and direction from the grain (one-to-many from the unique side) Naming a relationship precisely: active, single-direction, many-to-one Choosing the cardinality with the fastest DAX performance (many-to-one) Identifying dimension types: role-playing, junk, degenerate and Type 2 SCD Getting the fact grain right by merging headers into line items Reducing 30 million rows by grouping at the source, then relating one-to-many Hiding a key the model needs and deleting a column nothing needs Making bidirectional cross-filtering honour row-level security Solving sales-by-three-dates with role-playing tables or USERELATIONSHIP measures How each question works: a blank exam-style question appears with a ten-second timer, then the worked solution follows with a clear explanation of why each distractor fails. Pause whenever you need longer, and replay the answer to lock it in. Who this is for: anyone preparing for Exam PL-300: Microsoft Power BI Data Analyst, first sitting or retake. The questions mirror the real exam's style and difficulty without reproducing live items. A note on method: each answer is reconciled with the current Microsoft Learn documentation for Power BI and Microsoft Fabric at the time of recording. If Microsoft changes a behaviour later, comment with the question number and it will be re-verified and pinned. CHAPTERS 0:00 Intro & what you'll learn 0:56 Q1 - Before the relationship exists 2:37 Q2 - Which way does it point 4:13 Q3 - Naming the relationship 5:55 Q4 - Cardinality for speed 7:21 Q5 - Naming the dimension type 8:59 Q6 - Getting the fact grain right 10:45 Q7 - Thirty million impressions 12:43 Q8 - Hide or delete 14:23 Q9 - Cross-filtering with RLS 16:15 Q10 - Sales by three dates 18:41 Episode recap 19:16 Next episode & subscribe New episodes work through the whole PL-300 objective domain - Prepare, Model, Visualize, and Deploy - one focused set at a time. Subscribe so you catch every episode, and drop the number of any question that caught you out in the comments. Channel:    / @msexamlab   Full PL-300 playlist: open the channel Playlists tab and choose PL-300. Answers verified vs Microsoft Learn. This is exam preparation and revision practice; it is not a brain dump and does not reproduce live exam items. Tags: #PL300 #PL300Exam #PL300Prep #PL300Questions #PowerBI #PowerBIExam #MicrosoftPL300 #DataAnalystAssociate #PowerBICertification #StarSchema #Relationships #Cardinality #CrossFilter #FilterDirection #ManyToOne #OneToMany #ManyToMany #RolePlayingDimension #JunkDimension #DegenerateDimension #Type2SCD #SlowlyChangingDimension #FactTable #DimensionTable #FactGrain #USERELATIONSHIP #InactiveRelationship #ActiveRelationship #RowLevelSecurity #RLS #BidirectionalFilter #DataModeling #SemanticModel #PowerQuery #DataReduction #MicrosoftFabric #PowerBIDesktop #DataAnalytics #BusinessIntelligence #MSExamLab #ExamPrep #PowerBITutorial #MicrosoftCertification #DA100 #MicrosoftLearn #StarSchemaDesign #ModelRelationships #PowerBIModeling #MultipleDates #DateTable #PowerBIReports #AnalystExam #CertPrep #MSFabric #ModelDesign #DAXPerformance #PL300Practice #PowerBIPrep #DataAnalyst #MicrosoftExam #PowerBILearning #FabricAnalytics #PowerBIExamPrep #PL300Revision #DataModelDesign #PowerBIModeling #ExamQuestions #PracticeTest #PowerBISkills #StarSchemaModel #KimballModeling #DimensionalModeling #ManyToManyRelationship #FilterFlow #GrainOfFact #SurrogateKey #CompositeKey #ActiveVsInactive #DAXPerformanceTuning #ModelOptimization #PowerBICourse #LearnPowerBI #MicrosoftDataAnalyst #PL300Study #BItutorial #AnalyticsExam #PowerBIcert #FabricExam #RelationshipCardinality #CrossFilterDirection #RolePlayingDates #TimeIntelligence #DataPrep #PassPL300 #PowerBITips #MicrosoftLearnVerified #ExamRevision #ModelViewPowerBI #BridgeTable #PowerBIRelationships #DimensionTypes #JunkDimensionExplained #DegenerateDimension #Type2SCDExplained #FactTableGrain #StarVsSnowflake #ModelPerformance #PowerBIStar #PL300Prep2026 #DAX