DP-600 Implement and Manage Semantic Models — All Questions With Answers

Question 1mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are designing a semantic model in Microsoft Fabric that will use Direct Lake mode. The underlying data is stored in a Lakehouse as Delta tables. You need to ensure the highest performance for report queries while maintaining the model in Direct Lake mode. Which data modeling strategy should you prioritize to achieve this goal?

Question 2hardmulti select

Read the full Implement and Manage Semantic Models explanation →

You are creating a semantic model that requires complex time-intelligence logic and the ability for users to switch between different currencies. You decide to use calculation groups. Which TWO of the following are true regarding the implementation and behavior of calculation groups in Microsoft Fabric semantic models?

Question 3mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

Refer to the exhibit. You are using the Tabular Model Scripting Language (TMSL) to manage a semantic model in a Fabric workspace. What will be the result of executing this command via the XMLA endpoint?

Exhibit

{
  "refresh": {
    "type": "full",
    "objects": [
      {
        "database": "SalesModel",
        "table": "Orders",
        "partition": "Orders_2023"
      }
    ]
  }
}

Question 4mediummulti select

Read the full Implement and Manage Semantic Models explanation →

You are configuring incremental refresh for a large fact table in a Microsoft Fabric semantic model. Which THREE parameters or settings must be correctly configured to ensure incremental refresh works as expected?

Question 5easymultiple choice

Read the full Implement and Manage Semantic Models explanation →

You need to provide report users with the ability to dynamically change the measure displayed in a bar chart (e.g., switching between 'Total Sales' and 'Total Profit'). Which feature in a Microsoft Fabric semantic model should you use to implement this with minimal effort?

Question 6hardmultiple choice

Read the full Implement and Manage Semantic Models explanation →

Refer to the exhibit. You are using the DAX Query View in Power BI Desktop to troubleshoot a performance issue. What is the primary purpose of the 'EVALUATE' statement in this context?

Exhibit

DEFINE
  VAR MonthlySales = 
    SUMMARIZECOLUMNS(
      'Date'[Month],
      "Sales", [Total Sales]
    )
EVALUATE
  MonthlySales
ORDER BY
  'Date'[Month]

Question 7mediummulti select

Read the full Implement and Manage Semantic Models explanation →

You are optimizing a semantic model that has a large number of tables and complex relationships. Which TWO practices should you follow to improve both performance and usability?

Question 8mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

Your organization has a strict data privacy policy that requires certain columns, such as 'Social Security Number', to be completely invisible to unauthorized users, even if they have access to the rest of the semantic model. Which feature should you implement?

Question 9hardmulti select

Read the full Implement and Manage Semantic Models explanation →

You are managing a very large semantic model in Microsoft Fabric that exceeds 10 GB in size. You need to ensure that the model can be published and refreshed efficiently. Which TWO configurations are most important for managing large models?

Question 10mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are building a composite model in Microsoft Fabric. You have an existing 'Corporate Sales' semantic model published in the service, and you need to combine it with a local Excel file containing 'Target' data. What is a key consideration when using DirectQuery for Power BI semantic models in this scenario?

Question 11hardmultiple choice

Read the full Implement and Manage Semantic Models explanation →

You have a semantic model with a 'Sales' table and a 'Date' table. There are two relationships between them: one based on 'OrderDate' (active) and one based on 'ShipDate' (inactive). You need to create a measure that calculates the 'Total Shipped Amount'. Which DAX function is required to use the inactive relationship?

Question 12mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are using Git integration in Microsoft Fabric to manage your semantic model's version control. You have made changes to the model's metadata in the workspace. How do you ensure these changes are reflected in your remote Azure DevOps repository?

Question 13easymultiple choice

Read the full Implement and Manage Semantic Models explanation →

You want to improve the discoverability of measures in a semantic model that contains over 50 different calculations. You decide to organize them into logical groups like 'Sales Metrics' and 'Profit Metrics'. Which property should you configure for these measures?

Question 14mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

A Microsoft Fabric tenant contains a massive Delta table in OneLake. You create a semantic model using Direct Lake mode to maximize performance. However, you notice that some queries are falling back to DirectQuery mode, significantly increasing latency. What is the most likely cause of this fallback behavior?

