Data Science Wire

Question on Many-to-Many relationships

Reddit r/PowerBI1d4 min read

Hi All, I am currently studying for the PL-300 and came across a question in a measure up practice exam regarding many to many relationships. The questions was regarding choosing the proper cardinality for a relationship between two tables, which both did not have unique keys. I was always taught that databases did not handle many to many relationships well, so it was best practice to create a bridging table and join all three tables with one to many relationships. I selected this answer, and measure up marked it as wrong. Instead you should’ve chosen a straight up many to many relationship. T

Read the full story at Reddit r/PowerBI

More in Analytics Engineering