You have a Fabric tenant named Tenant1 that contains a workspace named WS1. WS1 uses a capacity named C1 and contains a dataset named DS1.
You need to ensure read-write access to DS1 is available by using XMLA endpoint.
What should be modified first?
To ensure read-write access to a dataset (DS1) using the XMLA endpoint, the settings that need to be modified are at the capacity level (C1). This involves enabling read-write capabilities for the XMLA endpoint within the capacity settings. This configuration is managed through the Admin portal under the capacity settings, where you can set the XMLA endpoint to allow read-write operations. This setting applies to all workspaces and datasets assigned to the capacity.
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.
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.
C1 https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools
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.
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
C1 is Correct.
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
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:
Yes, but the question refers to enabling read-write to the capacity.
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.
No. You are wrong.
C is the right answer. The read/write permission is set in capacity settings in Admin Portal.
First check on capacity level