DP-600 EXAM QUESTIONS & ANSWERS
What are the two types of Fabric licenses? - Answer -Per user licenses and Capacity
licenses.
What are the SKUs for Fabric (capacity licensing)? - 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? - 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. - Answer -F64
What are the three types of individual licenses? - 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? - 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." - Answer -
Does Fabric support auto scaling? - 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? - Answer -The Pipeline Copy data tool
What tool is best for moving a large data set into another destination? - Answer -The
Pipeline Copy Data tool
, What should dimension tables store? - Answer -All attributes that describe a business
entity
What should fact tables store? - Answer -Observations/events of a business entity
What are Type 1, 2, and 3 Dimension tables? - 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 ) - Answer -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, after a tie, is the
rank values of the tie plus the count of tied values.
What is the column quality feature in Power Query? - Answer -A feature that shows the
percentage of valid records in the column
What is the column profile feature in Power Query? - Answer -Column profile provides
statistical data about values in a column
What is the column distribution in Power Query? - Answer -Column distribution
provides an overview of the value frequency and distribution in a column
How would you identify individual values that are null in a dataframe? - Answer -Use
the .isnull() method on the dataframe
What is the difference between the DENSE_RANK() and the RANK() T-SQL functions?
- Answer -The DENSE_RANK function returns the rank of each row within the result set
partition, with no gaps in the ranking values. The RANK() function includes gaps in the
ranking.
What does the LAG() function do in SQL, what are its parameters, and which ones are
optional? - Answer -LAG() is a window function that provides access to a row at a
specified physical offset which comes before the current row.
1. Value to be returned. This can be a column or calculation.
2. Offset which specifies the number of rows before the current row from which to return
the value.
3. Default value to be returned if the offset goes beyond the scope of the window (if not
specified, it defaults to NULL).
What are the two types of Fabric licenses? - Answer -Per user licenses and Capacity
licenses.
What are the SKUs for Fabric (capacity licensing)? - 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? - 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. - Answer -F64
What are the three types of individual licenses? - 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? - 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." - Answer -
Does Fabric support auto scaling? - 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? - Answer -The Pipeline Copy data tool
What tool is best for moving a large data set into another destination? - Answer -The
Pipeline Copy Data tool
, What should dimension tables store? - Answer -All attributes that describe a business
entity
What should fact tables store? - Answer -Observations/events of a business entity
What are Type 1, 2, and 3 Dimension tables? - 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 ) - Answer -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, after a tie, is the
rank values of the tie plus the count of tied values.
What is the column quality feature in Power Query? - Answer -A feature that shows the
percentage of valid records in the column
What is the column profile feature in Power Query? - Answer -Column profile provides
statistical data about values in a column
What is the column distribution in Power Query? - Answer -Column distribution
provides an overview of the value frequency and distribution in a column
How would you identify individual values that are null in a dataframe? - Answer -Use
the .isnull() method on the dataframe
What is the difference between the DENSE_RANK() and the RANK() T-SQL functions?
- Answer -The DENSE_RANK function returns the rank of each row within the result set
partition, with no gaps in the ranking values. The RANK() function includes gaps in the
ranking.
What does the LAG() function do in SQL, what are its parameters, and which ones are
optional? - Answer -LAG() is a window function that provides access to a row at a
specified physical offset which comes before the current row.
1. Value to be returned. This can be a column or calculation.
2. Offset which specifies the number of rows before the current row from which to return
the value.
3. Default value to be returned if the offset goes beyond the scope of the window (if not
specified, it defaults to NULL).
