DP-600 Implement and Manage Semantic Models Practice Test 2 — 15 Questions

Question 1

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

Choose an answer to begin — your selection is scored in the full session.

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 2

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 3

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 4

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 5

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.

Question 6

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?

Accepted Answer

Partitions in Direct Lake are automatically synced with Delta table partitions.. Partitioning is a core strategy for managing large datasets. In Direct Lake, the relationship between partitions and the underlying OneLake Parquet files is more direct. Understanding how the engine maps these partitions to storage is vital for ensuring that only the necessary data is loaded into memory during query execution.

Answer

Direct Lake partitions must be manually mapped to specific Parquet file paths.

Answer

Direct Lake does not support partitioning and relies only on V-Order.

Answer

Direct Lake partitions require a SQL gateway to access historical data.

Question 7

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?

Accepted Answer

Incremental refresh with the 'Get the latest data in real time' option.. Hybrid tables combine the performance of Import mode for historical data with the real-time capabilities of DirectQuery for current data. This is achieved through Incremental Refresh settings, where a specific partition is designated to be queried directly from the source, providing a balance between speed and data freshness.

Answer

Calculation Groups with a 'Real-time' item.

Answer

Direct Lake fallback settings.

Answer

Dual storage mode on the fact table.

Question 8

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?

Accepted Answer

The XMLA endpoint for the workspace.. The XMLA endpoint is a connection string that allows external tools like Tabular Editor, SQL Server Management Studio, and DAX Studio to interact with semantic models in a workspace. This is a fundamental requirement for advanced model management, ALM, and performance tuning in Microsoft Fabric and Power BI Premium.

Answer

The OData URL for the Fabric Lakehouse.

Answer

The connection string for the SQL Analytics Endpoint.

Answer

The unique identifier for a specific semantic model.

Question 9

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

Accepted Answer

Data source connection strings.. Deployment pipelines automate the movement of content between environments. Deployment rules are used to update specific properties of a semantic model so that it functions correctly in the target environment. This prevents engineers from having to manually edit the model after it has been deployed to a higher environment.

Answer

The DAX logic of calculated columns.

Answer

The Row-Level Security (RLS) role membership.

Answer

The visual layout of report pages.

Question 10

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?

Accepted Answer

A 'Limited' relationship will be created between the remote and local sources.. Composite models allow for a high degree of flexibility by combining enterprise datasets with local data. However, this creates a 'chained' dependency. Understanding how this impact performance and the requirement for 'Dual' storage mode on certain tables to prevent weak relationships is a key skill for Fabric analytics engineers.

Answer

The local Excel table must be uploaded to OneLake first.

Answer

The source semantic model must have the XMLA Read/Write property enabled.

Answer

The entire model will automatically fall back to Direct Lake mode.

Question 11

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?

Accepted Answer

Trigger a 'Refresh' of the semantic model in the Fabric portal.. One of the major benefits of Direct Lake is the lack of a traditional refresh. However, the model must still be made aware of changes to the Delta log. Understanding the 'Refresh' button's behavior in the context of Direct Lake—which updates the metadata rather than reloading data—is crucial for maintaining accurate reports.

Answer

Run a full process operation via the XMLA endpoint.

Answer

Re-publish the .pbix file from Power BI Desktop.

Answer

Restart the Fabric Capacity to clear the cache.

Question 12

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?

Accepted Answer

Using complex conditional logic like IF or SWITCH across multiple columns.. DAX optimization involves ensuring as much work as possible is done by the Storage Engine (VertiPaq), which is highly parallelized. The Formula Engine is single-threaded and slower. Identifying 'callback' triggers or complex logic that forces the Formula Engine to take over is a high-level skill for optimizing large-scale semantic models.

Answer

Using the RELATED function to fetch a value from a dimension.

Answer

Applying a simple filter using the CALCULATE function.

Answer

Using a star schema with 1:Many relationships.

Question 13

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?

Accepted Answer

Restrict relationship cross-filter direction to 'Single' where possible.. Reducing bidirectional cross-filtering is critical for performance because it limits the number of join paths the engine evaluates during query execution. In DirectQuery, complex relationships lead to expensive SQL queries being generated. By enforcing single-direction filters, you restrict the scope of query generation, significantly decreasing load times. This practice is essential for scaling enterprise models where data volume and complexity could otherwise lead to timeout errors or degraded user experiences.

Answer

Enable 'Assume referential integrity' for all relationships in the model.

Answer

Convert all relationships to use bidirectional cross-filtering to ensure data consistency.

Answer

Increase the 'Query Reduction' setting to disable auto-exist for all columns.

Question 14

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?

Accepted Answer

Define roles and filter expressions in Power BI Desktop.. Implementing RLS requires both the definition of roles within the model and the assignment of users to those roles in the workspace. The security model relies on DAX filter expressions to restrict data access dynamically. Validating these roles via the 'Test as role' feature ensures that the logic correctly isolates data, which is a mandatory verification step before publishing the model to production to prevent accidental data leaks.

Answer

Create separate reports for each regional manager to ensure data isolation.

Answer

Enable 'View as role' for all workspace members automatically.

Answer

Apply object-level security (OLS) to all columns containing sensitive data.

Question 15

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?

Accepted Answer

The display format will change based on the filtered country context.. The dynamic format string evaluates the DAX expression for every data point displayed in the visual. By checking the country context, the engine applies either the USD or EUR format string dynamically. This feature is vital for global reports, as it allows a single measure to adapt its visual representation based on user context, improving clarity and usability without creating separate measures for each currency type.

Answer

The report will fail to render because the JSON policy is invalid.

Answer

The column will display only the US format string for all rows.

Answer

The report will ignore the policy and use the default model format.