Question 15hardmultiple choice

Read the full Implement and Manage Semantic Models explanation →

Refer to the exhibit. You are using the XMLA endpoint to manage a large semantic model in a Microsoft Fabric Premium workspace. You execute the TMSL script provided in the exhibit. What is the specific outcome of this operation?

Exhibit

{
  "refresh": {
    "type": "full",
    "objects": [
      {
        "database": "SalesModel",
        "table": "Orders",
        "partition": "Orders_2023"
      }
    ]
  }
}

Question 16mediummulti select

Read the full Implement and Manage Semantic Models explanation →

You are optimizing a complex semantic model in Microsoft Fabric that contains multiple many-to-many relationships and complex DAX measures. Which TWO tools should you use to identify performance bottlenecks in the query execution and the VertiPaq engine? (Choose two.)

Question 17hardmulti select

Read the full Implement and Manage Semantic Models explanation →

You are managing a semantic model in a Microsoft Fabric workspace. You need to automate the deployment of changes from development to production using the Power BI REST API. Which THREE actions are supported through the API for managing semantic models? (Choose three.)

Question 18mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

Your organization uses a star schema for its semantic models. You have a requirement to ensure that users can only see the 'Unit Cost' column if they belong to the 'Finance' security group. Users not in this group should still see the rest of the 'Products' table. Which feature should you implement?

Question 19mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are developing a semantic model in Microsoft Fabric. To improve the maintainability of time-based calculations like Year-to-Date (YTD) and Previous Year (PY) for multiple measures, you decide to use Calculation Groups. Which tool must you use to create and manage these groups?

Question 20mediummulti select

Read the full Implement and Manage Semantic Models explanation →

You are designing a high-performance semantic model in Fabric. Which TWO practices should you follow to ensure the model remains optimized for the VertiPaq engine? (Choose two.)

Question 21hardmultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are implementing a large-scale semantic model using Direct Lake. You have a requirement to support a billion-row table while ensuring that historical data is not re-processed every day. You decide to use partitioning. How does partitioning in a Direct Lake model differ from an Import model?

Question 22mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You have a semantic model that uses a large fact table. You want to implement a hybrid table approach where the most recent data is available in real-time via DirectQuery, while historical data is stored in Import mode for performance. Which feature must you configure to enable this?

Question 23easymultiple choice

Read the full Implement and Manage Semantic Models explanation →

Refer to the exhibit. An analytics engineer needs to connect an external tool to a Microsoft Fabric workspace to manage semantic models. What does the string in the exhibit represent?

Exhibit

powerbi://api.powerbi.com/v1.0/myorg/Finance_Workspace

Question 24mediummulti select

Read the full Implement and Manage Semantic Models explanation →

You are setting up a deployment pipeline in Microsoft Fabric to move a semantic model from the Development workspace to the Test workspace. Which TWO settings are typically managed using deployment rules during this process? (Choose two.)

Question 25mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are creating a composite model that connects to an existing Power BI semantic model in a different workspace. You need to add a local Excel table to this model to perform 'what-if' analysis. What is a primary consideration when using this 'DirectQuery for Power BI datasets' approach?

Question 26mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are managing a semantic model in Direct Lake mode. You have made significant updates to the underlying Delta table using a Spark notebook, including adding new columns and deleting old records. What must you do to ensure the semantic model reflects these changes?

Question 27hardmultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are troubleshooting a performance issue where a specific DAX measure is taking several seconds to calculate. You suspect that the 'Formula Engine' is being overloaded because the calculation cannot be pushed down to the 'Storage Engine'. Which DAX behavior most commonly causes this?

Question 28mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are optimizing a large DirectQuery semantic model in Microsoft Fabric. You observe high latency during report interactions due to excessive cross-filtering. Which action should you take to minimize the performance impact while maintaining model integrity?

Question 29hardmulti select

Read the full Implement and Manage Semantic Models explanation →

You are managing a Power BI semantic model and need to implement row-level security (RLS) for a global sales team. Which TWO actions must you perform to ensure the security policies are correctly applied and validated?

Question 30mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

Refer to the exhibit. You are configuring dynamic format strings for a currency column. Based on the provided JSON policy configuration, which outcome will occur when a user views the report?

