DP-600 Implement and Manage Semantic Models — Timed 20 Questions

Question 1

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?

20 minute time limit — choose an answer to begin.

Accepted Answer

Organize the data into a star schema with clearly defined fact and dimension tables.. Direct Lake mode provides the performance of Import mode by loading Parquet files directly from OneLake into memory without duplicating data or requiring a refresh. To maintain this performance, models should adhere to a star schema. This reduces join complexity that the engine must resolve during query execution, ensuring the VertiPaq engine can efficiently scan and compress the data columns retrieved from the Delta tables.

Answer

Flatten all dimension and fact data into a single wide table to eliminate all joins.

Answer

Implement a snowflake schema to ensure that data normalization reduces the overall storage size.

Answer

Use many-to-many relationships between all tables to provide maximum flexibility for users.

Question 2

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?

Accepted Answer

You must define a precedence property for each calculation group to resolve calculation order.. Calculation groups allow you to significantly reduce the number of measures by defining reusable logic as calculation items. In Microsoft Fabric, they provide a powerful way to handle multiple transformations, such as YTD or Currency conversion, across various measures. However, they require careful configuration of precedence to resolve conflicts when multiple groups are applied to a single visual.

Answer

Calculation groups automatically enable the implicit measure feature for all columns in the model.

Answer

Calculation groups are only supported in models that use the DirectQuery storage mode.

Answer

Each calculation group can only contain a maximum of ten calculation items for performance reasons.

Question 3

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?

Accepted Answer

The 'Orders_2023' partition in the 'Orders' table will be fully processed and reloaded.. The exhibit shows a TMSL refresh command targeting a specific partition. By using the 'full' refresh type on a single partition object, the engine will clear the existing data for that specific partition and reload it from the source. This is a common administrative task for managing large datasets where only recent data needs to be updated.

Answer

The entire 'Orders' table will be refreshed, including all historical partitions.

Answer

The command will fail because TMSL is not supported for Microsoft Fabric semantic models.

Answer

Only the metadata for the 'Orders' table will be updated without reloading data.

Question 4

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?

Accepted Answer

RangeStart and RangeEnd parameters of type Date/Time.. Incremental refresh requires specific parameters and settings to define how data is partitioned and updated. The model needs RangeStart and RangeEnd parameters to filter the data source, a policy to define how much historical data to store, and a policy to define how much data to refresh in each cycle.

Answer

A calculated column that determines the age of each record in days.

Answer

The 'Enable DirectQuery' checkbox in the table properties.

Question 5

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?

Accepted Answer

Implement Field Parameters for the required measures.. Field parameters are a powerful feature that allows users to dynamically change the columns or measures being used in a visual. They create a special table in the model that contains references to other fields or measures, which can then be used as a slicer to control visual axes or values.

Answer

Create a separate visual for each measure and use bookmarks to switch between them.

Answer

Use the SWITCH function in a new DAX measure to select between the two calculations.

Answer

Configure a drill-through action that navigates to different pages based on the measure.

Question 6

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?

Accepted Answer

It executes the table expression and returns the result set for inspection.. In DAX Query View, the EVALUATE statement is the core command that tells the engine to execute a table expression and return the results. It is essential for testing DAX logic outside of a visual, allowing developers to see the raw table output generated by variables and summarize functions.

Answer

It defines a new calculated table that will be permanently added to the semantic model.

Answer

It triggers the creation of a relationship between the 'Date' and 'Sales' tables.

Answer

It calculates the total sum of the 'Sales' column for the entire model.

Question 7

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?

Accepted Answer

Hide foreign key columns in the fact tables from the report view.. Optimizing a semantic model involves both technical performance tuning and improving the end-user experience. Reducing the number of active relationships and hiding unnecessary fields are key steps in ensuring the model is both fast and easy to navigate for report authors.

Answer

Ensure that all relationships are set to 'Bi-directional' cross-filter direction.

Answer

Create multiple active relationships between two tables to provide different filter paths.

Answer

Always use 'Many-to-Many' relationships to avoid data quality errors.

Question 8

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?

Accepted Answer

Object-Level Security (OLS) via Tabular Editor.. Object-Level Security (OLS) allows you to secure specific tables or columns within a semantic model. Unlike RLS, which filters rows, OLS completely hides the metadata and data for the secured objects from unauthorized users, making it appear as if those columns do not exist at all.

Answer

Row-Level Security (RLS) with a filter on the sensitive column.

Answer

Sensitivity labels applied at the workspace level.

Answer

Workspace roles with 'Viewer' permissions only.

Question 9

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?

Accepted Answer

Enable 'Large dataset storage format' for the workspace or model.. Large semantic models require specific settings to handle memory and storage efficiently. The 'Large dataset storage format' ensures that the model can grow beyond the standard 10 GB limit, while the XMLA endpoint allows for granular management and partial refreshes of individual partitions.

Answer

Enable the 'Auto-scale' feature in the Lakehouse settings.

Answer

Convert all tables to use the 'Import' mode with 'Basic' compression.

Answer

Use the Power BI .PBIX file format for all deployments.

Question 10

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?

Accepted Answer

The 'DirectQuery for Power BI datasets and AS' feature must be enabled in Power BI Desktop.. When you connect to a published semantic model using DirectQuery, you are creating a 'Live Connection' that has been converted into a DirectQuery relationship. This allows you to add local data sources, but it introduces a dependency on the source model's availability and requires careful management of security and performance.

Answer

The local Excel file must be uploaded to OneLake before it can be used in a composite model.

Answer

