troubleshooting

You are configuring a Spark pool in Microsoft Fabric for a workload with highly variable data volumes. You want to ensure that the pool can handle peak loads without over-provisioning resources during quiet periods. Which setting should you adjust?

When creating a Dataflow Gen2, what is the primary advantage of using a staging-enabled destination?

Refer to the exhibit. You are reviewing the JSON definition for a Spark Job Definition in Microsoft Fabric. The job is failing after exhausting all retries during periods of high capacity utilization. To ensure the job has a better chance of succeeding without increasing the maxRetryCount, which change should you implement in the job configuration?

Which Fabric tool would you use to perform a visual, low-code data transformation that directly results in a clean table in your Lakehouse?

Refer to the exhibit. A data engineer applies this configuration to a Microsoft Fabric notebook session. Which statement best describes the impact of this configuration on the analytics solution?

Which THREE features are provided by the Fabric Capacity Metrics app for monitoring performance?

You have a Power BI report connected to a Fabric Lakehouse using DirectLake mode. Users report that the data in the report is not reflecting the latest changes made to the Delta tables in the Lakehouse. What should you check first to resolve this?

You need to monitor the health and performance of your Microsoft Fabric environment. Which two components should you primarily monitor to identify bottlenecks in data movement?

A company is implementing a Data Mesh architecture using Microsoft Fabric. They want to delegate the management of the 'Finance' domain to a specific group of users. What is the minimum administrative requirement to allow these users to manage domain settings and assign workspaces without making them Fabric Administrators?

You are designing a data pipeline in Microsoft Fabric using Data Factory. You need to ingest data from an on-premises SQL Server database into a Lakehouse. Which integration component must be deployed to facilitate secure connectivity between the on-premises network and Microsoft Fabric?

You are monitoring a Fabric pipeline. You need to identify which activity failed within the pipeline execution. Which tool should you use?

You are configuring a Fabric pipeline to perform incremental loads from a source system. Which approach is considered the best practice to track changes efficiently?

You are using the Microsoft Fabric Capacity Metrics app and notice that your capacity is frequently hitting the limit for 'Interactive' operations. What should you do first?

You need to quickly identify all failed Data Factory pipeline runs and Spark jobs across multiple workspaces in your Microsoft Fabric environment. Which TWO actions should you perform in the Fabric Monitoring Hub?

You are implementing a security strategy for Microsoft Fabric. You need to ensure that data access is restricted based on sensitivity labels and that these labels persist when data is exported to Excel. Which TWO statements describe the behavior of sensitivity labels in Fabric? (Choose TWO)

You are managing a Microsoft Fabric capacity. You need to identify which users are consuming the most compute resources and determine if any throttled requests are occurring. Which TWO tools should you use?

You are managing a Microsoft Fabric workspace and notice that several notebooks are failing because they cannot find specific Python libraries. You want to ensure that every notebook in the workspace has access to the same version of these libraries without manual installation in each notebook. What should you do?

You have a large Delta table that is frequently queried. You notice that queries are slow due to small file overhead. Which command should you run to optimize this table?

You are building a pipeline and need to ensure that a downstream activity only runs if a previous activity succeeds. Which pipeline feature should you use?

You are configuring Git integration for a Microsoft Fabric workspace to enable source control for your team. Which TWO requirements must be met before you can successfully connect the workspace to an Azure DevOps repository?

You want to monitor the health and performance of your Microsoft Fabric pipelines. Which tool should you use to view detailed execution logs and identify bottlenecks in your data movement?

You are configuring a deployment pipeline to move a Lakehouse from a Test workspace to a Production workspace. Which THREE types of deployment rules can you apply to ensure the Lakehouse functions correctly in the Production environment?

Refer to the exhibit. The Spark job completed but took 45 minutes for a 100 million row dataset. The shuffle write size is significantly high. What should you investigate to improve performance?

