Which set of permissions correctly assigns access to data engineers, data analysts, and data scientists to satisfy the security requirements?

• A. Data Engineers: Read All SQL analytics endpoint data; Data Analysts: Build reports on the default datasets; Data Scientists: Read All Apache Spark
• B. Data Engineers: Read All Apache Spark; Data Analysts: Read All SQL analytics endpoint data; Data Scientists: Build reports on the default datasets
• C. Data Engineers: Build reports on the default datasets; Data Analysts: Read All Apache Spark; Data Scientists: Read All SQL analytics endpoint data
• D. Data Engineers: Read All SQL analytics endpoint data; Data Analysts: Build reports on the default datasets; Data Scientists: Read All Apache Spark

Answer: (A)

This question tests how to map permissions to each role so security is maintained while enabling each group to do its work. Data engineers need access to the underlying data sources and endpoints to understand structure, validate data, and support building pipelines, so granting Read All SQL analytics endpoint data aligns with their needs. Data analysts focus on creating reports from pre-approved, default datasets, so Build reports on the default datasets gives them the right scope to deliver insights without accessing broader data. Data scientists typically work with big data processing tools like Apache Spark for modeling and experimentation, so Read All Apache Spark provides the necessary environment for their analysis tasks. Other options mix up these scopes, either giving roles access to data or capabilities that don’t match their responsibilities, which increases risk or reduces effectiveness. This mapping best satisfies the security requirements.