PL-300 Question 64

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• 1

  * Answer: - 1. Cross filter direction Switching from Both to Single direction improves performance because it reduces the complexity of query paths and avoids ambiguity in a star schema. - 2. star schema The Employee table is the central fact table, and the surrounding tables (Date, BU, AgeGroup, Gender, etc.) are dimension tables, which is the definition of a star schema.

• 1

  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.

• 2

  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