DP-600 EXAM WITH QUESTIONS AND
ANSWERS 2024-2025
What are the two types of Fabric licenses?
Per user licenses and Capacity licenses.
What are the SKUs for Fabric (capacity licensing)?
F2^a where the capacity units are 2^a and the Power BI v-cores are 2^(a-3). For
example, SKU F4 has 4 capacity units and 0.5 Power BI v-cores.
What three things does Microsoft claim a Fabric license allows you to do?
1. Use all the Microsoft Fabric features licensed by capacity
2. Create Microsoft fabric items and connect to other Microsoft Fabric items.
3. Save your items to a workspace and share them with a user that has an
appropriate license.
SKUs that are smaller than ______ require a Pro or Premium Per User PPU license
or a Power BI individual trial to consume Power BI content.
F64
What are the three types of individual licenses?
1. Free - a free license allows you to create and share Fabric content other than
Power BI items in Microsoft Fabric if you have access to a Fabric capacity (either
trial or paid).
2. Pro - a Pro license lets you share Power BI content with other users. Every
organization needs at least one user with a Pro or a Premium Per User (PPU)
license if they intend to use Power BI within Fabric.
3. Premium per-user (PPU) - PPU licenses allow organizations to access Power BI
Premium features by licensing every user with a PPU license instead of purchasing
a Power BI Premium capacity. PPU can be more cost-effective when Power BI
, Premium features are needed for less than 250 users.
Can you create non-Power BI items with a PPU license?
No.
Does Fabric support auto-scaling?
Not as of making this flashcard (3/19/2024). But auto-scaling is coming. In the
meantime, it'll have to be done manually.
What is the fastest and most direct method for migrating data from one system to
another with no transformations applied?
The Pipeline Copy data tool
What Fabric tool is best for moving a large data set to another destination?
The Pipeline Copy Data tool
What should dimension tables store?
All attributes that describe a business entity
What should fact tables store?
Observations/events of a business entity
What are Type 1, 2, and 3 Dimension tables?
Type 1 - No history is preserved but the makes it space efficient
Type 2 - History is preserved but this makes the size of the table large
Type 3 - Keep previous information in the same row as current information. For
example, if I move, the old address is in the same row as the new one and is just
labelled as old.
What does this DAX measure do:
RANKX( ALL( 'Product'[Product Name] ), [Sales],, DESC, Skip )
Ranks the product names by Sales, with the largest values getting the smallest (e.g.
1,2,3) ranks, and when product names have tied values, then the next rank value,
ANSWERS 2024-2025
What are the two types of Fabric licenses?
Per user licenses and Capacity licenses.
What are the SKUs for Fabric (capacity licensing)?
F2^a where the capacity units are 2^a and the Power BI v-cores are 2^(a-3). For
example, SKU F4 has 4 capacity units and 0.5 Power BI v-cores.
What three things does Microsoft claim a Fabric license allows you to do?
1. Use all the Microsoft Fabric features licensed by capacity
2. Create Microsoft fabric items and connect to other Microsoft Fabric items.
3. Save your items to a workspace and share them with a user that has an
appropriate license.
SKUs that are smaller than ______ require a Pro or Premium Per User PPU license
or a Power BI individual trial to consume Power BI content.
F64
What are the three types of individual licenses?
1. Free - a free license allows you to create and share Fabric content other than
Power BI items in Microsoft Fabric if you have access to a Fabric capacity (either
trial or paid).
2. Pro - a Pro license lets you share Power BI content with other users. Every
organization needs at least one user with a Pro or a Premium Per User (PPU)
license if they intend to use Power BI within Fabric.
3. Premium per-user (PPU) - PPU licenses allow organizations to access Power BI
Premium features by licensing every user with a PPU license instead of purchasing
a Power BI Premium capacity. PPU can be more cost-effective when Power BI
, Premium features are needed for less than 250 users.
Can you create non-Power BI items with a PPU license?
No.
Does Fabric support auto-scaling?
Not as of making this flashcard (3/19/2024). But auto-scaling is coming. In the
meantime, it'll have to be done manually.
What is the fastest and most direct method for migrating data from one system to
another with no transformations applied?
The Pipeline Copy data tool
What Fabric tool is best for moving a large data set to another destination?
The Pipeline Copy Data tool
What should dimension tables store?
All attributes that describe a business entity
What should fact tables store?
Observations/events of a business entity
What are Type 1, 2, and 3 Dimension tables?
Type 1 - No history is preserved but the makes it space efficient
Type 2 - History is preserved but this makes the size of the table large
Type 3 - Keep previous information in the same row as current information. For
example, if I move, the old address is in the same row as the new one and is just
labelled as old.
What does this DAX measure do:
RANKX( ALL( 'Product'[Product Name] ), [Sales],, DESC, Skip )
Ranks the product names by Sales, with the largest values getting the smallest (e.g.
1,2,3) ranks, and when product names have tied values, then the next rank value,
