Your company wants to enforce security policies that restrict access to sensitive data stored in a Fabric Warehouse. What is the best approach?

You need to optimize a Fabric Data Pipeline that loads terabytes of data from multiple sources daily. What is the most efficient way to improve performance?

A company wants to analyze streaming data in Microsoft Fabric but needs to retain raw event data for historical analysis. What is the best solution?

A data pipeline in Microsoft Fabric is failing intermittently due to inconsistent source data formats. What is the best way to handle this?

You need to ensure that data engineers can collaborate in real time while working on a Fabric Notebook. What is the best way to achieve this?

A team needs to create a Machine Learning model using data stored in a Fabric Lakehouse. They want to process large datasets efficiently without moving the data outside Fabric. Which approach is best?

You are tasked with implementing data lineage tracking in Microsoft Fabric to ensure data transparency and governance. Which built-in feature should you use?

A company wants to optimize its Microsoft Fabric Warehouse storage costs while retaining historical data for analytics. The data is frequently queried for recent transactions but older records are rarely accessed. What is the best strategy?

Your company wants to automate data movement from an on-premises Oracle database to a Fabric Lakehouse with minimal manual intervention. The solution should also support schema evolution. What is the best option?

You are configuring security in a Microsoft Fabric Lakehouse and need to ensure that different departments have restricted access to specific data. Which approach should you take?

A data engineer needs to ensure that Microsoft Fabric can integrate seamlessly with Power BI for real-time reporting while querying large datasets. Which mode should be used for the Power BI dataset?

You need to improve the performance of queries running on a large Fabric Warehouse table that contains billions of rows. The queries primarily filter data based on a date column. What is the best optimization technique?

A company is using Microsoft Fabric to build a data pipeline. The pipeline should load data incrementally from an Azure SQL Database into a Fabric Lakehouse while ensuring minimal load on the source system. Which approach should you take?

You need to automate the movement of data between Fabric Lakehouse and Warehouse, ensuring data freshness without manual intervention. What is the best approach?

Your organization is using Microsoft Fabric to analyze sales data across multiple regions. The queries run slowly due to large dataset sizes. What is the best approach to optimize query performance?

You need to build a solution in Microsoft Fabric where raw JSON data is stored in OneLake and then transformed for reporting purposes. The transformation logic should be reusable and scalable. What should you use?

A company wants to implement near real-time reporting on data stored in Microsoft Fabric Warehouse. The reports should update automatically with minimal delays. Which method should be used?

You are designing a Fabric Data Pipeline that must ingest data from an on-premises SQL Server into OneLake. The solution must support incremental data loads and ensure minimal latency. What should you use?

A Fabric Data Engineer needs to ensure that only authorized users can access specific rows of data within a Warehouse. What is the most efficient way to enforce this?

Your team needs to join multiple large datasets in Fabric and perform complex aggregations. The data is stored in OneLake and accessed using Spark. What is the best method to optimize performance?

You need to optimize a large dataset stored in Microsoft Fabric Lakehouse for analytics queries. The dataset is queried frequently by multiple users. What should you do?

A data engineer is designing a solution in Microsoft Fabric to process streaming data from IoT sensors. The solution should allow real-time analytics and be cost-efficient. Which option is the best?

You are using Microsoft Fabric to ingest data from multiple sources into a Lakehouse. You need to ensure that data ingestion is automated and can handle schema drift efficiently. Which approach should you use?

You have a Fabric workspace that contains an eventstream named Eventstream1. Eventstream1 processes data from a thermal sensor by using event stream processing, and then stores the data in a lakehouse. You need to modify Eventstream1 to include the standard deviation of the temperature. Which transform operator should you include in the Eventstream1 logic?

You need to resolve the sales data issue. The solution must minimize the amount of data transferred. What should you do?

You need to populate the MAR1 data in the bronze layer. Which two types of activities should you include in the pipeline?

You need to ensure that usage of the data in the Amazon S3 bucket meets the technical requirements. What should you do?

You need to ensure that the data analysts can access the gold layer lakehouse. What should you do?

You have a Fabric workspace that contains a warehouse named Warehouse1. Data is loaded daily into Warehouse1 by using data pipelines and stored procedures. You discover that the daily data load takes longer than expected. You need to monitor Warehouse1 to identify the names of users that are actively running queries. Which view should you use?

You have a Fabric workspace that contains an eventstream named EventStream1. EventStream1 outputs events to a table in a lakehouse. You need to remove files that are older than seven days and are no longer in use. Which command should you run?

You have a Fabric notebook named Notebook1 that has been executing successfully for the last week. During the last run, Notebook1executed nine jobs. You need to view the jobs in a timeline chart. What should you use?

You have a Fabric eventstream that loads data into a table named Bike_Location in a KQL database. The table contains the following columns:
BikepointID -
Street -
Neighbourhood -
No_Bikes -
No_Empty_Docks -
Timestamp -
You need to apply transformation and filter logic to prepare the data for consumption. The solution must return data for a neighbourhood named Sands End when No_Bikes is at least 15. The results must be ordered by No_Bikes in ascending order.
Solution: You use the following code segment:

You have a Fabric eventstream that loads data into a table named Bike_Location in a KQL database. The table contains the following columns:
BikepointID -
Street -
Neighbourhood -
No_Bikes -
No_Empty_Docks -
Timestamp -
You need to apply transformation and filter logic to prepare the data for consumption. The solution must return data for a neighbourhood named Sands End when No_Bikes is at least 15. The results must be ordered by No_Bikes in ascending order.
Solution: You use the following code segment:

You have a Fabric eventstream that loads data into a table named Bike_Location in a KQL database. The table contains the following columns:

BikepointID -
Street -
Neighbourhood -
No_Bikes -
No_Empty_Docks -
Timestamp -

