HOTSPOT
-
You have a Fabric tenant that contains three users named User1, User2, and User3. The tenant contains a security group named Group1. User1 and User3 are members of Group1.
The tenant contains the workspaces shown in the following table.
The tenant contains the domains shown in the following table.
User1 creates a new workspace named Workspace3.
You assign Domain1 as the default domain of Group1.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: No
No
No
Explanation: Assigning a default domain to a security group associates new workspaces created by its members with that domain, but it does not automatically grant workspace roles (Admin, Member, Contributor, Viewer). Workspace permissions must be assigned explicitly.
Question 62
HOTSPOT
-
You have a Fabric tenant that contains a warehouse named WH1.
You have source data in a CSV file that has the following fields:
• SalesTransactionID
• SaleDate
• CustomerCode
• CustomerName
• CustomerAddress
• ProductCode
• ProductName
• Quantity
• UnitPrice
You plan to implement a star schema for the tables in WH1. The dimension tables in WH1 will implement Type 2 slowly changing dimension (SCD) logic.
You need to design the tables that will be used for sales transaction analysis and load the source data.
Which type of target table should you specify for the CustomerName, CustomerCode, and SaleDate fields? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation: CustomerCode is the business key and CustomerName is an attribute of the Customer dimension, which uses Type 2 SCD. SaleDate should be modeled through a Date dimension in a star schema, with the fact table storing the corresponding DateKey.
Question 63
HOTSPOT
-
You have a Fabric tenant that contains a lakehouse named LH1.
You need to deploy a new semantic model. The solution must meet the following requirements:
• Support complex calculated columns that include aggregate functions, calculated tables, and Multidimensional Expressions (MDX) user hierarchies.
• Minimize page rendering times.
How should you configure the model? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Mode: Import
Query Caching: On
Explanation: Import mode supports calculated columns with aggregates, calculated tables, and MDX user hierarchies. Enabling query caching improves report/page rendering performance by serving cached query results when applicable.
Question 64
You have a Fabric tenant that contains a workspace named Workspace1 and a user named User1. User1 is assigned the Contributor role for Workspace1.
You plan to configure Workspace1 to use an Azure DevOps repository for version control.
You need to ensure that User1 can commit items to the repository.
Which two settings should you enable for User1? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Users can sync workspace items with GitHub repositories
B. Users can create and use Data workflows
C. Users can create Fabric items
D. Users can synchronize workspace items with their Git repositories
Show Answer
Correct Answer: C, D
Explanation: To commit Fabric workspace items to an Azure DevOps repository, the user must be allowed to create and modify Fabric items and the tenant must permit Git synchronization. The GitHub-specific setting applies to GitHub repositories, not Azure DevOps. 'Users can synchronize workspace items with their Git repositories' is the relevant Git integration setting for Azure DevOps, and 'Users can create Fabric items' is required to create or update items that can be committed.
Question 65
You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 uses Pro license mode and contains a semantic model named Model1.
You need to ensure that Model1 supports XMLA connections.
Which setting should modify?
A. Users can edit data models in the Power BI service
B. Enforce strict access control for all data connection types
C. Enable Cache for Shortcuts
D. License mode
Show Answer
Correct Answer: D
Explanation: XMLA endpoints are not supported for workspaces in Pro license mode. To enable XMLA connections for a semantic model, the workspace must use a supported license mode such as Premium, Premium Per User (PPU), or Fabric/Premium capacity. Therefore, the required change is the workspace's license mode.
Question 66
HOTSPOT
-
You have the following T-SQL statement.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: No
Yes
No
Explanation: The query groups by ProductCategory and Region for current-year rows only. Refunded rows are not filtered out, but their SalesAmount contributes 0 to TotalRevenue. Thus Region is not returned specifically because of refunded status, the WHERE clause limits to the current year, and TotalRevenue aggregates only non-refunded sales amounts.
Question 67
HOTSPOT
-
You have two Microsoft Power BI queries named Employee and Retired Roles.
You need to merge the Employee query with the Retired Roles query. The solution must ensure that duplicate rows in each query are removed.
Which column and Join Kind should you use in Power Query Editor? To answer, select the appropriate options in the answer area.
NOTE: Each correct answer is worth one point.
Explanation: Use the composite key (Division and Role) to uniquely match roles across both queries. An Inner join keeps only matching records, avoiding unmatched rows and preventing duplicate matches from incomplete keys.
Question 68
You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 contains a data pipeline named Pipeline1 and a lakehouse named Lakehouse1.
You perform the following actions:
• Create a workspace named Workspace2.
• Create a deployment pipeline named DeployPipeline1 that will deploy items from Workspace1 to Workspace2.
• Add a folder named Folder1 to Workspace1.
• Move Lakehouse1 to Folder1.
• Run DeployPipeline1.
Which structure will Workspace2 have when DeployPipeline1 is complete?
A. \Folder1\Pipeline1 \Folder1\Lakehouse1
B. \Pipeline1 \Lakehouse1
C. \Pipeline1 \Folder1\Lakehouse1
D. \Folder1\Lakehouse1
Show Answer
Correct Answer: C
Explanation: Deployment pipelines deploy supported items and, with folders support, treat an item's folder path as part of its identity. Since Lakehouse1 was moved into Folder1 before deployment, the target workspace will create Folder1 and place Lakehouse1 there. Pipeline1 remains at the workspace root because it was not moved into the folder.
Sources:
https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-git-deployment-pipelines
Question 69
You need to create a Microsoft Power BI file that will be used to create multiple reports. The solution must meet the following requirements:
• The file must include predefined data source connections.
• The file must include the report structure and formatting.
• The file must NOT contain any data.
Which file format should you use?
A. PBIT
B. PBIDS
C. PBIX
D. PBIP
Show Answer
Correct Answer: A
Explanation: A Power BI Template (.PBIT) stores the report definition, data model schema, queries, measures, formatting, and data source definitions, but excludes the actual data. .PBIX contains data, .PBIDS is a data source connection file only, and .PBIP is a project format rather than a data-free report template.
Question 70
HOTSPOT
-
You have a Fabric tenant that contains a workspace named Workspace_DEV. Workspace_DEV contains the semantic models shown in the following table.
Workspace_DEV contains the dataflows shown in the following table.
You create a new workspace named Workspace_TEST.
You create a deployment pipeline named Pipeline1 to move items from Workspace_DEV to Workspace_TEST.
You run Pipeline1.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Yes
No
No
Explanation: Deployment pipelines deploy supported items (including the dataflow item), but they do not copy semantic model data or semantic model refresh schedules. Only metadata is deployed; the target model must be refreshed and refresh schedules reconfigured.
$19
Get all 204 questions with detailed answers and explanations
Instant download HTML + PDF delivered the moment payment clears.
Secure Stripe checkout we never see or store your card details.
7-day refund if files are defective see our refund policy.