You cannot use Row-Level Security (RLS) in a composite model that includes DirectQuery.

Answer

All tables from the 'Corporate Sales' model must be imported into the local model.

Question 11

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?

Accepted Answer

Use CALCULATE([Total Sales], USERELATIONSHIP('Sales'[ShipDate], 'Date'[Date])).. In DAX, you can only have one active relationship between two tables. To perform calculations using an alternative (inactive) relationship, you must use the USERELATIONSHIP function within a CALCULATE statement. This tells the engine to ignore the default active relationship for the duration of that specific calculation.

Answer

Use the RELATED() function to pull the 'ShipDate' into the 'Sales' table.

Answer

Use the TREATAS() function to map the 'ShipDate' to the 'Date' table.

Answer

Change the 'ShipDate' relationship to 'Bi-directional' in the Model View.

Question 12

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?

Accepted Answer

Open the Source Control pane in the workspace and click 'Commit'.. Fabric Git integration allows for a direct synchronization between the workspace and a Git provider. After making changes in the workspace, the 'Source Control' panel will show these as pending changes. You must manually commit and push these changes from the Fabric UI to the remote repository to synchronize them.

Answer

The changes are automatically synced to Azure DevOps in real-time.

Answer

You must download the .PBIX file and manually upload it to the Git repository.

Answer

Run a 'git push' command from a local terminal connected to the workspace URL.

Question 13

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?

Accepted Answer

Set the 'Display Folder' property for each measure in the Model View.. The 'Display Folder' property is a metadata setting used to organize columns and measures into folders within the Fields pane. This does not change the model's structure but significantly improves the user experience for report authors by grouping related items together in a searchable hierarchy.

Answer

Change the 'Data Category' of the measures to 'Group'.

Answer

Use the 'Group' feature in the Report View to cluster the measures.

Answer

Create a new table for each category and move the measures into them.

Question 14

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?

Accepted Answer

The semantic model includes Row-Level Security (RLS) filters.. Direct Lake mode is designed to read Parquet files directly from OneLake to provide Import-like performance without data duplication. However, certain configurations like Row-Level Security (RLS) defined within the semantic model can force a fallback to DirectQuery to ensure security logic is applied correctly at query time. Understanding these triggers is essential for optimizing high-scale Fabric architectures.

Answer

The Delta table has not been optimized using the V-Order algorithm.

Answer

The Delta table contains more than 100 columns.

Answer

The data is stored in a different workspace than the semantic model.

Question 15

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?

Accepted Answer

It performs a full data reload for only the specified partition of the Orders table.. Using the XMLA endpoint allows for granular management of semantic models, including the ability to refresh individual partitions rather than entire tables. This script targets a specific partition for a full refresh, which is a common task for managing large-scale models where processing the entire dataset would be inefficient and time-consuming for the capacity.

Answer

It deletes all data in the Orders table except for the 2023 partition.

Answer

It recalculates all measures in the model based on the 2023 data only.

Answer

It updates the metadata for the Orders table without loading any new data.

Question 16

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.)

Accepted Answer

DAX Studio. Optimizing semantic models requires specialized tools that can look inside the VertiPaq engine and capture DAX query traces. DAX Studio is the industry standard for performance tuning and metadata analysis, while SQL Server Profiler provides deep trace logs for Analysis Services engines, which back Power BI and Fabric semantic models. These tools are essential for associate engineers.

Answer

Power Query Editor

Answer

Azure Data Factory

Answer

Microsoft Purview

Question 17

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.)

Accepted Answer

Updating the credentials for a data source.. The Power BI REST API is critical for CI/CD and automation in Fabric. It allows engineers to programmatically handle tasks that would otherwise be manual. Understanding which administrative and lifecycle tasks can be automated helps in building robust, scalable analytics environments that adhere to enterprise DevOps practices and reduce manual errors during deployment.

Answer

Directly modifying the DAX formula of a measure.

Answer

Creating a new Row-Level Security role from a JSON file.

Question 18

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?

Accepted Answer

Object-Level Security (OLS) on the 'Unit Cost' column.. Object-Level Security (OLS) is more restrictive than Row-Level Security (RLS) because it completely hides the existence of metadata (columns or tables) from unauthorized users. This is critical for protecting sensitive data like costs or salaries without needing to split the data into multiple tables, thus maintaining the integrity of the star schema.

Answer

Row-Level Security (RLS) with a dynamic filter.

Answer

Calculation groups with a security measure.

Answer

A separate perspective for non-finance users.

Question 19

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?

Accepted Answer

Tabular Editor via the XMLA endpoint.. Calculation Groups are a powerful feature of the Tabular model that reduce measure proliferation. As of the current Fabric and Power BI releases, Calculation Groups cannot be created directly in the standard Power BI Desktop interface; they require the XMLA endpoint and external tools like Tabular Editor or the new DAX Query View in some contexts.

Answer

Power BI Desktop's standard Model view.

Answer

Microsoft Fabric Data Factory.

Answer

The Fabric Lakehouse Explorer.

Question 20

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.)

Accepted Answer

Use a star schema with clear fact and dimension tables.. The VertiPaq engine is a columnar storage engine that relies on high compression and efficient memory usage. To optimize it, engineers must focus on reducing the cardinality of columns and ensuring the schema follows a star pattern, which minimizes the complexity of the joins the engine must perform during query execution.

Answer

Include high-cardinality columns like GUIDs in the fact table.

Answer

Create many-to-many relationships for all dimensions.

Answer

Flatten all dimensions into a single large fact table.