Power BI Data Analyst (PL-300) practice exam: the relationship between tables

Henri Repovaara 30 Reputation points
2023-03-11T18:24:48.51+00:00

I did the PL-300 practice exam in Microsoft Learn, and one of the questions was:

You have designed a star schema to simplify your data. You need to understand the relationship between the tables in the star schema. What is the relationship between the fact tables and dimension tables?

Well, "between" doesn’t really address the positioning between the tables. I know that the fact table is the one with many values and dimension table is the one with unique values. But which option to choose: one-to-many or many-to-one? Fact is many, and dimension is one. I thought that the right answer is many-to-one, because the question is formulated as “between the fact tables and dimension tables”. In other words, facts tables, i.e., many-side is mentioned first. However, the right answer seems to be one-to-many: “There is one-to-many relationship between a fact table and dimension tables.” Have I understood something wrong or is the question ambiguous?

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,923 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Murtaza Ghafoor 0 Reputation points
    2024-01-28T07:40:59.08+00:00

    It should be many to one but one can say one to many relationship, actually, it is the direction of the relationship.

    but the answer is one to many.

    0 comments