Exhibit

{
  "policy": "dynamic_format_strings",
  "enabled": true,
  "expression": "IF([Country] = 'US', '$#,##0', '€#,##0')"
}

Question 31hardmultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are optimizing a Power BI semantic model that uses Incremental Refresh. You need to ensure that historical data is not reloaded during every refresh cycle. Which configuration is required to achieve this efficiently?

Question 32mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

Your organization requires that users only see data from their own department. You decide to use a static Row-Level Security (RLS) role. How should you identify the users for these roles to ensure the security model is scalable?

Question 33mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You need to enable Q&A for a semantic model. Which step is essential to ensure that the natural language engine correctly identifies relationships between tables?

Question 34hardmultiple choice

Read the full Implement and Manage Semantic Models explanation →

Refer to the exhibit. You are writing a DAX measure that compares a Sales ID from a fact table to a numeric ID in a dimension table. Which action will resolve this error?

Exhibit

Error: DAX comparison operations do not support comparing values of type 'Text' with type 'Integer'.

Question 35mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are creating a report for an international company and need to implement field parameters. What is the primary benefit of using this feature for your users?

Question 36hardmultiple choice

Read the full Implement and Manage Semantic Models explanation →

You have a large DirectQuery semantic model and want to implement aggregation tables to improve performance. What is a requirement for the aggregation table to be used by the engine?

Question 37mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are managing a semantic model where users need to perform calculations based on a dynamic time period. Which DAX function should you use to create a time-intelligence calculation that respects the current filter context?

Question 38mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are designing a semantic model with a complex date requirement. You need to ensure that the model supports multiple relationships between the 'Sales' fact table and the 'Date' dimension (e.g., Order Date, Ship Date). What is the recommended strategy?

Question 39mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You have a semantic model in Fabric. You need to enable automatic updates to the schema when the underlying data source changes. Which feature should you implement?

Question 40mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

A large retail company uses Microsoft Fabric and wants to minimize data latency for their executive dashboard. The data resides in Delta tables within a Fabric Lakehouse. You need to choose a storage mode for the semantic model that provides the best performance without requiring data movement or refresh operations. Which mode should you implement?

Question 41easymultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are designing a semantic model for a sales department. The source data contains a Sales table with ten million rows and a Product table with five thousand rows. To optimize the model for performance and ease of use, you need to establish a relationship between these tables. Which relationship configuration is the best practice for this star schema?

Question 42mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

A developer is writing a DAX measure to calculate total sales for the previous fiscal year. The measure must ignore any user-applied filters on the 'Date' table while keeping filters on other tables like 'Region'. Which DAX function is most appropriate for modifying the filter context in this specific way within a CALCULATE statement?

Question 43mediummulti select

Read the full Implement and Manage Semantic Models explanation →

You are implementing security for a Microsoft Fabric semantic model. You need to ensure that regional managers can only see data for their own regions. Which TWO steps must you perform to successfully implement and validate Dynamic Row-Level Security (RLS)?

Question 44hardmultiple choice

Read the full Implement and Manage Semantic Models explanation →

Refer to the exhibit. You are using the XMLA endpoint to manage a semantic model in a Fabric workspace. A developer executes the Tabular Model Scripting Language (TMSL) command shown. What is the result of this operation?

Exhibit

{
  "refresh": {
    "type": "full",
    "objects": [
      {
        "database": "SalesModel",
        "table": "Transactions",
        "partition": "2023_Q4"
      }
    ]
  }
}

Question 45mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

Your team needs to create a semantic model that supports multiple currencies. Instead of creating individual measures for 'Total Sales USD', 'Total Sales EUR', and 'Total Sales GBP', you want to implement a single 'Total Sales' measure that changes its calculation based on a user's selection. Which feature should you use?

Question 46hardmulti select

Read the full Implement and Manage Semantic Models explanation →

A semantic model in a Fabric Premium workspace is exceeding the memory limits during refresh. The model is currently 15 GB. You need to optimize the storage and memory footprint of this model. Which TWO actions should you take?

