DP-600 Implement and Manage Semantic Models — Timed 10 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?

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