1
Single choice~100s
An analyst inherits a model that is one huge flat table with 150 columns mixing sales amounts, product details, and customer details. What is the recommended remodeling?
Power BI Data Analyst
MS_PL_300Ready to test yourself?
A timed, blueprint-proportional exam drawn fresh from this bank — with a per-domain score report.
🔓 Free preview: showing 10 of 50 questions. Unlock the full bank — every question, explanation, and reference.
Unlock all 50 questions →10 questions across 4 topics. Choose an answer for each question, then check it to see the correct answer and explanation.
Filter by topic
2 questions in Model the Data
MODEL_DATA
Model the Data
2 questions in topicStar schemas, relationships, DAX calculations, and model optimization.
2
Single choice~100s
When relating the Customer dimension to the Sales fact table in Power BI, which cardinality is expected for a healthy model?