Your organization is implementing a multi-stage development lifecycle in Microsoft Fabric. You need to ensure that when content moves from the 'Test' workspace to the 'Production' workspace, the data source connection automatically switches from the test SQL database to the production SQL database. Which feature should you configure?

Refer to the exhibit. A data engineer is troubleshooting a Spark job that frequently fails with 'Out of Memory' (OOM) errors despite the configuration shown. The job processes a 500GB dataset with many wide transformations. What is the most effective configuration change to resolve the OOM errors?

You need to perform a complex transformation that involves multiple joins across tables of varying sizes in Fabric. Which tool provides the best balance between performance and ease of use?

You are monitoring a Spark notebook in Microsoft Fabric that is taking longer than expected to process a large dataset. You notice that a single executor is processing significantly more data than others. Which tool or feature should you use to identify the specific partition causing this data skew?

You are monitoring a Microsoft Fabric Lakehouse. You notice that queries against a specific Delta table are performing slowly despite the table having a small data size. You need to identify the root cause of the performance degradation. What should you examine first?

Which tool in Fabric provides the most detailed view of the billable capacity usage for your tenant?

When ingesting data from an external source, what is the best practice for handling sensitive data?

You are optimizing a Fabric Warehouse for complex analytical queries involving large fact tables. Which TWO actions should you perform to improve query performance?

You are auditing data access in a Microsoft Fabric workspace and notice unexpected 'Access Denied' errors in the OneLake logs for a service principal that should have read-only access. The service principal has the 'Viewer' role in the workspace. What is the most likely cause?

What is the primary function of the 'Validate' activity in a Fabric pipeline?

You are building a data pipeline in Microsoft Fabric using a Copy Activity to ingest millions of small JSON files from an Azure Data Lake Storage Gen2 container into a Lakehouse table. The performance is significantly slower than expected due to high request latencies. Which optimization technique should you implement?

An organization wants to use Sensitivity Labels from Microsoft Purview to protect data in Microsoft Fabric. When a sensitivity label is applied to a Power BI report in a Fabric workspace, what is the default behavior regarding the protection of data exported from that report to an Excel file?

Which component in Microsoft Fabric is primarily designed for data integration and orchestration of complex workflows?

You are setting up a Microsoft Fabric environment for a development team. You want to use Git integration to allow developers to work in their own branches. Which THREE Fabric items are currently supported for Git integration?

You are implementing a security model where users should only see rows matching their assigned department. Which Fabric feature enables this?

You are implementing a multi-workspace architecture in Fabric. You need to enable a 'Managed Identity' for a specific Fabric workspace to allow it to securely access an Azure Data Lake Storage (ADLS) Gen2 account without managing service principal secrets. What is a key requirement for using Workspace Managed Identities in Fabric?

Which feature in Microsoft Fabric allows you to track the movement and transformation of data from source to destination?

Your team is using a Fabric Lakehouse to store Parquet files. You notice that the storage costs are increasing faster than expected, and there are many old versions of the data being retained. Which maintenance task should you schedule to optimize OneLake storage costs without affecting the current production data?

Refer to the exhibit. You have applied these Spark configurations to your Fabric environment. What is the primary benefit of this specific combination of settings when transforming data into Delta tables?

You are troubleshooting a slow-running Power BI report connected to a Fabric Semantic Model. What is the most effective way to identify the bottleneck?

Your organization uses Microsoft Fabric with three distinct workspaces for Development, Test, and Production. You need to automate the movement of a Lakehouse and its associated semantic model through these environments while ensuring that the Production environment uses a different data source connection string than the Development environment. Which feature should you implement?

You are managing a large-scale data ingestion pipeline that runs every hour. Recently, the pipeline has started to fail with 'Concurrency Limit Exceeded' errors. You have several other pipelines running in the same workspace. How should you optimize the environment to resolve this error?

You are configuring a Dataflow Gen2 to perform incremental updates for a large fact table. Which TWO steps are essential to ensure the dataflow only processes new or changed records during each run?

