You need to integrate a machine learning model into a data pipeline in Microsoft Fabric for predictive analytics. The model should be deployed and available for inference in near real-time. Which platform or service within Microsoft Fabric would you use to deploy the model for inference?

You are using Microsoft Fabric to develop a solution where data will be processed in real-time from several sources. To ensure that data integrity is maintained while handling high volumes of data, which of the following storage options should be implemented?

A company wants to build a reporting solution in Microsoft Fabric that provides near real-time data processing capabilities for operational dashboards. Which feature should you enable in Power BI to support real-time reporting?

In Microsoft Fabric, you need to build an end-to-end data pipeline that involves the transformation, storage, and visualization of data. Which combination of tools within Microsoft Fabric would allow you to efficiently manage this process?

You are designing a data model in Microsoft Fabric using Azure Synapse Analytics. The model needs to efficiently handle queries from both internal and external users. Which storage solution should you choose to ensure optimal query performance and ease of access?

A business user wants to analyze data in Microsoft Fabric in an interactive, self-service manner, without needing to learn complex querying or modeling techniques. What feature in Power BI would best support this use case?

You are building a complex data transformation in Microsoft Fabric that requires frequent updates. Which tool would be best to perform the transformation efficiently without requiring manual intervention?

A company is using Microsoft Fabric to store large amounts of data from IoT devices in their data lake. The data needs to be processed in real-time, but the company also requires compliance with industry standards. What would be the best storage solution to use in this scenario?

You are designing an analytics solution in Microsoft Fabric that needs to aggregate data from structured and unstructured sources. The solution must support the queryability and processing of both data types. Which data architecture would be best suited for this scenario?

In Microsoft Fabric, you are tasked with ensuring that users can only view specific rows of data based on their role. This is required for compliance reasons. Which feature should you implement to restrict access to sensitive data?

A large-scale dataset in Microsoft Fabric has performance issues when users query it for historical analytics. The dataset needs to be optimized to improve query performance. What should you do to ensure optimal performance while retaining full historical data?

A company is integrating machine learning models into their Microsoft Fabric solution. The models need to be deployed and used for scoring in real-time. Which service should you use for deployment and inference within Microsoft Fabric?

You are working with streaming data in Microsoft Fabric that requires low-latency processing. The data comes from sensors deployed in various locations and must be processed in real-time for analytics. Which service within Microsoft Fabric would you use to handle this data?

In Microsoft Fabric, you're tasked with optimizing the performance of your data warehouse. Your dataset is extremely large, and query performance is suboptimal. Which of the following approaches would most effectively improve query speed for analytical queries?

You are designing a data pipeline in Microsoft Fabric that pulls data from various sources, including a SQL Server database, a REST API, and a data lake. Which of the following is the best approach to ensure the data is integrated seamlessly into the pipeline for processing?

You are configuring a reporting dashboard in Microsoft Fabric, and you need to implement a solution that allows business users to perform ad-hoc analysis with minimal training. What should you enable for these users to interact with the data easily?

A company wants to ensure that their data in Microsoft Fabric is stored in a way that supports both analytical querying and historical data tracking. They need a solution that provides ACID transactions and supports efficient queries on historical data. Which storage solution is most appropriate for these needs?

You are working with an analytics pipeline in Microsoft Fabric, and need to process streaming data from IoT devices. The pipeline must ensure low latency and handle large volumes of incoming data efficiently. Which service in Microsoft Fabric should you leverage for processing the data in real-time?

A company has large, time-series data stored in Microsoft Fabric. They need to process this data quickly to generate real-time analytics. Which type of data partitioning would you recommend to improve performance in such a scenario?

You are tasked with optimizing an ETL pipeline within Microsoft Fabric that needs to handle data from multiple sources, including databases and APIs. The data must be transformed, cleansed, and loaded into a data warehouse. What is the best approach for handling transformations in Microsoft Fabric?

