DP-600 Exam Questions & Answers
Implementing Analytics Solutions Using Microsoft Fabric • Microsoft
100% money-back guarantee
Sample DP-600 Questions
Practice with real exam-style questions, each with the verified correct answer and explanation.
Which syntax should you use in a notebook to access the Research division data for Productlinel?
A)
B)
D)
You have a Fabric workspace named Workspace1 that is assigned to a newly created Fabric capacity named Capacity1.
You create a semantic model named Model1 and deploy Model1 to Workspace1.
You need to publish changes to Model1 directly from Tabular Editor.
What should you do?
In Microsoft Fabric, semantic models (formerly datasets) can be managed using external tools like Tabular Editor. To push or publish changes directly to a Fabric workspace from Tabular Editor, the workspace must support XMLA endpoint connectivity with read-write access.
Explanation of Each Option
A . For Workspace1, enable Git integration.
Git integration allows source control and versioning of items in a Fabric workspace. It is intended for lifecycle management of artifacts and does not provide the connectivity required for Tabular Editor to publish semantic model changes.
B . For Workspace1, create a managed private endpoint.
A managed private endpoint provides secure connectivity between Fabric and external data sources. It is not related to the ability to publish semantic models through XMLA.
C . For Model1, enable external sharing.
External sharing governs who can access the model outside the organization. This does not affect publishing workflows from developer tools.
D . For Capacity1, set XMLA Endpoint to Read Write.
This is the correct choice. The XMLA endpoint provides a programmatic connection point for external tools like Tabular Editor. By default, the XMLA endpoint is enabled only in read-only mode. Changing the setting to Read Write allows developers to push changes, update metadata, and deploy semantic models directly from Tabular Editor into the Fabric workspace.
Summary
To publish changes to a Fabric semantic model using Tabular Editor, the XMLA endpoint of the assigned capacity must be set to Read Write. Without this configuration, Tabular Editor can only connect in read-only mode and cannot deploy updates.
Reference
Use the XMLA endpoint in Microsoft Fabric
Manage capacities in Microsoft Fabric
Your company has a finance department.
You have a Fabric tenant, an Azure Storage account named storagel, and a Microsoft Entra group named Groupl. Groupl contains the users in the finance department.
You need to create a new workspace named Workspacel in the tenant. The solution must meet the following requirements:
* Ensure that the finance department users can create and edit items in Workspace"!.
* Ensure that Workspacel can securely access storagel to read and write data.
* Ensure that you are the only admin of Workspacel.
* Minimize administrative effort.
You create Workspacel.
Which two actions should you perform next? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
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?
Scenario:
Workspace1 contains: Pipeline1 and Lakehouse1.
A folder named Folder1 is created in Workspace1.
Lakehouse1 is moved into Folder1.
A deployment pipeline DeployPipeline1 deploys from Workspace1 Workspace2.
Key Behavior:
Deployment pipelines in Microsoft Fabric maintain the folder hierarchy of items when deploying between workspaces.
If an item (Lakehouse1) is placed in a folder (Folder1), the same folder structure is replicated in the target workspace.
Items not placed in the folder (Pipeline1) remain at the root level.
Result in Workspace2 after deployment:
Pipeline1 remains at the root.
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?
Get access to all 201 verified questions with detailed answers.
Unlock All DP-600 Questions