You are building a Medallion architecture in Fabric. You have ingested raw CSV files into the 'Files' section of your Bronze Lakehouse. You now need to transform this data and load it into a Delta table in the Silver Lakehouse. Which method provides the best performance and scalability for this transformation?

You are optimizing a Spark job in a Fabric notebook that joins a large fact table with a small dimension table. The join operation is causing high memory usage and slow performance. What technique should you implement?

Your organization wants to implement near real-time data ingestion from an Azure SQL Database into Fabric for reporting. You must minimize the impact on the source database's performance and avoid manual pipeline scheduling. Which solution should you implement?

Refer to the exhibit. You are reviewing pipeline logs and notice the 429 error. What is the most appropriate long-term action to prevent this?

Your organization requires that all data stored in the Fabric Lakehouse must be encrypted at rest using a customer-managed key (CMK). What is the mandatory step to achieve this?

You need to automate the ingestion of files from an Azure Blob Storage container into a Fabric Lakehouse. Which THREE components are required to build this automated pipeline? (Choose three)

You have a Fabric notebook that uses multiple Spark libraries. You notice that the startup time for your notebook is very slow. What is the best way to optimize this?

A company needs to implement a solution where data engineers can create and manage Lakehouses, but they should not be able to delete the workspace itself or modify the capacity settings. Which workspace role should be assigned to these engineers?

You are monitoring a Dataflow Gen2 refresh that is failing intermittently. You need to identify if the failure is caused by a data type mismatch or a timeout from the source system. Which TWO actions will help you find the specific error details? (Choose two.)

You are planning to use OneLake shortcuts to access data stored in an Azure Data Lake Storage (ADLS) Gen2 account. Which TWO authentication methods are supported by Microsoft Fabric for establishing this connection?

Refer to the exhibit. Your Fabric capacity is showing a status of 'Throttled' for background operations. Based on the JSON snippet from the capacity monitoring logs, what is the most likely consequence for a new Spark Notebook scheduled to run immediately?

You are optimizing a Fabric pipeline that processes data from a high-frequency sensor source. You notice significant data skew during the join operation. Which three strategies should you implement to mitigate this skew?

A data engineering team is using a service principal to automate the deployment and management of Fabric items via the REST API. Which THREE of the following actions must be completed to enable a service principal to work with Fabric APIs?

You are tasked with optimizing the performance of a Delta table in a Fabric Lakehouse that is queried frequently by both Spark notebooks and the SQL Analytics Endpoint. Which TWO techniques should you use to improve data skipping and read performance?

You are troubleshooting a slow-running SQL query in a Fabric Data Warehouse. The query plan shows a high cost associated with a 'Broadcast Nested Loop Join'. What should you do to optimize this?

Refer to the exhibit. Given the retry policy configuration, what happens if the source SQL database is temporarily unavailable during the first attempt?

A data engineer needs to share a workspace with a colleague who must be able to create, edit, and delete items like Lakehouses and Notebooks, but should not be allowed to modify workspace permissions or add new members. Which workspace role should be assigned?

You are tasked with optimizing a Fabric Lakehouse that contains billions of rows. You notice that queries against the SQL analytics endpoint are performing poorly. Which action will most effectively improve performance?

You have a Lakehouse with several Delta tables. You need to provide a SQL-based interface for data analysts to query this data using their existing SQL tools, but you want to ensure they do not accidentally modify the underlying files. What should you use?

Refer to the exhibit. You are reviewing the capacity state for a production Fabric environment. Based on the JSON output from the monitoring API, what is the most likely impact on users and what should be your immediate action?

You are building a Dataflow Gen2 to ingest a 50 GB CSV file from an Azure Storage account into a Fabric Lakehouse. You want to ensure the ingestion uses the 'Fast Copy' feature. What must you do?

You are configuring a new Microsoft Fabric tenant. You want to ensure that users can only create Fabric items if they are assigned to a specific security group. Where should you configure this restriction?

You notice that your Delta table is experiencing slow read performance due to file fragmentation. Which command should you run to optimize the physical storage layout?

You are optimizing a complex data pipeline in Microsoft Fabric that includes several Data Factory activities and Spark notebooks. You need to reduce the overall execution time and resource consumption. Which TWO actions should you take? (Choose two.)

When monitoring Fabric Data Pipelines, which TWO metrics are most useful for identifying performance issues in data copy activities?

You are ingesting thousands of small JSON files into a Fabric Lakehouse. You notice that query performance on the resulting Delta table is very poor. Which ingestion strategy should you implement to resolve the 'small files problem'?

You are using a Copy Activity in Microsoft Fabric Data Factory. You need to ensure that the data is encrypted both in transit and at rest. Which setting should you verify?

Which Fabric feature allows you to monitor the status and history of your data pipeline runs?

You are monitoring a Dataflow Gen2 refresh in Microsoft Fabric. The refresh fails with an error: 'Mashup Evaluation Error'. What is the most common cause of this error when working with large datasets in Dataflows?

You want to automate the monitoring of your Fabric Capacity and receive a notification on your mobile device whenever the capacity utilization exceeds 90% for more than 15 minutes. Which Microsoft Fabric feature should you use to implement this alert?

Your Fabric capacity is consistently reaching 100% utilization during the morning hours, causing background jobs to be delayed. You want to identify which specific items (e.g., specific Notebooks or Warehouses) are consuming the most Capacity Units (CUs). Which tool should you use?

You manage a Microsoft Fabric workspace containing a critical lakehouse and multiple downstream semantic models. You need to configure item-level permissions to ensure that specific business analysts can refresh the semantic models without being able to view or query the underlying tables in the lakehouse storage. Which permission level should you assign directly to the analysts on the semantic model?

A Power BI report using a semantic model in 'Direct Lake' mode is performing poorly. You want to determine if the queries are falling back to 'DirectQuery' mode due to memory constraints or unsupported DAX features. Which tool is best suited for this specific optimization task?

Which file format should you choose for a Lakehouse to ensure the best support for ACID transactions and high-performance analytical queries?

Which action must be taken to enable 'Time Travel' functionality on a Delta Lake table in Fabric?

Which Fabric feature allows you to orchestrate complex data ingestion and transformation workflows using a drag-and-drop interface?

In Microsoft Fabric, you notice that a background job (such as a Dataflow refresh) is taking significantly longer than usual, even though the total Capacity Unit (CU) usage is below the limit. What is the most likely cause of this behavior based on Fabric's capacity management rules?

You are analyzing a performance bottleneck using the 'Timepoint Detail' page in the Fabric Capacity Metrics app. Which THREE pieces of information can you find here to help identify the specific cause of a capacity overage? (Select THREE)

You are the Fabric Administrator for a large enterprise. You need to organize workspaces by business department (e.g., Finance, Marketing, Sales) to allow department heads to manage their own settings and users while still maintaining centralized billing. What is the most efficient way to achieve this grouping and delegated management?

You are performing a large-scale data migration into a Fabric Lakehouse using a Spark Notebook. You notice that the job is failing with an 'Out of Memory' error. What is the most effective way to address this while utilizing PySpark?

An administrator needs to organize Fabric items using Domains. They want to ensure that items are automatically assigned to the 'Sales' domain based on their location. Which THREE of the following steps are required to implement and verify this domain-based organization?

You have a Lakehouse in a workspace and want to allow a specific user to query the data using the SQL analytics endpoint, but you do not want them to be able to modify the Lakehouse schema or delete files. Which action should you take?

Your enterprise requires strict compliance tracking for all data pipeline executions inside a Microsoft Fabric workspace. You need to implement a monitoring solution that captures detailed activity logs, pipeline run statuses, and capacity consumption metrics over a 180-day retention period for auditing purposes. What is the most effective native mechanism to achieve this?

You are processing a large dataset in a Notebook and encounter frequent 'Shuffle' operations that slow down the job. What is the most likely cause?

