A Store dimension is identified only by Region plu...

PL-300 Practice Questions - Microsoft Power BI Data Analyst Associate (PL-300) Exam

Question Number 5

A Store dimension is identified only by Region plus StoreCode together, so no single column is unique. How do you make it relatable to the fact table?

Merge both columns into one key column Create a relationship on both columns at once Set the relationship cardinality to many-to-many Sort both tables by Region and StoreCode

✔ Correct Answer:

Merge both columns into one key column

PL-300 Practice Questions - Microsoft Power BI Data Analyst Associate (PL-300) Exam

Question Number 5

Count Down:

Related questions :