You have a Fabric workspace named Workspace1 that contains a lakehouse.
You have a Microsoft Entra tenant that contains a user named User1.
You need to ensure that User1 can create items in Workspace1. The solution must follow the principle of least privilege.
Which workspace role should you assign to User1?
A. Member
B. Contributor
C. Admin
D. Viewer
Show Answer
Correct Answer: B
Explanation: In Microsoft Fabric workspace roles, Contributor can create, edit, and delete items in the workspace but cannot manage workspace access or settings. Member has additional permissions beyond item creation, Admin has full control, and Viewer is read-only. Therefore, Contributor satisfies the requirement while following the principle of least privilege.
Question 12
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Azure key vault named KeyVault1 that contains secrets.
You have a Fabric workspace named Workspace1. Workspace contains a notebook named Notebook1 that performs the following tasks:
• Loads stage data to the target tables in a lakehouse
• Triggers the refresh of a semantic model
You plan to add functionality to Notebook1 that will use the Fabric API to monitor the semantic model refreshes.
You need to retrieve the registered application ID and secret from KeyVault1 to generate the authentication token.
Solution: You use the following code segment:
Use notebookutils.credentials.putSecret and specify the key vault URL and the name of a linked service.
Does this meet the goal?
A. Yes
B. No
Show Answer
Correct Answer: B
Explanation: The goal is to retrieve a secret from Azure Key Vault. notebookutils.credentials.putSecret stores a secret, whereas notebookutils.credentials.getSecret is used to retrieve a secret from a linked Azure Key Vault. Therefore, using putSecret does not meet the requirement.
Question 13
You have a Fabric workspace named Workspace1 that is connected to a GitHub repository named repo1. Workspace1 contains the items shown in the following table.
You modify Semanticmodel1, Semanticmodel2, and Report2.
You need to commit the changes to repo1.
What is the minimum number of commits you should perform?
A. 1
B. 2
C. 3
D. 4
Show Answer
Correct Answer: B
Explanation: The minimum is two commits. In Fabric Git integration, Power BI reports and their connected semantic models are committed together as a unit. The modified Report2 and Semanticmodel2 can be committed together, while Semanticmodel1 requires a separate commit because it is a different semantic model not grouped with that report. This also aligns with Fabric Git integration commit grouping and size constraints.
Question 14
HOTSPOT
-
You have a Fabric tenant that is linked to a Microsoft Entra tenant. The Microsoft Entra tenant contains a user named User1 and two groups named Group1 and Group2.
The Fabric tenant contains the workspaces shown in the following table.
You need to meet the following access requirements:
• User1 must have read access to the following:
• The operations department reports
• The HR department warehouse and reports
• The legal department warehouse and reports
• User1 must be able to create new items in Workspace2.
• Group1 must have access to the finance department warehouse and reports.
• Group1 must be able to add new users to the finance department workspace.
• Group2 must have access to only the HR warehouse and the legal warehouse.
The solution must follow the principle of least privilege.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Group1: Assign the Admin role for Workspace1.
Group2: Configure only item security for Workspace2.
User1: Assign the Contributor role for Workspace2 and the Viewer role for Workspace4.
Explanation: Group1 needs to manage workspace membership, requiring Admin. Group2 must access only specific warehouses, so item-level security avoids access to all workspace items. User1 needs to create items in Workspace2 (Contributor) and only read operations reports in Workspace4 (Viewer).
Question 15
HOTSPOT
-
You have the development groups shown in the following table.
You have the projects shown in the following table.
You need to recommend which Fabric item to use based on each development group’s skillset. The solution must meet the project requirements and minimize development effort.
What should you recommend for each group? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Group1: An eventstream
Group2: A Dataflow Gen2
Group3: A notebook
Explanation: Eventstream fits Azure Event Hubs/Stream Analytics skills for moving event data. Dataflow Gen2 provides low-code data transformation familiar to Power BI users. Notebooks support R for data transformation.
Question 16
You have a Fabric workspace that contains a lakehouse named Lakehouse1.
In an external data source, you have data files that are 500 GB each. A new file is added every day.
You need to ingest the data into Lakehouse1 without applying any transformations. The solution must meet the following requirements:
• Trigger the process when a new file is added.
• Provide the highest throughput.
Which type of item should you use to ingest the data?
A. Environment
B. Data pipeline
C. Eventstream
D. KQL queryset
Show Answer
Correct Answer: B
Explanation: A Fabric Data pipeline supports event-based triggers for new files and can use the Copy activity to ingest large files directly into a Lakehouse without transformations. Copy activity is optimized for high-throughput bulk data movement, making it the best fit for 500 GB daily files.
Question 17
You have a Fabric workspace named Workspace1 that contains three notebooks named notebook_01, notebook_02, and notebook_03.
You are building a new notebook in Workspace1 that will contain the following Directed Acyclic Graph (DAG) definition.
You need to modify the DAG definition to meet the following requirements:
• Ensure that notebook_01 and notebook_02 run in parallel.
• Ensure that notebook_02 only runs after the execution of notebook_03 is complete.
How should you modify the DAG definition?
A. Create a second DAG definition. Move notebook_03 and notebook_02 to the new DAG definition.
B. Move the notebook_03 declaration to the top of the DAG definition. Add a concurrency to notebook_02 and notebook_01.
C. Create two stages in the DAG definition. Add notebook_03 to the first stage. Add notebook_01 and notebook_02 to the second stage.
D. Move the declaration of notebook_03 to the top of the DAG definition. Add a new stage that contains notebook_01 and notebook_02.
Show Answer
Correct Answer: C
Explanation: Using stages enforces execution order between groups, while notebooks within the same stage can run in parallel. Place notebook_03 in the first stage, then place notebook_01 and notebook_02 in the second stage. This ensures notebook_03 completes before notebook_02 starts, and notebook_01 and notebook_02 execute in parallel.
Question 18
You have a Microsoft Power Apps app named App1 that has data stored in Microsoft Dataverse.
You need to access the App1 data by using Fabric.
What should you use?
A. a data pipeline
B. mirroring
C. Dataflow Gen2
D. a shortcut
Show Answer
Correct Answer: D
Explanation: The requirement is to access existing Dataverse data from Fabric, not copy or transform it. A OneLake shortcut to Dataverse provides direct access to the data without building ingestion or transformation processes. Data pipelines and Dataflow Gen2 are used for copying and transforming data, while mirroring is a different replication capability and is not the standard mechanism for accessing Power Apps Dataverse data in this scenario.
Question 19
HOTSPOT
-
You have Fabric lakehouse that contains a table named Table1. Table1 stores data in the following format.
You have a notebook that contains the following code segment.
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: 1. No
2. No
3. Yes
Explanation: Line 1 only replaces NULL values, not empty strings. Line 2 splits Email on '.' and getItem(1) returns the second element, not the value before the first period. Line 3 extracts the year from OrderDate using year() and aliases it as Year.
Question 20
You have a Fabric workspace that contains a lakehouse named Lakehouse1.
In an external data source, you have data files that are 500 GB each. A new file is added every day.
You need to ingest the data into Lakehouse1 without applying any transformations. The solution must meet the following requirements
• Trigger the process when a new file is added.
• Provide the highest throughput.
Which type of item should you use to ingest the data?
A. Reflex
B. Eventstream
C. Notebook
D. KQL queryset
Show Answer
Correct Answer: C
Explanation: A Notebook is the appropriate Fabric item for ingesting very large batch files (500 GB) into a lakehouse with the highest throughput using Spark, while applying no transformations. Eventstream is designed for streaming/event ingestion rather than large daily batch file loads. Reflex is for event-driven actions, and KQL querysets are for querying, not ingestion.
$19
Get all 132 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.