When writing data to a Lakehouse table using a Spark Notebook in Microsoft Fabric, which optimization is enabled by default to ensure maximum compatibility and performance across all Fabric engines?

You are monitoring a Microsoft Fabric Lakehouse. You observe that queries against a specific Delta table are performing poorly. You identify that the table contains a large number of small files. Which command should you run to optimize the file layout?

When designing an analytics solution, what is the primary purpose of the 'Gold' layer in a Medallion architecture?

You are using Dataflow Gen2 to ingest data from multiple sources. You need to perform a complex transformation that involves merging data from a SQL database and a flat file based on a common key. Which step should you take to achieve this efficiently?

Which Fabric tool allows you to visually track the total compute usage of your workspace over a specific timeframe?

Refer to the exhibit. The Copy activity fails to infer the schema correctly from the source files. What is the most likely cause?

You are configuring a Fabric Pipeline. Which TWO activities can be used to perform conditional logic within your data ingestion workflow?

A Data Engineer needs to share a specific folder within a Lakehouse with a different team. The team should only be able to read the files in that specific folder and should not have access to any other data in the Lakehouse or the ability to run Spark notebooks. What is the most secure method to implement this?

Which approach is most efficient for loading a large volume of historical data into a Fabric Lakehouse from an external source?

You need to monitor the historical performance of queries in a Fabric Warehouse to identify which ones frequently use the most CPU time. Which Dynamic Management View (DMV) should you query?

Your organization uses a Fabric Spark notebook to process large volumes of streaming data into a Delta table. You notice that over time, query performance on the table is degrading significantly. Upon investigation, you find thousands of small files in the underlying OneLake folder. Which optimization strategy should you implement to resolve the performance issue while maintaining data integrity?

You are monitoring a Data Factory pipeline. What is the best way to be notified when a pipeline fails during an execution?

You need to minimize the performance impact of concurrent data refreshes on your Fabric capacity. What is the best strategy?

You are designing a data pipeline in Microsoft Fabric to ingest incremental data from an on-premises SQL Server. You need to ensure that only records modified since the last pipeline run are ingested. Which approach should you implement to maintain optimal performance and minimal data redundancy?

You are monitoring long-running Spark jobs in your Fabric workspace. You want to identify which specific stages of the job are consuming the most time. Which tool should you use?

A data engineer needs to provide access to data stored in an external Azure Data Lake Storage (ADLS) Gen2 account without moving the data into the Fabric Lakehouse. Which feature of Microsoft Fabric should be used?

Refer to the exhibit. You are reviewing the execution plan for a query running on a Fabric SQL Analytics Endpoint. The query is performing slower than expected. Based on the JSON snippet of the plan, what is the most likely cause of the performance bottleneck?

Refer to the exhibit. An administrator is reviewing the capacity metrics for a Fabric F64 capacity. The logs indicate that the 'percentUtilization' has exceeded 100% and the 'throttlingStatus' is 'Throttled'. What is the most likely cause for this behavior in a Fabric environment?

Refer to the exhibit. You are reviewing a JSON snippet from a Fabric Data Factory pipeline. What is the result of executing this activity if the target table already exists?

You are optimizing a Spark Notebook in Fabric that processes large Parquet files. Which TWO actions will improve the performance of data transformations?

An organization must comply with strict data residency requirements. They have a Microsoft Fabric tenant in the 'East US' region but need to create a workspace where data is stored and processed in 'North Europe'. How can the administrator achieve this?

A Microsoft Fabric tenant is experiencing frequent throttling of background operations during the early morning hours. You have been tasked with identifying which specific items are consuming the most capacity units (CU) to determine if a workload needs to be rescheduled. Which tool should you use to get the most granular view of item-level CU consumption over a 14-day period?

You are configuring a Data Factory Pipeline to perform an incremental load from an Azure SQL Database to a Fabric Warehouse. Which THREE components or features are essential for implementing a watermark-based incremental load? (Choose THREE)

