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: Direct Lake
undefined
Explanation: The semantic model is configured with Direct Lake Behavior = Direct Lake Only, so fallback to DirectQuery is disabled. The model shows Roles (0), so no row-level security is defined, and there is no indication of object-level security; therefore security is undefined.
Question 72
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: The query filters out records with Status == "Cancelled", keeps only records from the last 30 days (OrderDate >= ago(30d)), summarizes total SalesAmount by ProductCategory, then filters to categories where TotalSales > 0, excluding zero-sales categories.
Question 73
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: Enable Large semantic model storage format. Microsoft recommends enabling this setting when using XMLA endpoint-based write operations because it improves XMLA write performance, reducing deployment time even for models that are not especially large.
Question 74
HOTSPOT
-
You have a Microsoft Power Bl project that contains a file named definition.pbir. definition.pbir contains the following JSON.
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
Yes
Explanation: Version 1.0 of definition.pbir is not itself the PBIR-Legacy file format; the semantic model is referenced by a local path (byPath), not a Power BI service connection; a local byPath semantic model opens in Power BI Desktop with full edit capabilities.
Question 75
You have a Fabric warehouse that contains a table named SalesOrderDetail, SalesOrderDetail contains three columns named OrderQty, ProductID and SalesOrderlD. SalesOrderDetail contains one row per combination of SalesOrderlD and ProductID.
You need to calculate the proportion of the total quantity of each sales order represented by each product within the sales order.
Which T-SQL statement should you run?
A.
B.
C.
D.
Show Answer
Correct Answer: D
Explanation: To calculate each product's proportion of the total quantity within its sales order, divide OrderQty by the SUM(OrderQty) computed over a window partitioned by SalesOrderID. Using PARTITION BY SalesOrderID ensures the denominator is the total quantity for that specific order rather than the entire table or an ordered running total.
Question 76
You have a Microsoft Power BI 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?
A. unappliedChanges.json
B. cache.abf
C. localSettings.json
D. model.bim
Show Answer
Correct Answer: B
Explanation: The file that contains the imported semantic model cache, including data values from the data sources, is cache.abf. This binary cache should be excluded from source control to avoid committing model data and unnecessarily large files. While localSettings.json is also commonly ignored because it contains local, user-specific settings, the question specifically asks about preventing data values from data sources from being pushed, which is addressed by excluding cache.abf.
Question 77
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 visualize 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?
A. data categories
B. Data view
C. Model view
D. DAX query view
Show Answer
Correct Answer: C
Explanation: Model view is used to visualize the semantic model and its relationships. It supports creating separate diagrams that include only a subset of tables, such as the Sales fact table and its related dimension tables. Data view shows table data, DAX query view is for writing and testing DAX queries, and data categories are metadata settings, not visualization tools.
Question 78
Note: This section contains one or more sets of questions with the same scenario and problem. Each question presents a unique solution to the problem. You must determine whether the solution meets the stated goals. More than one solution in the set might solve the problem. It is also possible that none of the solutions in the set solve the problem.
After you answer a question in this section, you will NOT be able to return. As a result, these questions do not appear on the Review Screen.
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 create a role in the model.
Does this meet the goal?
A. Yes
B. No
Show Answer
Correct Answer: B
Explanation: No. Simply creating a role does not cause USERNAME() to return the user's UPN. In the Fabric/Power BI service, USERNAME() behavior depends on RLS being defined, but to reliably return the user's UPN you should use USERPRINCIPALNAME(). Creating a role alone does not meet the stated goal.
Question 80
You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1. Lakehouse1 contains a table named Table1. Table1 contains the following data.
You need to perform the following actions:
• Load the data from Table1 into a star schema.
• Create a product dimension table named DimProduct and a fact table named FactSales.
Which three columns should you include in DimProduct?
A. ProductColor, ProductID, and ProductName.
B. ProductName, SalesAmount, and TransactionlD.
C. Date, ProductID, and TransactionlD.
D. ProductID, ProductName, and SalesAmount
Show Answer
Correct Answer: A
Explanation: In a star schema, a product dimension contains descriptive attributes about the product, while the fact table contains transactional measures and event-related fields. ProductID serves as the dimension key, and ProductName and ProductColor are descriptive product attributes. SalesAmount is a measure for the fact table, while TransactionID and Date are transaction/event attributes rather than product dimension attributes.
Question 81
You have a Fabric warehouse named Warehouse1 that contains a table named Table1. Table1 contains customer data.
You need to implement row-level security (RLS) for Table1. The solution must ensure that users can see only their respective data.
Which two objects should you create? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. DATABASE ROLE
B. STORED PROCEDURE
C. CONSTRAINT
D. FUNCTION
E. SECURITY POLICY
Show Answer
Correct Answer: D, E
Explanation: In Microsoft Fabric Warehouse, row-level security is implemented by creating an inline table-valued function that defines the row filter predicate and a SECURITY POLICY that applies that predicate to the target table. A database role may be used to organize permissions but is not a required object for implementing RLS itself.
$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.