A company is using Microsoft Fabric to store data in a lakehouse architecture, combining both structured and unstructured data. They need to ensure that the data is easily accessible for various analytic workloads, but with performance optimization. Which storage format should be used in Microsoft Fabric for optimal performance?

You are designing an analytics solution in Microsoft Fabric that uses machine learning to predict future sales based on historical data. Which service would you integrate into your pipeline to deploy machine learning models and use them for prediction within Microsoft Fabric?

In Microsoft Fabric, you are tasked with designing a data pipeline that pulls data from multiple disparate data sources, including structured and unstructured data. Which approach would be the best for orchestrating and managing this data pipeline end-to-end?

A company is using Microsoft Fabric to process financial data in a data warehouse. The data is being transformed using Power Query, but the company needs to ensure that any errors in the data transformations are logged and can be reviewed later. How should you implement error logging in Microsoft Fabric?

A customer is using Microsoft Fabric to store sensitive data and needs to comply with GDPR regulations. Which feature in Microsoft Fabric helps ensure data privacy by restricting data access based on user roles?

You are building a data model in Microsoft Fabric that aggregates large volumes of transaction data for analysis. The data model includes complex DAX calculations, but performance is slow when running queries. Which strategy would improve query performance in this scenario?

You are designing a real-time analytics solution in Microsoft Fabric. The solution needs to handle high-velocity data coming from IoT devices and process it in near real-time. Which Microsoft Fabric component should you use for processing streaming data efficiently?

A business user needs to view large-scale data visualizations in Power BI within the Microsoft Fabric environment. The dataset is too large to be processed in memory, causing performance issues. Which feature should you use to ensure the data is available for visualizations without impacting performance?

You are using Microsoft Fabric to build a data pipeline that processes data from multiple sources. The data processing needs to be automated, and the pipeline should handle failures gracefully. Which feature of Microsoft Fabric should you use to meet these requirements?

You are tasked with optimizing a large dataset in Microsoft Fabric for use in an analytical model. The dataset contains millions of rows of data, and queries are running slowly. Which approach would help improve performance without altering the dataset structure?

You have a Fabric tenant

You are creating a Fabric Data Factory pipeline.

You have a stored procedure that returns the number of active customers and their average sales for the current month.

You need to add an activity that will execute the stored procedure in a warehouse. The returned values must be available to the downstream activities of the pipeline.

Which type of activity should you add?

You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains a Delta table named Customer.
When you query Customer, you discover that the query is slow to execute. You suspect that maintenance was NOT performed on the table.
You need to identify whether maintenance tasks were performed on Customer.
Solution: You run the following Spark SQL statement:

EXPLAIN TABLE customer -
Does this meet the goal?

You have a Fabric tenant that contains a data pipeline.
You need to ensure that the pipeline runs every four hours on Mondays and Fridays.
To what should you set Repeat for the schedule?

You have a Fabric workspace named Workspace1 that contains a data flow named Dataflow1 contains a query that returns the data shown in the following exhibit.

Your network contains an on-premises Active Directory Domain Services (AD DS) domain named contoso.com that syncs with a Microsoft Entra tenant by using Microsoft Entra Connect.
You have a Fabric tenant that contains a semantic model.
You enable dynamic row-level security (RLS) for the model and deploy the model to the Fabric service.
You query a measure that includes the USERNAME() function, and the query returns a blank result.
You need to ensure that the measure returns the user principal name (UPN) of a user.
Solution: You add user objects to the list of synced objects in Microsoft Entra Connect.
Does this meet the goal?

You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains an unpartitioned table named Table1.
You plan to copy data to Table1 and partition the table based on a date column in the source data.
You create a Copy activity to copy the data to Table1.
You need to specify the partition column in the Destination settings of the Copy activity.
What should you do first?

You have a Fabric tenant that contains 30 CSV files in OneLake. The files are updated daily.
You create a Microsoft Power BI semantic model named Model1 that uses the CSV files as a data source. You configure incremental refresh for Model1 and publish the model to a Premium capacity in the Fabric tenant.
When you initiate a refresh of Model1, the refresh fails after running out of resources.
What is a possible cause of the failure?