Question 47mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You have a Direct Lake semantic model connected to a Fabric Lakehouse. During a peak usage period, the model exceeds the memory limits of the Fabric capacity. What will be the behavior of the semantic model in this situation?

Question 48hardmulti select

Read the full Implement and Manage Semantic Models explanation →

You are optimizing a slow-performing DAX measure: [Total Profit] = SUMX(Sales, Sales[Quantity] * RELATED(Product[UnitPrice])). The Sales table has 50 million rows. Which THREE actions are recommended to improve the performance of the semantic model and this measure?

Question 49mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

Refer to the exhibit. You are using the Power BI REST API to update the settings of a semantic model in a Fabric workspace. What is the primary purpose of setting the 'targetStorageMode' to 'PremiumFiles'?

Exhibit

PATCH https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}
{
  "targetStorageMode": "PremiumFiles"
}

Question 50easymultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are building a semantic model and notice that the 'Order' table and the 'Customer' table both have a 'CustomerID' column. You create a relationship between them. By default, what is the cardinality and the most likely direction of the filter in this relationship?

Question 51mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are managing a Direct Lake semantic model and want to improve performance for users who frequently query the same high-level summaries. You decide to use User-Defined Aggregations. Where must the aggregation tables be stored for a Direct Lake model to function correctly?

Question 52mediummulti select

Read the full Implement and Manage Semantic Models explanation →

You are using the Tabular Object Model (TOM) and the XMLA endpoint to automate the management of semantic models. You need to update the descriptions of several measures to improve data discovery. Which TWO tools or methods can you use to connect to the XMLA endpoint and modify these properties?

Question 53hardmultiple choice

Read the full Implement and Manage Semantic Models explanation →

A company has a massive Fact table with 5 years of historical data. They require real-time reporting for the current day's data, but the historical data only needs to be updated once a day. You want to implement a 'Hybrid Table' to meet this requirement. How does a Hybrid Table handle this scenario?

Question 54mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are developing a Power BI semantic model in Microsoft Fabric. You need to implement row-level security (RLS) to ensure that users in the 'Sales' department can only view data corresponding to their assigned region. Which feature should you use to define these security rules within the semantic model?

Question 1mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are designing a semantic model in Microsoft Fabric that will use Direct Lake mode. The underlying data is stored in a Lakehouse as Delta tables. You need to ensure the highest performance for report queries while maintaining the model in Direct Lake mode. Which data modeling strategy should you prioritize to achieve this goal?

Question 2hardmulti select

Read the full Implement and Manage Semantic Models explanation →

You are creating a semantic model that requires complex time-intelligence logic and the ability for users to switch between different currencies. You decide to use calculation groups. Which TWO of the following are true regarding the implementation and behavior of calculation groups in Microsoft Fabric semantic models?

Question 3mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

Refer to the exhibit. You are using the Tabular Model Scripting Language (TMSL) to manage a semantic model in a Fabric workspace. What will be the result of executing this command via the XMLA endpoint?

Exhibit

{
  "refresh": {
    "type": "full",
    "objects": [
      {
        "database": "SalesModel",
        "table": "Orders",
        "partition": "Orders_2023"
      }
    ]
  }
}

Question 4mediummulti select

Read the full Implement and Manage Semantic Models explanation →

You are configuring incremental refresh for a large fact table in a Microsoft Fabric semantic model. Which THREE parameters or settings must be correctly configured to ensure incremental refresh works as expected?

Question 5easymultiple choice

Read the full Implement and Manage Semantic Models explanation →

You need to provide report users with the ability to dynamically change the measure displayed in a bar chart (e.g., switching between 'Total Sales' and 'Total Profit'). Which feature in a Microsoft Fabric semantic model should you use to implement this with minimal effort?

Question 6hardmultiple choice

Read the full Implement and Manage Semantic Models explanation →

Refer to the exhibit. You are using the DAX Query View in Power BI Desktop to troubleshoot a performance issue. What is the primary purpose of the 'EVALUATE' statement in this context?

Exhibit

DEFINE
  VAR MonthlySales = 
    SUMMARIZECOLUMNS(
      'Date'[Month],
      "Sales", [Total Sales]
    )
EVALUATE
  MonthlySales
ORDER BY
  'Date'[Month]

Question 7mediummulti select

Read the full Implement and Manage Semantic Models explanation →

You are optimizing a semantic model that has a large number of tables and complex relationships. Which TWO practices should you follow to improve both performance and usability?

Question 8mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

Your organization has a strict data privacy policy that requires certain columns, such as 'Social Security Number', to be completely invisible to unauthorized users, even if they have access to the rest of the semantic model. Which feature should you implement?

Question 9hardmulti select

Read the full Implement and Manage Semantic Models explanation →

You are managing a very large semantic model in Microsoft Fabric that exceeds 10 GB in size. You need to ensure that the model can be published and refreshed efficiently. Which TWO configurations are most important for managing large models?

Question 10mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are building a composite model in Microsoft Fabric. You have an existing 'Corporate Sales' semantic model published in the service, and you need to combine it with a local Excel file containing 'Target' data. What is a key consideration when using DirectQuery for Power BI semantic models in this scenario?

Question 11hardmultiple choice

Read the full Implement and Manage Semantic Models explanation →

You have a semantic model with a 'Sales' table and a 'Date' table. There are two relationships between them: one based on 'OrderDate' (active) and one based on 'ShipDate' (inactive). You need to create a measure that calculates the 'Total Shipped Amount'. Which DAX function is required to use the inactive relationship?

Question 12mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are using Git integration in Microsoft Fabric to manage your semantic model's version control. You have made changes to the model's metadata in the workspace. How do you ensure these changes are reflected in your remote Azure DevOps repository?

Question 13easymultiple choice

Read the full Implement and Manage Semantic Models explanation →

You want to improve the discoverability of measures in a semantic model that contains over 50 different calculations. You decide to organize them into logical groups like 'Sales Metrics' and 'Profit Metrics'. Which property should you configure for these measures?

Question 14mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

A Microsoft Fabric tenant contains a massive Delta table in OneLake. You create a semantic model using Direct Lake mode to maximize performance. However, you notice that some queries are falling back to DirectQuery mode, significantly increasing latency. What is the most likely cause of this fallback behavior?

Question 15hardmultiple choice

Read the full Implement and Manage Semantic Models explanation →

Refer to the exhibit. You are using the XMLA endpoint to manage a large semantic model in a Microsoft Fabric Premium workspace. You execute the TMSL script provided in the exhibit. What is the specific outcome of this operation?

Exhibit

{
  "refresh": {
    "type": "full",
    "objects": [
      {
        "database": "SalesModel",
        "table": "Orders",
        "partition": "Orders_2023"
      }
    ]
  }
}

Question 16mediummulti select

Read the full Implement and Manage Semantic Models explanation →

You are optimizing a complex semantic model in Microsoft Fabric that contains multiple many-to-many relationships and complex DAX measures. Which TWO tools should you use to identify performance bottlenecks in the query execution and the VertiPaq engine? (Choose two.)

Question 17hardmulti select

Read the full Implement and Manage Semantic Models explanation →

You are managing a semantic model in a Microsoft Fabric workspace. You need to automate the deployment of changes from development to production using the Power BI REST API. Which THREE actions are supported through the API for managing semantic models? (Choose three.)

Question 18mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

Your organization uses a star schema for its semantic models. You have a requirement to ensure that users can only see the 'Unit Cost' column if they belong to the 'Finance' security group. Users not in this group should still see the rest of the 'Products' table. Which feature should you implement?

Question 19mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are developing a semantic model in Microsoft Fabric. To improve the maintainability of time-based calculations like Year-to-Date (YTD) and Previous Year (PY) for multiple measures, you decide to use Calculation Groups. Which tool must you use to create and manage these groups?

Question 20mediummulti select

Read the full Implement and Manage Semantic Models explanation →

You are designing a high-performance semantic model in Fabric. Which TWO practices should you follow to ensure the model remains optimized for the VertiPaq engine? (Choose two.)

Question 21hardmultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are implementing a large-scale semantic model using Direct Lake. You have a requirement to support a billion-row table while ensuring that historical data is not re-processed every day. You decide to use partitioning. How does partitioning in a Direct Lake model differ from an Import model?

