Comprehensive Detailed Explanation
When assigning permissions to roles in a Fabric workspace for analytics workloads, you must align permissions with the responsibilities and tools typically used by each persona:
1. Data Engineers
Their primary tasks include building and transforming data pipelines, as well as making datasets usable by others.
The appropriate permission is Build Reports on the default dataset, because this allows them to create and manage reports using the curated semantic model while preparing data for analysts and scientists.
2. Data Analysts
Analysts work heavily with Apache Spark for exploratory analysis, cleansing, and shaping data.
The correct permission is Read All Apache Spark, as this grants them the ability to query and analyze Spark-based data directly without elevated permissions that are unnecessary for their role.
3. Data Scientists
Data scientists often use SQL analytics endpoints to run queries, train models, and integrate data into machine learning workflows.
The correct permission is Read All SQL analytics endpoint data, since it enables direct programmatic access to the SQL endpoint, which is needed for advanced modeling and experimentation.
Summary of Selections:
DataEngineers → Build Reports on the default dataset
DataAnalysts → Read All Apache Spark
DataScientists → Read All SQL analytics endpoint data
References (Microsoft Fabric – DP-600 exam scope):
Workspace roles and permissions in Microsoft Fabric
SQL analytics endpoint in Fabric
Apache Spark in Microsoft Fabric
