1|Page
Microsoft Fabric DP-600 Certification
Exam 2026 | Latest Exam Questions
And Verified Answers
This form is best when writing data to a SQL DB - correct-answer -3rd normal form
(snowflake)
Thus form is best when reading SQL data - correct-answer -2nd normal form (fact)
Describe normalization - correct-answer -process of reducing duplicate data by
going from 1st to 2nd to 3rd normal form
Describe denormalization - correct-answer -process of increasing duplicate data,
but reducing relationships by going from 3rd to 2nd to 1st normal form.
If I have data in third normal form in power bi and want to denormalize, what
feature should i use? - correct-answer -Merge tables
, 2|Page
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.
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")
Microsoft Fabric DP-600 Certification
Exam 2026 | Latest Exam Questions
And Verified Answers
This form is best when writing data to a SQL DB - correct-answer -3rd normal form
(snowflake)
Thus form is best when reading SQL data - correct-answer -2nd normal form (fact)
Describe normalization - correct-answer -process of reducing duplicate data by
going from 1st to 2nd to 3rd normal form
Describe denormalization - correct-answer -process of increasing duplicate data,
but reducing relationships by going from 3rd to 2nd to 1st normal form.
If I have data in third normal form in power bi and want to denormalize, what
feature should i use? - correct-answer -Merge tables
, 2|Page
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.
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")