Question 22mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You have a semantic model that uses a large fact table. You want to implement a hybrid table approach where the most recent data is available in real-time via DirectQuery, while historical data is stored in Import mode for performance. Which feature must you configure to enable this?

Question 23easymultiple choice

Read the full Implement and Manage Semantic Models explanation →

Refer to the exhibit. An analytics engineer needs to connect an external tool to a Microsoft Fabric workspace to manage semantic models. What does the string in the exhibit represent?

Exhibit

powerbi://api.powerbi.com/v1.0/myorg/Finance_Workspace

Question 24mediummulti select

Read the full Implement and Manage Semantic Models explanation →

You are setting up a deployment pipeline in Microsoft Fabric to move a semantic model from the Development workspace to the Test workspace. Which TWO settings are typically managed using deployment rules during this process? (Choose two.)

Question 25mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are creating a composite model that connects to an existing Power BI semantic model in a different workspace. You need to add a local Excel table to this model to perform 'what-if' analysis. What is a primary consideration when using this 'DirectQuery for Power BI datasets' approach?

Question 26mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are managing a semantic model in Direct Lake mode. You have made significant updates to the underlying Delta table using a Spark notebook, including adding new columns and deleting old records. What must you do to ensure the semantic model reflects these changes?

Question 27hardmultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are troubleshooting a performance issue where a specific DAX measure is taking several seconds to calculate. You suspect that the 'Formula Engine' is being overloaded because the calculation cannot be pushed down to the 'Storage Engine'. Which DAX behavior most commonly causes this?

Question 28mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are optimizing a large DirectQuery semantic model in Microsoft Fabric. You observe high latency during report interactions due to excessive cross-filtering. Which action should you take to minimize the performance impact while maintaining model integrity?

Question 29hardmulti select

Read the full Implement and Manage Semantic Models explanation →

You are managing a Power BI semantic model and need to implement row-level security (RLS) for a global sales team. Which TWO actions must you perform to ensure the security policies are correctly applied and validated?

Question 30mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

Refer to the exhibit. You are configuring dynamic format strings for a currency column. Based on the provided JSON policy configuration, which outcome will occur when a user views the report?

Exhibit

{
  "policy": "dynamic_format_strings",
  "enabled": true,
  "expression": "IF([Country] = 'US', '$#,##0', '€#,##0')"
}

Question 31hardmultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are optimizing a Power BI semantic model that uses Incremental Refresh. You need to ensure that historical data is not reloaded during every refresh cycle. Which configuration is required to achieve this efficiently?

Question 32mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

Your organization requires that users only see data from their own department. You decide to use a static Row-Level Security (RLS) role. How should you identify the users for these roles to ensure the security model is scalable?

Question 33mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You need to enable Q&A for a semantic model. Which step is essential to ensure that the natural language engine correctly identifies relationships between tables?

Question 34hardmultiple choice

Read the full Implement and Manage Semantic Models explanation →

Refer to the exhibit. You are writing a DAX measure that compares a Sales ID from a fact table to a numeric ID in a dimension table. Which action will resolve this error?

Exhibit

Error: DAX comparison operations do not support comparing values of type 'Text' with type 'Integer'.

Question 35mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are creating a report for an international company and need to implement field parameters. What is the primary benefit of using this feature for your users?

Question 36hardmultiple choice

Read the full Implement and Manage Semantic Models explanation →

You have a large DirectQuery semantic model and want to implement aggregation tables to improve performance. What is a requirement for the aggregation table to be used by the engine?

Question 37mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are managing a semantic model where users need to perform calculations based on a dynamic time period. Which DAX function should you use to create a time-intelligence calculation that respects the current filter context?

Question 38mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are designing a semantic model with a complex date requirement. You need to ensure that the model supports multiple relationships between the 'Sales' fact table and the 'Date' dimension (e.g., Order Date, Ship Date). What is the recommended strategy?

Question 39mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You have a semantic model in Fabric. You need to enable automatic updates to the schema when the underlying data source changes. Which feature should you implement?

Question 40mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

A large retail company uses Microsoft Fabric and wants to minimize data latency for their executive dashboard. The data resides in Delta tables within a Fabric Lakehouse. You need to choose a storage mode for the semantic model that provides the best performance without requiring data movement or refresh operations. Which mode should you implement?

