DP-600 Exam UPDATED ACTUAL Exam
Questions and CORRECT Answers
What are the two types of Fabric licenses? - CORRECT ANSWER - Per user licenses and
Capacity licenses.
What are the SKUs for Fabric (capacity licensing)? - CORRECT ANSWER - 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? - CORRECT
ANSWER - 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. - CORRECT ANSWER - F64
What are the three types of individual licenses? - CORRECT ANSWER - 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? - CORRECT ANSWER - No.
, Justify this statement: "Typically if you have more than 500 users (250 users in PPU license)
consuming and sharing Power BI content, it is recommended to purchase an F64 license or
higher." - CORRECT ANSWER -
Does Fabric support auto scaling? - CORRECT ANSWER - 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? - CORRECT ANSWER - The Pipeline Copy data tool
What tool is best for moving a large data set into another destination? - CORRECT
ANSWER - The Pipeline Copy Data tool
What should dimension tables store? - CORRECT ANSWER - All attributes that describe
a business entity
What should fact tables store? - CORRECT ANSWER - Observations/events of a business
entity
What are Type 1, 2, and 3 Dimension tables? - CORRECT ANSWER - 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 labeled as old.
What does this DAX measure do:
RANKX( ALL( 'Product'[Product Name] ), [Sales],, DESC, Skip ) - CORRECT
ANSWER - Ranks the product names by Sales, with the largest values getting the smallest
Questions and CORRECT Answers
What are the two types of Fabric licenses? - CORRECT ANSWER - Per user licenses and
Capacity licenses.
What are the SKUs for Fabric (capacity licensing)? - CORRECT ANSWER - 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? - CORRECT
ANSWER - 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. - CORRECT ANSWER - F64
What are the three types of individual licenses? - CORRECT ANSWER - 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? - CORRECT ANSWER - No.
, Justify this statement: "Typically if you have more than 500 users (250 users in PPU license)
consuming and sharing Power BI content, it is recommended to purchase an F64 license or
higher." - CORRECT ANSWER -
Does Fabric support auto scaling? - CORRECT ANSWER - 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? - CORRECT ANSWER - The Pipeline Copy data tool
What tool is best for moving a large data set into another destination? - CORRECT
ANSWER - The Pipeline Copy Data tool
What should dimension tables store? - CORRECT ANSWER - All attributes that describe
a business entity
What should fact tables store? - CORRECT ANSWER - Observations/events of a business
entity
What are Type 1, 2, and 3 Dimension tables? - CORRECT ANSWER - 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 labeled as old.
What does this DAX measure do:
RANKX( ALL( 'Product'[Product Name] ), [Sales],, DESC, Skip ) - CORRECT
ANSWER - Ranks the product names by Sales, with the largest values getting the smallest
