You have a Fabric tenant that contains a workspace named Workspace1 and a user named User1. Workspace1 contains a warehouse named DW1.
You share DW1 with User1 and assign User1 the default permissions for DW1.
What can User1 do?
A. Build reports by using the default dataset.
B. Read data from the tables in DW1.
C. Connect to DW1 via the Azure SQL Analytics endpoint.
D. Read the underlying Parquet files from OneLake.
Show Answer
Correct Answer: C
Explanation: When a Fabric warehouse is shared with default permissions, the recipient is granted only **Read** permission at the warehouse level. This is equivalent to CONNECT in SQL Server and allows the user to connect to the SQL analytics endpoint, but not to query tables, build reports, or access OneLake files unless additional permissions are explicitly granted.
Question 32
HOTSPOT
-
You have a Fabric warehouse that contains two tables named DimDate and Trips.
DimDate contains the following fields.
Trips contains the following fields.
You need to compare the average miles per trip for statutory holidays versus non-statutory holidays.
How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: SUM(t.tripDistance) / COUNT(t.tripID)
GROUP BY d.IsHoliday
Explanation: Average miles per trip is calculated as total distance divided by number of trips. Grouping by IsHoliday allows comparison between statutory holidays (1) and non-holidays (0).
Question 33
HOTSPOT
-
You have a Fabric tenant that contains a workspace named Enterprise. Enterprise contains a semantic model named Model1. Model1 contains a date parameter named Date1 that was created in Power Query.
You build a deployment pipeline named Enterprise Data that includes two stages named Development and Test. You assign the Enterprise workspace to the Development stage.
You need to perform the following actions:
• Create a workspace named Enterprise [Test] and assign the workspace to the Test stage.
• Configure a rule that will modify the value of Date1 when changes are deployed to the Test stage.
Which two settings should you use? To answer, select the appropriate settings in the answer area.
NOTE: Each correct answer is worth one point.
Show Answer
Correct Answer: Test stage: Assign workspace = Enterprise [Test]
Test stage deployment rules: Semantic model parameter = Date1
Explanation: The Test stage must be linked to the newly created Enterprise [Test] workspace using the Assign a workspace option. To change the Power Query date parameter during deployment, a deployment rule must be configured on the Test stage for the semantic model, targeting the Date1 parameter.
Question 34
HOTSPOT
-
You have a Fabric warehouse that contains the following data.
The data has the following characteristics:
• Each customer is assigned a unique CustomerID value.
• Each customer is associated to a single SalesRegion value.
• Each customer is associated to a single CustomerAddress value.
• The Customer table contains 5 million rows.
• All foreign key values are non-null.
You need to create a view to denormalize the data into a customer dimension that contains one row per distinct CustomerID value. The solution must minimize query processing time and resources.
How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation: All foreign key columns are non-null and relationships are one-to-one for the dimension attributes, so INNER JOINs minimize processing and avoid unnecessary outer-join overhead. The Address table should be joined to CustomerAddress using the matching AddressID foreign key.
Question 35
Your company has a finance department.
You have a Fabric tenant, an Azure Storage account named storage1, and a Microsoft Entra group named Group1. Group1 contains the users in the finance department.
You need to create a new workspace named Workspace1 in the tenant. The solution must meet the following requirements:
• Ensure that the finance department users can create and edit items in Workspace1.
• Ensure that Workspace1 can securely access storage1 to read and write data.
• Ensure that you are the only admin of Workspace1.
• Minimize administrative effort.
You create Workspace1.
Which two actions should you perform next? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Assign the Contributor role to Group1.
B. Create a workspace identity.
C. Assign the Admin role to yourself.
D. Assign the Contributor role to each finance department user.
Show Answer
Correct Answer: A, B
Explanation: To allow finance users to create and edit items with minimal effort, assign the Contributor role to Group1 rather than individual users. To enable Workspace1 to securely read and write data in storage1, you must create a workspace identity and grant it access to the storage account. As the creator, you are already the only admin, so no additional admin assignment is required.
Question 36
DRAG DROP
-
You have a Fabric tenant that contains a workspace named Workspace1. 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 Model1 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.
Show Answer
Correct Answer: Assign Workspace1 to a Fabric capacity.
Connect Workspace1 to a Git provider.
Sync Workspace1 with the repository.
Explanation: Git integration for Fabric workspaces requires the workspace to be assigned to a Fabric capacity. After capacity assignment, the workspace can be connected to an Azure DevOps Git repository. Syncing the workspace then commits existing items, including the semantic model, to the repository.
Question 37
HOTSPOT
-
You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 contains a lakehouse named LH1 and a warehouse named DW1. LH1 contains a table named signindata that is in the dbo schema.
You need to create a stored procedure in DW1 that deduplicates the data in the signindata table.
How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: BEGIN
DISTINCT
Explanation: A standard stored procedure body in a Fabric warehouse starts with BEGIN. To deduplicate rows without performing aggregations, SELECT DISTINCT is the appropriate T-SQL option when reading from the lakehouse table.
Question 38
You have a query in Microsoft Power BI Desktop that contains two columns named Order_Date and Shipping_Date.
You need to create a column that will calculate the number of days between Order_Date and Shipping_Date for each row.
Which Power Query function should you use?
A. DateTime.LocalNow
B. Duration.Days
C. Duration.From
D. Date.AddDays
Show Answer
Correct Answer: B
Explanation: To calculate the number of days between two date columns in Power Query, you subtract the dates to get a duration, then use Duration.Days to extract the day count. For example: Duration.Days([Shipping_Date] - [Order_Date]). The other options do not calculate differences between two dates.
Question 39
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?
A. Get metadata
B. Switch
C. Lookup
D. Append variable
Show Answer
Correct Answer: C
Explanation: In Fabric Data Factory, the Lookup activity is used to execute a query or stored procedure against a warehouse and return its result set. The output of the Lookup activity is available to downstream activities in the pipeline, which satisfies the requirement to use the returned values (active customers and average sales). Other options do not execute stored procedures and return result values for reuse.
Question 40
HOTSPOT
-
You have a Fabric tenant that contains a PySpark notebook named Notebook1.
You define sas_token as a variable in the first cell of Notebook1 and store a shared access signature (SAS) token in the variable.
In the second cell, you run the following code.
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: customers is a pandas DataFrame: No
If a delta table named Customers does NOT exist, an error will be generated: No
The source data is located in the customers folder in a container named contacts: Yes
Explanation: spark.read.parquet creates a Spark DataFrame, not pandas. saveAsTable with mode("overwrite") creates the Delta table if it does not exist. The wasbs URL format is wasbs://<container>@<account>.blob.core.windows.net/<folder>, so the container is contacts and the folder is customers.
$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.
