Maintain a Data Analytics Solution

You are monitoring a semantic model in Microsoft Fabric that is experiencing performance degradation. You suspect that the storage engine is struggling with high-cardinality columns during Direct Lake queries. Which Dynamic Management View (DMV) should you query to identify the memory usage of specific columns in the model?

You are configuring a deployment pipeline in Microsoft Fabric to manage the lifecycle of a Lakehouse and several related reports. Which TWO actions can you perform using deployment pipelines to ensure consistency across environments?

Refer to the exhibit. You are reviewing the Git configuration for a Microsoft Fabric workspace. A developer reports that they cannot see their latest changes in the 'dev' branch within the workspace. Based on the exhibit, what is the most likely cause of this issue?

You need to perform maintenance on a shared Lakehouse in Microsoft Fabric. Before making schema changes, you want to identify which downstream reports and semantic models will be affected. Which tool should you use?

A large semantic model using Direct Lake mode is experiencing slow query performance. You want to optimize the model's maintenance and performance. Which THREE actions should you take?

Your organization is scaling its Microsoft Fabric implementation. You need to establish a maintenance plan for workspace administration. Which TWO practices should you implement to manage workspace security and lifecycle effectively?

You are maintaining a data analytics solution that requires Row-Level Security (RLS) on a semantic model. You need to ensure that the RLS rules continue to function correctly even when the model is switched to Direct Lake mode. What is a key requirement for maintaining RLS in this scenario?

You are using the Tabular Model Definition Language (TMDL) to maintain a complex semantic model in Microsoft Fabric. You need to make a bulk change to the descriptions of 50 different measures. What is the most efficient way to perform this maintenance task?

A Lakehouse in your Fabric environment has grown significantly over time, and you notice that query performance on the Delta tables is decreasing. You also want to minimize storage costs by removing older versions of data files that are no longer needed for 'Time Travel'. Which maintenance strategy should you implement?

You are managing a Microsoft Fabric workspace integrated with Azure DevOps. You have several developers working on the same Lakehouse and Semantic Model. Which TWO actions are required to successfully resolve a merge conflict when synchronizing changes from the remote repository to the workspace?

Refer to the exhibit. You receive this JSON response when checking the Git status of a Fabric workspace. What is the most appropriate next step to maintain the integrity of the Semantic Model named 'SalesModel'?

You plan to change the data type of a column in a gold-layer Lakehouse table. You need to use the 'Impact Analysis' feature to identify the potential consequences. Which THREE types of downstream items will be identified by this feature?

You need to update a sensitivity label for a high-priority dataset in a Microsoft Fabric workspace. You want the new label to automatically apply to all reports and dashboards that use this dataset. Which feature should you ensure is enabled?

A Microsoft Fabric capacity is frequently experiencing 'Interactive Delay' during peak hours. You need to implement maintenance strategies to mitigate this without increasing the SKU size. Which TWO strategies should you prioritize?

You are maintaining a Fabric workspace and need to grant a colleague the ability to commit changes to the Git repository but prevent them from deleting the workspace itself. Which workspace role should you assign?

You need to perform a 'Lineage View' audit in Microsoft Fabric. Which TWO types of information are specifically provided by the Lineage View to help you maintain the solution?

You are using the Microsoft Fabric deployment pipeline. You have successfully deployed a semantic model from Development to Test. You now realize that you need to change the 'Data Source' rule for the Test stage. What will happen to the existing items in the Test stage if you update the rule?

You manage a Microsoft Fabric workspace containing a Lakehouse and several semantic models. You need to implement a data lineage solution that traces data transformations from the original source files ingested into the OneLake landing zone down to the Power BI reports consumed by business users. Which Fabric feature should you use to achieve this requirement natively?

You are auditing security in a Fabric workspace. You need to identify which two actions are required to ensure that a user can view a report without having access to the underlying Lakehouse files. Which two actions should you perform?

Refer to the exhibit. You are reviewing an organization's Fabric security policy. Based on the provided JSON snippet, what is the impact of this policy on your data analytics solution?

You need to monitor the performance of your Fabric SQL endpoint. Which two metrics should you track to ensure long-running queries are identified and optimized?

You need to automate the deployment of Fabric items across Development, Test, and Production environments. Which tool is the standard for managing these lifecycle stages?

Refer to the exhibit. A notebook in your Fabric workspace is failing with the provided error. What is the most likely cause?

You are optimizing a Lakehouse for performance. Which three actions help improve the query performance for users accessing the SQL endpoint?

You have a Fabric workspace with multiple reports. You need to ensure that the dataset is shared across reports without creating multiple copies. What is the correct approach?

Refer to the exhibit. An engineer receives this JSON response when checking the status of a Fabric workspace. What is the most appropriate next step to resolve the 'SyncingError' while ensuring that the workspace and the remote repository are aligned?

You plan to rename a column in a gold-layer table within a Fabric Lakehouse. Which THREE actions should you perform to assess and mitigate the impact on the existing analytics solution? (Select THREE)