You have a Fabric tenant that uses a Microsoft Power BI Premium capacity.
You need to enable scale-out for a semantic model.
What should you do first?

You have a Fabric workspace named Workspace1 that contains a dataflow named Dataflow1. Dataflow1 has a query that returns 2,000 rows.
You view the query in Power Query as shown in the following exhibit.

What can you identify about the pickupLongitude column?

You have a Fabric tenant that contains a warehouse.
You use a dataflow to load a new dataset from OneLake to the warehouse.
You need to add a PowerQuery step to identify the maximum values for the numeric columns.
Which function should you include in the step?

You have a Fabric tenant that contains a machine learning model registered in a Fabric workspace.
You need to use the model to generate predictions by using the PREDICT function in a Fabric notebook.
Which two languages can you use to perform model scoring? Each correct answer presents a complete solution.

You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains a subfolder named Subfolder1 that contains CSV files.
You need to convert the CSV files into the delta format that has V-Order optimization enabled.
What should you do from Lakehouse explorer?

You have source data in a folder on a local computer.
You need to create a solution that will use Fabric to populate a data store. The solution must meet the following requirements:
Support the use of dataflows to load and append data to the data store.
Ensure that Delta tables are V-Order optimized and compacted automatically.
Which type of data store should you use?

You have a Fabric tenant that contains a lakehouse named Lakehouse’. Lakehouse1 contains a table named Tablet.
You are creating a new data pipeline.
You plan to copy external data to Table’. The schema of the external data changes regularly.
You need the copy operation to meet the following requirements:
Replace Table1 with the schema of the external data.
Replace all the data in Table1 with the rows in the external data.
You add a Copy data activity to the pipeline.
What should you do for the Copy data activity?

You have a Fabric tenant that contains a complex semantic model. The model is based on a star schema and contains many tables, including a fact table named Sales.
You need to create a diagram of the model. The diagram must contain only the Sales table and related tables.
What should you use from Microsoft Power BI Desktop?

You have a Fabric workspace that contains a DirectQuery semantic model. The model queries a data source that has 500 million rows.
You have a Microsoft Power Bi report named Report1 that uses the model. Report1 contains visuals on multiple pages.
You need to reduce the query execution time for the visuals on all the pages.
What are two features that you can use? Each correct answer presents a complete solution.

You have a Fabric tenant that contains a warehouse. The warehouse uses row-level security (RLS).
You create a Direct Lake semantic model that uses the Delta tables and RLS of the warehouse.
When users interact with a report built from the model, which mode will be used by the DAX queries?

You are creating a semantic model in Microsoft Power BI Desktop.
You plan to make bulk changes to the model by using the Tabular Model Definition Language (TMDL) extension for Microsoft Visual Studio Code.
You need to save the semantic model to a file.
Which file format should you use?

You have a Fabric tenant that contains a Microsoft Power BI report named Report1. Report1 includes a Python visual.
Data displayed by the visual is grouped automatically and duplicate rows are NOT displayed.
You need all rows to appear in the visual.
What should you do?

You have a Fabric tenant named Tenant1 that contains a workspace named WS1. WS1 uses a capacity named C1 and contains a dataset named DS1.
You need to ensure read-write access to DS1 is available by using XMLA endpoint.
What should be modified first?

You are analyzing the data in a Fabric notebook.
You have a Spark DataFrame assigned to a variable named df.
You need to use the Chart view in the notebook to explore the data manually.
Which function should you run to make the data available in the Chart view?

You are the administrator of a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains the following tables:
Table1: A Delta table created by using a shortcut
Table2: An external table created by using Spark

Table3: A managed table -
You plan to connect to Lakehouse1 by using its SQL endpoint.
What will you be able to do after connecting to Lakehouse1?