Page | 1
MICROSOFT FABRIC DP-600
CERTIFICATION 2026 REAL
QUESTIONS WITH EXPERTLY
VERIFIED ANSWERS.
If I have data in third normal form in power bi and want to
denormalize, what feature should i use? - correct answer -Merge
tables
What does it mean to merge tables/queries - correct answer -
Taking two tables/queries and combining them into one using a
join, and then removing duplicate columns
Describe the data model wide consequence of adding a
calculation group - correct answer -Fields can no longer be used
for implicit measures, only explicit
What is an implicit measure? - correct answer -An implicit
measure is when a field is taken from a table/query and added to
a visual, and the aggregation is done within the visual.
, Page | 2
e.g. take order number, add it to a bar graph, and have the visual
do a count distinct of order number as the value
What is an explicit measure? - correct answer -An explicit
measure is when a measure is added as a separate field using
DAX
e.g. Click create new measure, and apply formula:
CALCULATE(DISTINCTCOUNT(OrderNumber),Year = "2024")
What is a calculation group - correct answer -It basically uses the
CALCULATE function, but it can be used on any measure in the
data model.
So, for example, if I wanted to see YTD, then I could make a YTD
calc group, bring that into a matrix as a column, and add many
different measures and they'll all get aggregated on year to date.
What are the 4 reasons for using dax variables - correct answer -
1) improve performance if something is being used multiple times
2) improve readability
MICROSOFT FABRIC DP-600
CERTIFICATION 2026 REAL
QUESTIONS WITH EXPERTLY
VERIFIED ANSWERS.
If I have data in third normal form in power bi and want to
denormalize, what feature should i use? - correct answer -Merge
tables
What does it mean to merge tables/queries - correct answer -
Taking two tables/queries and combining them into one using a
join, and then removing duplicate columns
Describe the data model wide consequence of adding a
calculation group - correct answer -Fields can no longer be used
for implicit measures, only explicit
What is an implicit measure? - correct answer -An implicit
measure is when a field is taken from a table/query and added to
a visual, and the aggregation is done within the visual.
, Page | 2
e.g. take order number, add it to a bar graph, and have the visual
do a count distinct of order number as the value
What is an explicit measure? - correct answer -An explicit
measure is when a measure is added as a separate field using
DAX
e.g. Click create new measure, and apply formula:
CALCULATE(DISTINCTCOUNT(OrderNumber),Year = "2024")
What is a calculation group - correct answer -It basically uses the
CALCULATE function, but it can be used on any measure in the
data model.
So, for example, if I wanted to see YTD, then I could make a YTD
calc group, bring that into a matrix as a column, and add many
different measures and they'll all get aggregated on year to date.
What are the 4 reasons for using dax variables - correct answer -
1) improve performance if something is being used multiple times
2) improve readability
