You have a Fabric tenant that contains two workspaces named Woritspace1 and Workspace2. Workspace1 contains a lakehouse named Lakehouse1. Workspace2 contains a lakehouse named Lakehouse2. Lakehouse! contains a table named dbo.Sales. Lakehouse2 contains a table named dbo.Customers.
You need to ensure that you can write queries that reference both dbo.Sales and dbo.Customers in the same SQL query without making additional copies of the tables.
What should you use?
You create a semantic model by using Microsoft Power Bl Desktop. The model contains one security role named SalesRegionManager and the following tables:
• Sales
• SalesRegion
• Sales Ad dress
You need to modify the model to ensure that users assigned the SalesRegionManager role cannot see a column named Address in Sales Address.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You have a Fabric tenant that contains a semantic model named Model1. Model1 uses Import mode. Model1 contains a table named Orders. Orders has 100 million rows and the following fields.
You need to reduce the memory used by Model! and the time it takes to refresh the model. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.
You have a Microsoft Power Bl project that contains a semantic model. You plan to use Azure DevOps for version control.
You need to modify the .gitignore file to prevent the data values from the data sources from being pushed to the repository. Which file should you reference?
Your company has a finance department.
You have a Fabric tenant, an Azure Storage account named storagel, and a Microsoft Entra group named Groupl. Groupl contains the users in the finance department.
You need to create a new workspace named Workspacel in the tenant. The solution must meet the following requirements:
• Ensure that the finance department users can create and edit items in Workspace"!.
• Ensure that Workspacel can securely access storagel to read and write data.
• Ensure that you are the only admin of Workspacel.
• Minimize administrative effort.
You create Workspacel.
Which two actions should you perform next? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
You have a Fabric tenant that contains a workspace named Workspace! Workspace1 uses the Pro license mode and contains a semantic model named Model1.
You have an Azure DevOps organization.
You need to enable version control for Workspace1. The solution must ensure that Model 1 is added to the repository.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You are creating a dataflow in Fabric to ingest data from an Azure SQL database by using a T-SQL statement.
You need to ensure that any foldable Power Query transformation steps are processed by the Microsoft SQL Server engine.
How should you complete the code? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
You have a Fabric workspace named Workspace1.
You need to create a semantic model named Model1 and publish Model1 to Workspace1. The solution must meet the following requirements:
Can revert to previous versions of Model1 as required.
Identifies differences between saved versions of Model1.
Uses Microsoft Power BI Desktop to publish to Workspace1.
Can edit item definition files by using Microsoft Visual Studio Code.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You need to refresh the Orders table of the Online Sales department. The solution must meet the semantic model requirements. What should you include in the solution?
Which syntax should you use in a notebook to access the Research division data for Productlinel?
A)
B)
C)
D)
