HOTSPOT
-
You have a KQL database that contains a table named Readings.
You need to query Readings and return the results shown in the following table.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: extend
project
Explanation: Use extend to create calculated columns with prev(), then use project to return only the required columns in the output.
Question 42
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. Append variable
B. Script
C. Stored procedure
D. Get metadata
Show Answer
Correct Answer: B
Explanation: Use a Script activity. The requirement is not just to execute a stored procedure, but to make the returned values available to downstream pipeline activities. In Fabric Data Factory, the Stored procedure activity is intended to execute the procedure but does not expose returned result sets/output in the way required for downstream consumption. A Script activity can execute the stored procedure (for example, via EXEC) and expose the result set for later activities.
Question 43
HOTSPOT
-
You have a Fabric warehouse that contains a table named Table1. Table1 contains the following data.
You need to create a T-SQL statement that meets the following requirements:
• Outputs the item name of each item and returns a null value if the item name is longer than 20 characters
• Outputs the PurchaseDate value in the format of МММ dd, yy
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: TRY_CAST(item_name AS varchar(20))
CONVERT(varchar, purchase_date, 7)
Explanation: TRY_CAST to varchar(20) returns NULL when the source string exceeds the target length. CONVERT style 7 formats the date as 'Mon dd, yy' (MMM dd, yy).
Question 44
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: By default, sharing a Fabric Warehouse grants the recipient the Read (CONNECT) permission on the SQL analytics endpoint. This allows the user to connect to the warehouse endpoint but does not grant SELECT on tables, Build permission on the default semantic model, or access to OneLake Parquet files. Reading tables requires additional T-SQL GRANT permissions, and OneLake file access is separate.
Question 45
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
Explanation: Average miles per trip is total miles divided by number of trips. To compare holiday vs non-holiday, aggregate by the IsHoliday flag.
Question 46
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: Assign workspace: Use the 'Deploy to this stage or Assign a workspace' dropdown and assign Enterprise [Test] to the Test stage.
Configure parameter rule: Use the Test stage Edit (pencil) icon to configure Deployment rules and set the Date1 parameter value.
Explanation: The Test stage must first be linked to the new workspace. Deployment pipeline parameter rules for Power Query parameters are configured from the stage settings/edit (pencil), where Date1 can be overridden for the Test stage.
Question 47
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 keys are non-null, so INNER JOIN avoids unnecessary outer join processing. CustomerAddress links Customer to Address through AddressID, so the join to Address is A.AddressID = CA.AddressID. The AddressType filter ensures the main office address, yielding one row per customer.
Question 48
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: Assign the Contributor role to Group1 so all finance department users can create and edit workspace items with minimal administration by managing access through the Entra group. Create a workspace identity so the Fabric workspace can securely authenticate to Azure Storage and be granted read/write permissions on the storage account. The workspace creator is already an admin, so no additional admin assignment is needed to satisfy being the only admin.
Question 49
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: 1. Assign Workspace1 to a Fabric capacity.
2. Connect Workspace1 to a Git provider.
3. Sync Workspace1 with the repository.
Explanation: Git integration for Fabric workspaces requires the workspace to be on Fabric capacity. After connecting the workspace to an Azure DevOps Git repository, syncing commits the existing supported items (including the semantic model) into the repository. Deployment pipelines and branch policies are not required to enable version control.
Question 50
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 stored procedure body starts with BEGIN. To deduplicate rows without aggregation, use SELECT DISTINCT over the required columns from the lakehouse table.
$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.
