In OneLake security, which permission should you assign to User2 to meet the requirement 'Read all SQL endpoint data'?

Prepare for the Fabric Analytics Engineer Associate Test with comprehensive materials. Explore flashcards, multiple choice questions, and detailed explanations. Get ready for your success!

Multiple Choice

In OneLake security, which permission should you assign to User2 to meet the requirement 'Read all SQL endpoint data'?

Explanation:
This tests how permissions map to specific data endpoints in OneLake. To meet the requirement of reading all SQL endpoint data, you need the permission that specifically enables access to data exposed by SQL endpoints. ReadData is designed for reading data via SQL endpoints, providing exactly that scope without granting broader access to other data types or endpoints. Read would be too generic, ReadAll could grant broader access beyond SQL endpoints, and ReadSpark is for Spark endpoints. So ReadData best satisfies the need to read all SQL endpoint data.

This tests how permissions map to specific data endpoints in OneLake. To meet the requirement of reading all SQL endpoint data, you need the permission that specifically enables access to data exposed by SQL endpoints. ReadData is designed for reading data via SQL endpoints, providing exactly that scope without granting broader access to other data types or endpoints. Read would be too generic, ReadAll could grant broader access beyond SQL endpoints, and ReadSpark is for Spark endpoints. So ReadData best satisfies the need to read all SQL endpoint data.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy