Exam DP-600 topic 1 question 20 discussion

As XMLA is set to Read-Only first, you must go to the capacity settings to enable read-write. https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools#enable-xmla-read-write

The question concerns changing from read-only to read-write (in the Capacity settings), not about enabling XMLA endpoints (in the Tenant settings), which, as per the query, are already set up.

the C1 settings

The XMLA endpoint in Microsoft Fabric allows read-write operations for datasets. To enable read-write access, you must first configure the capacity settings (C1 in this case) to allow XMLA read-write connectivity

the C1 settings

Correct answer is option C) R/W settings of XMLA endpoint is done under capacity settings by fabric admin. By default, read-only connectivity using the endpoint is enabled for the Semantic models. Link for reference: https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools#enable-xmla-read-write

Correct answer is C https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools#:~:text=To%20enable%20read,to%20the%20capacity.

Enable XMLA read-write: Select Settings > Admin portal. In the Admin portal, select Capacity settings > Power BI Premium > capacity name. Expand Workloads. In the XMLA Endpoint setting, select Read Write. The XMLA Endpoint setting applies to all workspaces and semantic models assigned to the capacity.

The right answer is C, You use tenant setting to Allow XMLA endpoints and Analyze in Excel with on-premises datasets. It is read only access but with Capacity settings you can choose between off, read only and read-write

The questions asked what should be modified FIRST. Therefore, I would go with D because C requires that D is activated. Although, I am not sure if D is not activated by default, thus making C the ONLY modification required. I hate it when MS exam questions leave room for interpretation. Why don't they ask for two answers... Weirdly enough Questions 21 covers basically the same topic and there people agree that Tenant settings are definitely required next to capacity settings.

To ensure read-write access to a dataset (DS1) using the XMLA endpoint in your Fabric tenant, you need to modify the settings that control XMLA endpoint access. This typically involves enabling read-write capabilities for the XMLA endpoint at the capacity level. Therefore, you should modify: C. the C1 settings

IMHO, the answer is C. As described here: https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools#enable-xmla-read-write in the section "To enable read-write for a Premium capacity"

we need to first configure tenant settings: Allow XMLA endpoints and Analyze in Excel with on-premises semantic models:

To ensure read-write access to the dataset DS1 via the XMLA endpoint, you should modify the settings at the workspace level (WS1). Specifically, enable read-write operations for the XMLA endpoint within the workspace configuration.

Again, bad wording in the question. If it is specifically about read-write, it's C. If it's about having XMLA endpoints available in the first place, it's D. Judging by Microsoft's wordings and ways of referring to their own documentation, I guess they want us to go for C.

We need to configure several settings but in terms of hierarchy we need to first configure tenant settings: Allow XMLA endpoints and Analyze in Excel with on-premises semantic models: Users in the organization can use Excel to view and interact with on-premises Power BI semantic models. This also allows connections to XMLA endpoints. https://learn.microsoft.com/en-us/fabric/admin/tenant-settings-index

C is the right answer. The read/write permission is set in capacity settings in Admin Portal.