Microsoft Power Bi Quiz
10 questions · no time limit
0:00
DATA PREPARATION WITH POWER QUERY
Question 1 of 10
No time limit
Current
Answered
Flagged
Not seen
PASSAGE
A query contains
AssetID, Property, and PropertyValue. PropertyValue is text, and Property contains values such as Color and Location. An upstream join sometimes creates exact duplicate rows. You need one row per asset with property names as columns. Conflicting property values should remain visible as data-quality errors rather than being silently selected.Which approach should you use?
YOUR PROGRESS
10
QUESTIONS
Ready when you are
Answer in any order. Your progress shows here as you go.
QUESTIONS
KEYBOARD
Pick an answer ABCD
Next question ↵→
Previous ←
Flag for review F
Answers save as you go · flagged questions come back at the end