Question 41easymultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are designing a semantic model for a sales department. The source data contains a Sales table with ten million rows and a Product table with five thousand rows. To optimize the model for performance and ease of use, you need to establish a relationship between these tables. Which relationship configuration is the best practice for this star schema?

Question 42mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

A developer is writing a DAX measure to calculate total sales for the previous fiscal year. The measure must ignore any user-applied filters on the 'Date' table while keeping filters on other tables like 'Region'. Which DAX function is most appropriate for modifying the filter context in this specific way within a CALCULATE statement?

Question 43mediummulti select

Read the full Implement and Manage Semantic Models explanation →

You are implementing security for a Microsoft Fabric semantic model. You need to ensure that regional managers can only see data for their own regions. Which TWO steps must you perform to successfully implement and validate Dynamic Row-Level Security (RLS)?

Question 44hardmultiple choice

Read the full Implement and Manage Semantic Models explanation →

Refer to the exhibit. You are using the XMLA endpoint to manage a semantic model in a Fabric workspace. A developer executes the Tabular Model Scripting Language (TMSL) command shown. What is the result of this operation?

Exhibit

{
  "refresh": {
    "type": "full",
    "objects": [
      {
        "database": "SalesModel",
        "table": "Transactions",
        "partition": "2023_Q4"
      }
    ]
  }
}

Question 45mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

Your team needs to create a semantic model that supports multiple currencies. Instead of creating individual measures for 'Total Sales USD', 'Total Sales EUR', and 'Total Sales GBP', you want to implement a single 'Total Sales' measure that changes its calculation based on a user's selection. Which feature should you use?

Question 46hardmulti select

Read the full Implement and Manage Semantic Models explanation →

A semantic model in a Fabric Premium workspace is exceeding the memory limits during refresh. The model is currently 15 GB. You need to optimize the storage and memory footprint of this model. Which TWO actions should you take?

Question 47mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You have a Direct Lake semantic model connected to a Fabric Lakehouse. During a peak usage period, the model exceeds the memory limits of the Fabric capacity. What will be the behavior of the semantic model in this situation?

Question 48hardmulti select

Read the full Implement and Manage Semantic Models explanation →

You are optimizing a slow-performing DAX measure: [Total Profit] = SUMX(Sales, Sales[Quantity] * RELATED(Product[UnitPrice])). The Sales table has 50 million rows. Which THREE actions are recommended to improve the performance of the semantic model and this measure?

Question 49mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

Refer to the exhibit. You are using the Power BI REST API to update the settings of a semantic model in a Fabric workspace. What is the primary purpose of setting the 'targetStorageMode' to 'PremiumFiles'?

Exhibit

PATCH https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}
{
  "targetStorageMode": "PremiumFiles"
}

Question 50easymultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are building a semantic model and notice that the 'Order' table and the 'Customer' table both have a 'CustomerID' column. You create a relationship between them. By default, what is the cardinality and the most likely direction of the filter in this relationship?

Question 51mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are managing a Direct Lake semantic model and want to improve performance for users who frequently query the same high-level summaries. You decide to use User-Defined Aggregations. Where must the aggregation tables be stored for a Direct Lake model to function correctly?

Question 52mediummulti select

Read the full Implement and Manage Semantic Models explanation →

You are using the Tabular Object Model (TOM) and the XMLA endpoint to automate the management of semantic models. You need to update the descriptions of several measures to improve data discovery. Which TWO tools or methods can you use to connect to the XMLA endpoint and modify these properties?

Question 53hardmultiple choice

Read the full Implement and Manage Semantic Models explanation →

A company has a massive Fact table with 5 years of historical data. They require real-time reporting for the current day's data, but the historical data only needs to be updated once a day. You want to implement a 'Hybrid Table' to meet this requirement. How does a Hybrid Table handle this scenario?

Question 54mediummultiple choice

Read the full Implement and Manage Semantic Models explanation →

You are developing a Power BI semantic model in Microsoft Fabric. You need to implement row-level security (RLS) to ensure that users in the 'Sales' department can only view data corresponding to their assigned region. Which feature should you use to define these security rules within the semantic model?