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 items from a Fabric workspace to an Azure DevOps repository, the user must be allowed to create items and to synchronize workspace items with a Git repository. Enabling **Users can create Fabric items** allows User1 to author items that can be committed. Enabling **Users can synchronize workspace items with their Git repositories** allows committing and syncing changes with Azure DevOps. GitHub-specific settings are not required for Azure DevOps.
Question 52
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 only available for semantic models in workspaces that use Premium capacity or Premium Per User (PPU). A workspace in Pro license mode does not support XMLA connections. Changing the workspace license mode from Pro to Premium (author's choice) enables XMLA support for Model1.
Question 53
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: 1) Rows with RefundStatus = 'Refunded' are not filtered out; Region is still returned, but the statement does not specifically return Region *because* an item is refunded—refunds only affect the SUM value (0).
2) The WHERE clause restricts rows to those whose TransactionDate year equals the current year.
3) The CASE expression excludes refunded sales from TotalRevenue by adding 0 instead of SalesAmount.
Question 54
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.
Show Answer
Correct Answer: Division and Role
Inner join
Explanation: Both queries share Division and Role as common keys, which uniquely identify roles across divisions. Using an Inner join returns only matching rows between Employee and Retired Roles, preventing unmatched rows (nulls) and avoiding duplication that could arise from non-matching records.
Question 55
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: Fabric deployment pipelines deploy supported items and preserve folder paths because folders are treated as part of an item’s name. Lakehouse1 was moved into Folder1 before deployment, so Folder1 is created in Workspace2 and Lakehouse1 is placed inside it. Pipeline1 was not moved into any folder, so it remains at the workspace root. Therefore Workspace2 contains \Pipeline1 and \Folder1\Lakehouse1.
Question 56
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 file (PBIT) stores predefined data source connections, report structure, queries, measures, and formatting without including any actual data. This makes it ideal for creating multiple reports from a standardized template while ensuring no data is embedded.
Question 57
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: DF1 will be deployed to Workspace_TEST: No
Data from Model1 will be deployed to Workspace_TEST: Yes
The scheduled refresh policy for Model1 will be deployed to Workspace_TEST: Yes
Explanation: According to the provided solution image, Dataflow Gen1 items aren’t deployed through deployment pipelines, while the semantic model’s data and its scheduled refresh policy are carried to the target workspace in this scenario.
Question 58
HOTSPOT
-
You have a Fabric tenant that contains the semantic model shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: DirectQuery
undefined
Explanation: The model’s Direct Lake behavior is set to Direct Lake Only, but querying SQL views from a warehouse isn’t supported by Direct Lake, so the engine falls back to DirectQuery. The model shows Roles (0), indicating no row-level or object-level security is defined.
Question 59
HOTSPOT
-
You have the following KQL query.
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
Yes
No
Explanation: Status != "Cancelled" filters out cancelled sales. OrderDate >= ago(30d) limits data to the last 30 days, and summarize computes total sales per product category. The final filter TotalSales > 0 removes categories with zero sales.
Question 60
You have a Fabric tenant that contains a workspace named Workspace1.
You plan to deploy a semantic model named Model1 by using the XMLA endpoint.
You need to optimize the deployment of Model1. The solution must minimize how long it takes to deploy Model1.
What should you do in Workspace1?
A. Select Small semantic model storage format.
B. Select Users can edit data models in the Power BI service.
C. Set Enable Cache for Shortcuts to On.
D. Select Large semantic model storage format.
Show Answer
Correct Answer: D
Explanation: To minimize deployment time when deploying a semantic model via the XMLA endpoint, you should enable the Large semantic model storage format. This setting is recommended even for models that are not inherently large because it significantly improves XMLA write operation performance, which directly affects deployment speed. Other options do not impact XMLA deployment performance.
$19
Get all 189 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.
