Sample questions
Microsoft Fabric Analytics Engineer Associate practice questions
You are creating a semantic model in Microsoft Fabric that will be used by report authors. You need to ensure that when they use the 'Analyze in Excel' feature, they can see friend…
You are using a Fabric pipeline to copy data from an on-premises Oracle database to a Lakehouse. The pipeline uses a self-hosted integration runtime. You need to ensure that the co…
You are a Fabric analytics engineer at a retail company. A data pipeline in your Fabric workspace loads sales data daily into a Lakehouse. Recently, the pipeline started failing in…
Refer to the exhibit. You are reviewing a JSON configuration for a Fabric item. What is the primary outcome of deploying this configuration in a Microsoft Fabric workspace?
Refer to the exhibit. You are processing data in a Spark Notebook. The schema of the incoming data does not contain the 'date_col' column, but your downstream code expects it. What…
You are troubleshooting a Microsoft Fabric Lakehouse that is experiencing slow query performance when using SQL endpoints. You notice that many small Parquet files are being genera…
You are implementing a semantic model in Microsoft Fabric that must show sales amounts in the reporting user's preferred currency. The model contains a fact table 'Sales' with 'Sal…
You are maintaining a Microsoft Fabric workspace that uses Git integration with Azure DevOps. A developer accidentally commits a change to a semantic model that breaks downstream r…
You are cleaning data using a Dataflow Gen2 in Microsoft Fabric. You need to optimize the performance of the transformation process. Which TWO actions should you perform? Each corr…
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…
You are troubleshooting a scheduled refresh failure for a Dataflow Gen2 in Microsoft Fabric. The error log indicates that the destination lakehouse is inaccessible. What is the mos…
You are managing a Microsoft Fabric workspace. You notice that a specific Power BI report is failing to refresh due to a performance bottleneck in the underlying DirectLake semanti…
You are optimizing a Lakehouse for performance. Which three actions help improve the query performance for users accessing the SQL endpoint?
You are optimizing a Power BI semantic model that uses Incremental Refresh. You need to ensure that historical data is not reloaded during every refresh cycle. Which configuration…
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…
You are developing a Power BI semantic model in Microsoft Fabric. You need to implement row-level security (RLS) to ensure that users in the 'Sales' department can only view data c…
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 a…
You have a dataset with a highly skewed distribution in a join key. When performing a join in a Spark notebook, you observe performance degradation. Which technique should you use…
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 grou…
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 featu…
A Fabric Lakehouse table named Sales is stored in Delta format and contains a column OrderDate of type string holding values such as '2024-03-15'. Analysts complain that range filt…
You are implementing security for a Microsoft Fabric semantic model. You need to ensure that regional managers can only see data for their own regions. Which TWO steps must you per…
You are setting up a deployment pipeline for a workspace that contains sensitive financial data. Which TWO of the following permissions or conditions are required for a user to dep…
You are using a Microsoft Fabric Notebook to process a large dataset stored in a Lakehouse. You need to ensure that the Spark job uses the most efficient method to handle many smal…