Refer to the exhibit. The refresh operation for a Power BI semantic model took 45 minutes to complete. What is the most efficient way to reduce the refresh time for this specific model?

A Data Factory pipeline in Fabric fails during the execution of a Copy activity. You need to find the specific error message and the number of rows successfully written before the failure. Where should you look?

You need to ingest data from an on-premises SQL Server database into a Fabric Lakehouse. What must be installed and configured on a local server to facilitate this connection?

Refer to the exhibit. You are attempting to publish a Dataflow Gen2 that loads data into a Fabric Warehouse. Based on the error message, what action must you take to successfully publish the dataflow?

Refer to the exhibit. You are running a Fabric Notebook. What is the most likely cause of the error shown?

When a Spark notebook job finishes, what is the best practice for managing the underlying compute cluster resources?

A company is using Git integration in Microsoft Fabric to manage their Lakehouse and Report items. They notice that after a developer committed changes to a branch and synced them to the workspace, certain sensitive metadata files are being tracked in the repository. Which file should be modified in the local Git repository to prevent specific Fabric item metadata from being tracked in the future?

A data engineering team is setting up Git integration for a Microsoft Fabric workspace. They need to ensure that the synchronization process is robust and follows best practices for collaborative development. Which TWO actions should the team perform to successfully manage version control for Fabric items? (Choose TWO)

An organization is using the 'Fabric Capacity Metrics' app to monitor their F64 capacity. They see a high 'Background rejection' rate. What does this indicator typically mean for the analytics solution?

You are designing a Fabric pipeline to copy data from an on-premises SQL Server to a OneLake Lakehouse. Which integration runtime configuration ensures the highest throughput for large datasets?

Which configuration would you adjust to improve the performance of a Spark job that is consistently failing due to 'Out of Memory' (OOM) errors during aggregation?

A large enterprise wants to implement a 'Hub and Spoke' data architecture in Microsoft Fabric. They need to share a validated 'Gold' Lakehouse from a central workspace with multiple departmental workspaces without duplicating the underlying storage in OneLake. What is the most effective method to achieve this?

You have a Fabric pipeline that runs a notebook. The notebook takes longer to start each time. What is the most likely cause?

Refer to the exhibit. You are configuring a Dataflow Gen2 to move data. Based on the JSON configuration, what happens if the incoming data contains an extra column not defined in the destination schema?

Refer to the exhibit. An engineer receives this error when attempting to trigger a Fabric pipeline. What is the most likely cause?

You need to ingest data from an Azure SQL Database that is protected by a firewall and does not allow public network access. Which Fabric feature should you use to establish a secure connection without opening the firewall to all Azure services?

You are designing a data lakehouse architecture. Which file format is recommended for optimal performance in Fabric?

You are optimizing the ingestion of a large dataset into a Microsoft Fabric Lakehouse using a Spark Notebook. To ensure optimal query performance for downstream consumers, you want to apply the V-Order optimization and partition the data. Which TWO actions should you take to achieve this?

You are managing a Microsoft Fabric Capacity. You need to identify which two metrics are most effective for tracking the 'smoothing' behavior of your capacity during peak usage. Which two metrics should you monitor?

A company is using a Fabric F64 capacity. During a period of low activity, the administrator wants to reduce costs. What is the most direct way to stop incurring charges for the Fabric compute resources without deleting the capacity?

Refer to the exhibit. You are attempting to run an OPTIMIZE command with Z-ORDER on a large Lakehouse table. The operation fails with an InsufficientMemory error. What should you do to resolve this?

You need to access data from an external Azure Data Lake Storage (ADLS) Gen2 account in a Fabric Lakehouse without duplicating the physical data. Which feature should you use?

You are designing a data transformation layer using Spark in Microsoft Fabric. Which THREE of the following are primary benefits of using Delta Lake format over traditional Parquet files? (Choose three)

Refer to the exhibit. The query is performing a full table scan on a 1TB table. What is the most effective way to optimize this query?