You need to apply transformation and filter logic to prepare the data for consumption. The solution must return data for a neighbourhood named Sands End when No_Bikes is at least 15. The results must be ordered by No_Bikes in ascending order.
Solution: You use the following code segment:

You have a Fabric eventstream that loads data into a table named Bike_Location in a KQL database. The table contains the following columns:
BikepointID -
Street -
Neighbourhood -
No_Bikes -
No_Empty_Docks -
Timestamp -

You need to apply transformation and filter logic to prepare the data for consumption. The solution must return data for a neighbourhood named Sands End when No_Bikes is at least 15. The results must be ordered by No_Bikes in ascending order.
Solution: You use the following code segment:

Does this meet the goal?

You have a Fabric workspace that contains a semantic model named Model1.
You need to dynamically execute and monitor the refresh progress of Model1.
What should you use?

You have a Fabric workspace that contains a warehouse named DW1. DW1 is loaded by using a notebook named Notebook1.
You need to identify which version of Delta was used when Notebook1 was executed.
What should you use?

You have five Fabric workspaces.
You are monitoring the execution of items by using Monitoring hub.
You need to identify in which workspace a specific item runs.
Which column should you view in Monitoring hub?

You have a Fabric capacity that contains a workspace named Workspace1. Workspace1 contains a lakehouse named Lakehouse1, a data pipeline, a notebook, and several Microsoft Power BI reports.
A user named User1 wants to use SQL to analyze the data in Lakehouse1.
You need to configure access for User1. The solution must meet the following requirements:
Provide User1 with read access to the table data in Lakehouse1.
Prevent User1 from using Apache Spark to query the underlying files in Lakehouse1.
Prevent User1 from accessing other items in Workspace1.
What should you do?

You have two Fabric workspaces named Workspace1 and Workspace2.
You have a Fabric deployment pipeline named deployPipeline1 that deploys items from Workspace1 to Workspace2. DeployPipeline1 contains all the items in Workspace1.
You recently modified the items in Workspaces1.
The workspaces currently contain the items shown in the following table.

You have a Fabric workspace named Workspace1 that contains a warehouse named DW1 and a data pipeline named Pipeline1.
You plan to add a user named User3 to Workspace1.
You need to ensure that User3 can perform the following actions:
View all the items in Workspace1.
Update the tables in DW1.
The solution must follow the principle of least privilege.
You already assigned the appropriate object-level permissions to DW1.
Which workspace role should you assign to User3?

You have an Azure Data Lake Storage Gen2 account named storage1 and an Amazon S3 bucket named storage2.
You have the Delta Parquet files shown in the following table.

You have a Fabric workspace named Workspace1.
You plan to integrate Workspace1 with Azure DevOps.
You will use a Fabric deployment pipeline named deployPipeline1 to deploy items from Workspace1 to higher environment workspaces as part of a medallion architecture. You will run deployPipeline1 by using an API call from an Azure DevOps pipeline.
You need to configure API authentication between Azure DevOps and Fabric.
Which type of authentication should you use?

You have a Fabric workspace that contains a Real-Time Intelligence solution and an eventhouse.
Users report that from OneLake file explorer, they cannot see the data from the eventhouse.
You enable OneLake availability for the eventhouse.
What will be copied to OneLake?

You have a Fabric workspace named Workspace1 that contains a warehouse named Warehouse1.
You plan to deploy Warehouse1 to a new workspace named Workspace2.
As part of the deployment process, you need to verify whether Warehouse1 contains invalid references. The solution must minimize development effort.
What should you use?

You have a Fabric F32 capacity that contains a workspace. The workspace contains a warehouse named DW1 that is modelled by using MD5 hash surrogate keys.
DW1 contains a single fact table that has grown from 200 million rows to 500 million rows during the past year.
You have Microsoft Power BI reports that are based on Direct Lake. The reports show year-over-year values.
Users report that the performance of some of the reports has degraded over time and some visuals show errors.
You need to resolve the performance issues. The solution must meet the following requirements:
Provide the best query performance.
Minimize operational costs.
Which should you do?

You have a Fabric workspace. You have semi-structured data. You need to read the data by using T-SQL, KQL, and Apache Spark. The data will only be written by using Spark. What should you use to store the data?

You have a Fabric workspace that contains a warehouse named Warehouse1. You have an on-premises Microsoft SQL Server database named Database1 that is accessed by using an on-premises data gateway. You need to copy data from Database1 to Warehouse1. Which item should you use?

You have a Google Cloud Storage (GCS) container named storage1 that contains the files shown in the following table.

You have a Fabric workspace named Workspace1 that has the cache for shortcuts enabled. Workspace1 contains a lakehouse named Lakehouse1. Lakehouse1 has the shortcuts shown in the following table.

You need to read data from all the shortcuts.
Which shortcuts will retrieve data from the cache?

You have a Fabric deployment pipeline that uses three workspaces named Dev, Test, and Prod. You need to deploy an eventhouse as part of the deployment process. What should you use to add the eventhouse to the deployment process?

You have a Fabric warehouse named DW1. DW1 contains a table that stores sales data and is used by multiple sales representatives. You plan to implement row-level security (RLS). You need to ensure that the sales representatives can see only their respective data. Which warehouse object do you require to implement RLS?

You have a Fabric workspace named Workspace1 that contains a notebook named Notebook1. In Workspace1, you create a new notebook named Notebook2. You need to ensure that you can attach Notebook2 to the same Apache Spark session as Notebook1. What should you do?

You have a Fabric workspace that contains a warehouse named Warehouse1.
You have an on-premises Microsoft SQL Server database named Database1 that is accessed by using an on-premises data gateway.
You need to copy data from Database1 to Warehouse1.
Which item should you use?