Exam PL-300 topic 2 question 9 discussion

It should be cross filter direction. As the answer correctly states "Assume Referential Integrity" only works for direct query connections.

It should be : - cross filter direction - star schema

ChatGTP answer: Based on the Power BI data model in your first image and the answer choices in your second image, here are the correct selections: Changing the [answer choice] setting of the relationships will improve report query performance. Correct answer: "Cardinality" Reason: Cardinality defines the relationship type (one-to-one, one-to-many, many-to-many). Optimizing cardinality settings (e.g., using one-to-many instead of many-to-many) improves query performance. The data model is organized into a [answer choice]. Correct answer: "star schema" Reason: The model consists of a central fact table (Employee) connected to multiple dimension tables (Date, Gender, Ethnicity, etc.) in a star-like structure. This is characteristic of a star schema, which is optimized for Power BI reporting.

1. Cross Filter Direction: this will change the arrows from both to single. This results in a different slicer behavior in the report, but the model can still work and the performance is better (this is the intent of the question, to improve performance). 2. Snowflake Schema: The trick is that the shape looks like a star, but there are NO fact tables here, ONLY dimensions broken down further i.e. the very definition of a snowflake

I agree with the cross-filter-direction part, answer A. I have doubts regarding the start schema because Employee seems to a dimension model rather than a fact table. But I guess it's the right answer du to the one-to-many relationships.

My vote also for "cross direction filtering" which is set to "both directoins in all relationships in the data model, and the "star schema" answer

I agree with you guys it should be: 1 - Cross filter direction 2 - star schema of course

Cross Filter & Star is correct

The answers can only be: - cross filter direction - star schema Cross filter direction set to both in msot relatioships are a mess.

Assume referential integrity? Really? After seeing that mess of cross filters in the star schema? And then in the provided answer it says assume referential integrity setting works for direct query, even though the question states this is an imported dataset.

answer choke

Honestly.. I think Microsoft is publishing fake answers to avoid people studying answers only and force them to think based on acquired knowledge. When you look at the icons next to the tables in the model, those are IMPORTED icons, not direct query. Direct query icons are represented with a square having at the bottom right corner two arrows, one in, one out. Also, when you do the labs, you have an exercise called Sales Analysis with a similar model (star) that you will publish to PBI service and there is no cross filter direction

The answer should be: Cross Filter direction. Star Schema.

Cross filter direction & Start schema

As to the confusion of star or snowflakes schema, If this is a star schema, then the Employee table is a factless fact table.

Cross filter Direction and Star Schema are the correct options. Changing the cross filter direction setting can have a significant impact on query performance. Setting it to "Single" when appropriate can often improve performance by reducing unnecessary filtering in both directions. In Star Schema, the central table (usually a fact table) is connected to dimension tables through one-to-many or many-to-many relationships.

import dataset --> cross filter, the referential itnegrity only works with direct query. And star schema, pretty direct