You are using a KQL Database in a Microsoft Fabric Eventhouse to analyze streaming data. You need to monitor the performance of your Kusto queries and identify which ones are consuming the most resources. Which TWO methods should you use?

Refer to the exhibit. You are reviewing the configuration for a Fabric Spark Environment. A job is failing with an 'OutOfMemoryError' during a large shuffle operation. Based on the configuration, which change would most likely resolve the issue?

You are optimizing a Data Warehouse in Microsoft Fabric. Which TWO strategies will effectively improve the performance of read-heavy workloads?

You need to monitor the performance of your Fabric SQL Warehouse. Which tool or feature should you use to identify long-running queries?

You are optimizing a Spark job in Fabric. Which TWO of the following techniques will help reduce the execution time? (Choose two)

You need to ingest data from an API into a Fabric Lakehouse. The API requires a token-based authentication refreshed every hour. What is the most efficient way to handle this?

You are monitoring an ingestion pipeline and notice it frequently fails with a 'Timeout' error. What is the most likely cause?

Refer to the exhibit. Which command would be most effective for improving query performance on this table if you frequently filter by TransDate?

You are configuring a Copy Activity in Fabric Data Factory to ingest data from an external REST API. Which TWO configuration settings are required to ensure data is handled correctly? (Choose two)

Your organization wants to automate the deployment of Fabric items using a CI/CD pipeline in Azure DevOps. You need to programmatically trigger the deployment of a Fabric workspace from the 'Development' stage to the 'Test' stage in a deployment pipeline. Which approach should you use?

Refer to the exhibit. You are loading this file into a Lakehouse. You notice that the column headers contain special characters, and the data is failing to load correctly. What should you do?

Refer to the exhibit. An administrator is reviewing the properties of a Lakehouse via the Fabric REST API. The property 'hasManagedPrivateEndpoint' is set to true. What does this indicate about the security configuration for this specific item?

A large enterprise is organizing its Microsoft Fabric environment. They need to allow a team of developers to create and modify Lakehouses, Warehouses, and Notebooks within a specific workspace. However, the organization's security policy dictates that these developers must not be able to share items or modify the workspace's membership. Which workspace role should you assign to these developers?

Your organization uses Power BI in Fabric. Users report that reports are slow to load. You want to identify which specific visuals are causing the performance bottleneck. Which tool should you use?

You are configuring a medallion architecture in Microsoft Fabric using Lakehouse Delta tables. You need to implement an incremental data load pattern from a bronze table to a silver table using a PySpark notebook. Which TWO actions must you perform to ensure idempotency and high performance? Choose exactly two.

You are developing a Notebook in Microsoft Fabric to process high-volume sensor data. You need to optimize performance using Delta Lake features. Which TWO actions should you perform? (Choose two)

Refer to the exhibit. You are reviewing the monitoring logs for your Fabric capacity. What is the most likely cause of the error shown in the exhibit?

You are designing a governance strategy for Microsoft Fabric. You want to ensure that certain sensitive data remains within specific geographic boundaries. Which TWO Fabric features or settings can help you implement and enforce this requirement?

You are managing a Microsoft Fabric environment and need to implement 'Endorsement' for several high-quality datasets to help users find reliable data. Which TWO levels of endorsement can you apply to Fabric items?

You are auditing a Fabric workspace to ensure optimal performance. You want to see the execution history and duration of all Spark notebooks run within the last 30 days. Where should you look?

Refer to the exhibit. You are using Structured Streaming to ingest data into a Delta table. Why is the checkpoint path required?

You are managing a Microsoft Fabric Lakehouse. You need to ensure that data in the Bronze layer is accessible to the Silver layer while enforcing strict row-level security for downstream users. What is the most efficient way to implement this architecture while maintaining performance?

You are designing a data orchestration strategy using Microsoft Fabric Data Factory. You need to ensure that your pipeline can handle intermittent source system failures and provide notifications upon success or failure. Which THREE pipeline activities or features should you use? (Choose THREE)