Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
You are designing a semantic model for a library management system that includes 'Authors' and 'Books' tables. The system must support a scenario where an author can write multiple books, and a book can have multiple authors, establishing a many-to-many relationship. Considering the need for scalability, performance, and accurate representation of data relationships, which of the following approaches is the BEST to implement this relationship? (Choose one option)
A
Directly create a many-to-many relationship between 'Authors' and 'Books' without any intermediary table, relying on the database engine to handle the complexity.
B
Create two separate one-to-many relationships, one from 'Authors' to 'Books' and another from 'Books' to 'Authors', to simulate the many-to-many relationship.
C
Implement a bridge table, also known as a junction table, that contains foreign keys referencing the primary keys of both 'Authors' and 'Books' tables to accurately represent the many-to-many relationship.
D
Avoid implementing any relationship between 'Authors' and 'Books' to simplify the model, and manage the relationship logic in the application layer.