nerdexam
Microsoft

DP-600 · Question #18

You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 is assigned to a Fabric capacity. You need to recommend a solution to provide users with the ability to create and publi

The correct answer is A. From the Tenant settings, set Allow XMLA Endpoints and Analyze in Excel with on-premises C. From the Tenant settings, select Users can edit data model in the Power BI service. D. From the Capacity settings, set XMLA Endpoint to Read Write.. To allow external tools to create and publish custom Direct Lake semantic models, specific tenant and capacity settings related to XMLA endpoints and model editing must be enabled.

Submitted by fernanda_arg· Apr 18, 2026Plan, implement, and manage a solution for data analytics

Question

You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 is assigned to a Fabric capacity. You need to recommend a solution to provide users with the ability to create and publish custom Direct Lake semantic models by using external tools. The solution must follow the principle of least privilege. Which three actions in the Fabric Admin portal should you include in the recommendation? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

Options

  • AFrom the Tenant settings, set Allow XMLA Endpoints and Analyze in Excel with on-premises
  • BFrom the Tenant settings, set Allow Azure Active Directory guest users to access Microsoft Fabric
  • CFrom the Tenant settings, select Users can edit data model in the Power BI service.
  • DFrom the Capacity settings, set XMLA Endpoint to Read Write.
  • EFrom the Tenant settings, set Users can create Fabric items to Enabled.
  • FFrom the Tenant settings, enable Publish to Web.

How the community answered

(67 responses)
  • A
    66% (44)
  • B
    9% (6)
  • E
    4% (3)
  • F
    21% (14)

Why each option

To allow external tools to create and publish custom Direct Lake semantic models, specific tenant and capacity settings related to XMLA endpoints and model editing must be enabled.

AFrom the Tenant settings, set Allow XMLA Endpoints and Analyze in Excel with on-premisesCorrect

Enabling 'Allow XMLA Endpoints and Analyze in Excel with on-premises datasets' in tenant settings is foundational for external tools to connect and interact with semantic models using the XMLA protocol.

BFrom the Tenant settings, set Allow Azure Active Directory guest users to access Microsoft Fabric

'Allow Azure Active Directory guest users to access Microsoft Fabric' governs guest access to Fabric resources, not the ability to publish semantic models via external tools.

CFrom the Tenant settings, select Users can edit data model in the Power BI service.Correct

The tenant setting 'Users can edit data model in the Power BI service' must be enabled, as external tools need the underlying capability to modify and publish data models.

DFrom the Capacity settings, set XMLA Endpoint to Read Write.Correct

Setting the Capacity XMLA Endpoint to 'Read Write' mode allows external tools to perform write operations, including creating and publishing new semantic models to the workspace.

EFrom the Tenant settings, set Users can create Fabric items to Enabled.
FFrom the Tenant settings, enable Publish to Web.

Concept tested: Fabric XMLA endpoint configuration for external tools

Source: https://learn.microsoft.com/en-us/fabric/admin/xmla-endpoint-connectivity

Topics

#Fabric Administration#XMLA Endpoints#Semantic Model Management#Tenant & Capacity Settings

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-600 Practice